mark103 Posted April 5, 2013 Share Posted 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 Link to comment https://forums.phpfreaks.com/topic/276583-how-to-print-data-in-html-from-php/ Share on other sites More sharing options...
Barand Posted April 5, 2013 Share Posted 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. Link to comment https://forums.phpfreaks.com/topic/276583-how-to-print-data-in-html-from-php/#findComment-1423183 Share on other sites More sharing options...
mark103 Posted April 5, 2013 Author Share Posted April 5, 2013 what the helll are you talking about old man? Link to comment https://forums.phpfreaks.com/topic/276583-how-to-print-data-in-html-from-php/#findComment-1423190 Share on other sites More sharing options...
Barand Posted April 5, 2013 Share Posted 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. Link to comment https://forums.phpfreaks.com/topic/276583-how-to-print-data-in-html-from-php/#findComment-1423192 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.