need help with output the data to html

[mark103]

Hi guys,

I have stored the data in mysql database where I can ouput them in php using with this following code:

<?php
session_start();
  define('DB_HOST', 'localhost');
  define('DB_USER', 'mydbusername');
  define('DB_PASSWORD', 'mydbpassword');
  define('DB_DATABASE', 'mydbname');    

  $errmsg_arr = array();
  $errflag = false;
  $link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);

   if(!$link)
  {
    die('Failed to connect to server: ' . mysql_error());
  }
  $db = mysql_select_db(DB_DATABASE);

  if(!$db)
  {
    die("Unable to select database");
  }


  if($errflag)
  {
    $_SESSION['ERRMSG_ARR'] = $errmsg_arr;
    echo implode('<br />',$errmsg_arr);
  }
  else
  {
    $qrytable1="SELECT id, channels FROM tvguide";
    $result1=mysql_query($qrytable1) or die('Error:<br />' . $qry . '<br />' . mysql_error());

 while ($row = mysql_fetch_array($result1))
{
  echo "</br>";
  echo "<td>".$row['channels']."</td>";
  echo "</br>";
}
  }
?>

I want to know how I can output the data from php to html, do you know how?

if so please can you help me.

thanks in advance.

[Emma]

mark103;11026223 wrote:

Hi guys,

I have stored the data in mysql database where I can ouput them in php using with this following code:

<?php
session_start();
  define('DB_HOST', 'localhost');
  define('DB_USER', 'mydbusername');
  define('DB_PASSWORD', 'mydbpassword');
  define('DB_DATABASE', 'mydbname');    

  $errmsg_arr = array();
  $errflag = false;
  $link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);

   if(!$link)
  {
    die('Failed to connect to server: ' . mysql_error());
  }
  $db = mysql_select_db(DB_DATABASE);

  if(!$db)
  {
    die("Unable to select database");
  }


  if($errflag)
  {
    $_SESSION['ERRMSG_ARR'] = $errmsg_arr;
    echo implode('<br />',$errmsg_arr); // The <br> is HTML
  }
  else
  {
    $qrytable1="SELECT id, channels FROM tvguide";
    $result1=mysql_query($qrytable1) or die('Error:<br />' . $qry . '<br />' . mysql_error()); // Error message contains HTML

 while ($row = mysql_fetch_array($result1))
{
  echo "</br>"; // HTML
  echo "<td>".$row['channels']."</td>"; // More HTML here
  echo "</br>"; //Ditto
}
  }
?>

I want to know how I can output the data from php to html, do you know how?

if so please can you help me.

thanks in advance.

You do know you're already out-putting HTML right? Look at your code again I've marked it in the comments

[mark103]

No I haven't, I'm using html seperate with php. Do you know how to output the data from php to html?

[Emma]

Just because your file may end with a .php extension, it doesn't mean you're not out-putting HTML, just look at the source code for this page for example. PHP: Static vs. Dynamic Websites might explain it better.

[traq]

mark103;11026227 wrote:

No I haven't, I'm using html seperate with php

To expound on that idea a little further...

No. Once your page is being parsed by php - even if there is no actual PHP code in it - it is php. The whole thing. Anything your php script outputs goes to the browser - if it happens to be HTML (and it most likely is), then you're using PHP to output HTML. Everything Emma marked is output HTML.

Is there something else that you're trying to accomplish? If so, please be more specific.

[sneakyimp]

It might help to think of it this way:
PHP is a coding language that typically runs on a web server. PHP scripts can output information of pretty much any kind: HTML, CSS, Javascript, XML, RSS.
HTML is a markup language that is intended for display in a browser.