how to print data in html from php?

mark103 · April 5, 2013

Hi guys,

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

There is a problem, I can't be able to print the output data in html.

here is the code:

<html>
<body>

<style type="text/css">

#channel1 {
font-family:Arial;
font-size:29px;
font-style:normal;
font-weight:bold;
color:f5fdfd;
text-decoration:none;
text-transform:none;
position:absolute;
visibility:hidden;
overflow:hidden;
left:194px; top:345px; width:176px; height:50px;
z-index:0;
}

#channel2 {
font-family:Arial;
font-size:29px;
font-style:normal;
font-weight:bold;
color:f5fdfd;
text-decoration:none;
text-transform:none;
position:absolute;
visibility:hidden;
overflow:hidden;
left:194px; top:345px; width:176px; height:50px;
z-index:0;
}

#channel3 {
font-family:Arial;
font-size:29px;
font-style:normal;
font-weight:bold;
color:f5fdfd;
text-decoration:none;
text-transform:none;
position:absolute;
visibility:hidden;
overflow:hidden;
left:194px; top:345px; width:176px; height:50px;
z-index:0;
}

#channel4 {
font-family:Arial;
font-size:29px;
font-style:normal;
font-weight:bold;
color:f5fdfd;
text-decoration:none;
text-transform:none;
position:absolute;
visibility:hidden;
overflow:hidden;
left:194px; top:345px; width:176px; height:50px;
z-index:0;
}

#channel5 {
font-family:Arial;
font-size:29px;
font-style:normal;
font-weight:bold;
color:f5fdfd;
text-decoration:none;
text-transform:none;
position:absolute;
visibility:hidden;
overflow:hidden;
left:194px; top:345px; width:176px; height:50px;
z-index:0;
}

#channel6 {
font-family:Arial;
font-size:29px;
font-style:normal;
font-weight:bold;
color:f5fdfd;
text-decoration:none;
text-transform:none;
position:absolute;
visibility:hidden;
overflow:hidden;
left:194px; top:345px; width:176px; height:50px;
z-index:0;
}

<span id="channel1"></span>

<span id="channel2"></span>

<span id="channel3"></span>

<span id="channel4"></span>

<span id="channel5"></span>

<span id="channel6"></span>

function ajaxpage(str)
{
if (str == "")
{
document.getElementById("channel1").innerHTML = "";
document.getElementById("channel2").innerHTML = "";
document.getElementById("channel3").innerHTML = "";
document.getElementById("channel4").innerHTML = "";
document.getElementById("channel5").innerHTML = "";
document.getElementById("channel6").innerHTML = "";
return;
}

if (window.XMLHttpRequest)
{// code for IE7+, Firefox, Chrome, Opera, Safari
xmlhttp=new XMLHttpRequest();
}
else
{// code for IE6, IE5
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
}
xmlhttp.onreadystatechange=function()
{
if (xmlhttp.readyState==4 && xmlhttp.status==200)
{
document.getElementById("channel1").innerHTML=xmlhttp.responseText;
}
}
xmlhttp.open("GET","tvguide.php?q="+str,true);
xmlhttp.send();
}
</script>
<form action="tvguide.php" method="post">
</body>
</html>

do you know how i can print the output data to html from php using with ajax?

any advice would be much appriecated.

thanks in advance

Barand · April 5, 2013

Well, you have an opening <style> tag and a closing </script> tag but I can't see others. A bit of mess all round.

mark103 · April 5, 2013

what the helll are you talking about old man?

Barand · April 5, 2013

Quite simple for other than the simple-minded.

You have an opening <style> tag but no closing </style> tag at end of style definitions.

At the end you launch into javascript code with no opening script tag but you do put a closing </script> tag at the end.

In the middle of it all you have some HTML.

Like I said, it's a mess.

Sign In

how to print data in html from php?

Recommended Posts

mark103

Link to comment

Share on other sites

Barand

Link to comment

Share on other sites

mark103

Link to comment

Share on other sites

Barand

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information