Printable Version of Topic

Click here to view this topic in its original format

HTMLHelp Forums _ Databases _ blank page

Posted by: minidiapolis Oct 7 2011, 01:16 PM

Why am I getting a blank page with this code?

<?php
require_once("functions.php");
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>

<body>
<?php
DatabaseConnection();

$query= "SELECT * FROM treats";
$result_set= mysql_query($query) or die(mysql_error());

$output = "<table>";
while($row = mysql_fetch_array($result_set))
$product_id = $row['product_id'];
$product_title = $row['product_title'];
$product_Description = $row['product_Description'];
$product_price = $row['product_price'];
{
/*$productDetail1['product_id'];
$productDetail2['product_title'];
$productDetail3['product_Description'];
$productDetail4['price'];
$productDetail5['product_pic']; */
$output .= ("
<tr>
<td>".$row['product_id']."</td>
<td>".$row['product_title']."</td>
<td>".$row['product_Description']."</td>
<td>".$row['product_price']."</td>
</tr>
")
;
$output .= "</table>";
echo $output;
/*while($row = mysql_fetch_array($result))
{
echo "<table>";
echo "</td><td>";
echo $row['product_id'];
echo "</td><td>";
echo $row['product_title'];
echo "</td><td>";
echo "</rd></tr>";
}
echo "</table>";
*/
?>
</body>
</html>

Posted by: Frederiek Oct 7 2011, 02:51 PM

Put the following line of code at the beginning of you PHP file, just after <?php

CODE

ini_set('display_errors','ON');

Surely the page will display errors.

Thse page also might help:
http://php.net/manual/en/function.mysql-fetch-array.php
http://php.net/manual/en/control-structures.while.php
http://www.w3schools.com/PHP/php_mysql_select.asp

Posted by: minidiapolis Oct 7 2011, 04:13 PM

now I'm getting an unexpected $end error.

<?php
/*ini_set ("display_errors", "1");
error_reporting(E_ALL);*/
DatabaseConnection();

$query= "SELECT * FROM treats";
$result_set= mysql_query($query) or die(mysql_error());

$output = "<table>";
while($row = mysql_fetch_array($result_set))
$product_id = $row['product_id'];
$product_title = $row['product_title'];
$product_Description = $row['product_Description'];
$product_price = $row['product_price'];
{
/*$productDetail1['product_id'];
$productDetail2['product_title'];
$productDetail3['product_Description'];
$productDetail4['price'];
$productDetail5['product_pic']; */
$output .= ("
<tr>
<td>".$row['product_id']."</td>
<td>".$row['product_title']."</td>
<td>".$row['product_Description']."</td>
<td>".$row['product_price']."</td>
</tr>
");

$output .= "</table>";
echo $output;
/*while($row = mysql_fetch_array($result))
{
echo "<table>";
echo "</td><td>";
echo $row['product_id'];
echo "</td><td>";
echo $row['product_title'];
echo "</td><td>";
echo "</rd></tr>";
}
echo "</table>";
*/
?>

Posted by: minidiapolis Oct 7 2011, 04:16 PM

found it

Posted by: minidiapolis Oct 7 2011, 04:20 PM

it 's still not displaying anything

<?php
require_once("functions.php");
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>

<body>
<?php
ini_set ("display_errors", "1");
error_reporting(E_ALL);
DatabaseConnection();

$query= "SELECT * FROM treats";
$result_set= mysql_query($query) or die(mysql_error());

$output = "<table>";
while($row = mysql_fetch_array($result_set))
$product_id = $row['product_id'];
$product_title = $row['product_title'];
$product_Description = $row['product_Description'];
$product_price = $row['product_price'];
{
/*$productDetail1['product_id'];
$productDetail2['product_title'];
$productDetail3['product_Description'];
$productDetail4['price'];
$productDetail5['product_pic']; */
$output .= ("
<tr>
<td>".$row['product_id']."</td>
<td>".$row['product_title']."</td>
<td>".$row['product_Description']."</td>
<td>".$row['product_price']."</td>
</tr>
");
}
$output .= "</table>";
echo $output;
/*while($row = mysql_fetch_array($result))
{
echo "<table>";
echo "</td><td>";
echo $row['product_id'];
echo "</td><td>";
echo $row['product_title'];
echo "</td><td>";
echo "</rd></tr>";
}
echo "</table>";
*/
?>
</body>
</html>

Posted by: minidiapolis Oct 7 2011, 09:40 PM

I figured out the problem.