Jump to content

how to output the data from php to html?


mark103

Recommended Posts

Hi guys,

I need your help. I have stored the information in mysql database where I can print it out in my 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>";
    }
  }
?>




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

if you do then i need your help.

thanks in advance.

Link to comment
https://forums.phpfreaks.com/topic/276510-how-to-output-the-data-from-php-to-html/
Share on other sites

I dont think your question is clear.  You are already out putting to HTML.  Do you want to create an entire page around it?  like tv.html?

 

If so you can do one of two things. 

 

First is to create a php file with this code inserted into the area you wanted.  Then using mod_rewrite, rewrite your tv.html to your tv.php file.

 

Second you can export all this data to a file your create using like file_put_content

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.