The Web Design Group

... Making the Web accessible to all.

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> blank page
minidiapolis
post Oct 7 2011, 01:16 PM
Post #1


Serious Coder
*****

Group: Members
Posts: 437
Joined: 3-September 06
Member No.: 57
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>
User is offlinePM
Go to the top of the page
Toggle Multi-post QuotingQuote Post
Frederiek
post Oct 7 2011, 02:51 PM
Post #2


Programming Fanatic
********

Group: Members
Posts: 3,588
Joined: 23-August 06
From: Europe
Member No.: 9
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


--------------------
"The earth does not belong to us. We belong to the earth."
from Vue du ciel (in French)

"Leave scepticism to others and take action"
from HOME by Goodplanet

An inconvenient truth by Al Gore
User is offlinePM
Go to the top of the page
Toggle Multi-post QuotingQuote Post
minidiapolis
post Oct 7 2011, 04:13 PM
Post #3


Serious Coder
*****

Group: Members
Posts: 437
Joined: 3-September 06
Member No.: 57
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>";
*/
?>
User is offlinePM
Go to the top of the page
Toggle Multi-post QuotingQuote Post
minidiapolis
post Oct 7 2011, 04:16 PM
Post #4


Serious Coder
*****

Group: Members
Posts: 437
Joined: 3-September 06
Member No.: 57
found it
User is offlinePM
Go to the top of the page
Toggle Multi-post QuotingQuote Post
minidiapolis
post Oct 7 2011, 04:20 PM
Post #5


Serious Coder
*****

Group: Members
Posts: 437
Joined: 3-September 06
Member No.: 57
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>
User is offlinePM
Go to the top of the page
Toggle Multi-post QuotingQuote Post
minidiapolis
post Oct 7 2011, 09:40 PM
Post #6


Serious Coder
*****

Group: Members
Posts: 437
Joined: 3-September 06
Member No.: 57
I figured out the problem.
User is offlinePM
Go to the top of the page
Toggle Multi-post QuotingQuote Post
« Next Oldest · Databases · Next Newest »
 

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

- Lo-Fi Version Time is now: 20th June 2013 - 03:51 AM
Invision Power Board © 2013  IPS, Inc.
Licensed to: HTMLHelp.com, LLC