DaniWeb Forum Index > Web Development > PHP

PHP results in Blank Screen

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Apr 2007

Posts: 2

Reputation: Clanham is an unknown quantity at this point

Solved Threads: 0

Clanham

Offline

Newbie Poster

PHP results in Blank Screen

May 2nd, 2007

I am trying to display all data from my MYSQL database but it results in a blank page:

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
 <span class="ad_notxt"><code class="inlinecode">
<?
mysql_connect($host,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM events";
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
echo "<b><center>Database Output</center></b><br><br>";
$i=0;
while ($i < $num) {
$title=mysql_result($result,$i,"title");
$title =mysql_result($result,$i,"title";
$description =mysql_result($result,$i,"description";
$organization =mysql_result($result,$i,"organization";
$start_month =mysql_result($result,$i,"start_month";
$start_day =mysql_result($result,$i,"start_day";
$start_year =mysql_result($result,$i,"start_year";
$start_hour =mysql_result($result,$i,"start_hour";
$start_min =mysql_result($result,$i,"start_min";
$start_ampm =mysql_result($result,$i,"start_ampm";
$end_month =mysql_result($result,$i,"end_month";
$end_day =mysql_result($result,$i,"end_day";
$end_year =mysql_result($result,$i,"end_year";
$end_hour =mysql_result($result,$i,"end_hour";
$end_min =mysql_result($result,$i,"end_min";
$end_ampm =mysql_result($result,$i,"end_ampm";
$time_varies =mysql_result($result,$i,"time_varies";
$location =mysql_result($result,$i,"location";
$street1 =mysql_result($result,$i,"street1";
$street2 =mysql_result($result,$i,"street2";
$city =mysql_result($result,$i,"city";
$zip =mysql_result($result,$i,"zip";
$area =mysql_result($result,$i,"area";
$href =mysql_result($result,$i,"href";
$submitter_name =mysql_result($result,$i,"submitter_name";
$submitter_phone =mysql_result($result,$i,"submitter_phone";
$submitter_email =mysql_result($result,$i,"submitter_email";
$primary =mysql_result($result,$i,"primary";
echo "<b>$title</b>";"$description";"$organization";"$start_month";"$start_day";"$start_year";"$start_hour";"$start_min";"$start_ampm";"$end_month";"$end_day";"$end_year";"$end_hour";"$end_ampm";"$time_varies";"$location";"$street1";"$street2";"$city";"$zip";"$area";"$href";"$submitter_name";"$submitter_phone";"$submitter_email";"$primary";
 
$i++;
}
?>
</code></span>
 <span class="ad_notxt"><code class="inlinecode">
<?
mysql_connect($host,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM events";
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
echo "<b><center>Database Output</center></b><br><br>";
$i=0;
while ($i < $num) {
$title=mysql_result($result,$i,"title");
$title =mysql_result($result,$i,"title";
$description =mysql_result($result,$i,"description";
$organization =mysql_result($result,$i,"organization";
$start_month =mysql_result($result,$i,"start_month";
$start_day =mysql_result($result,$i,"start_day";
$start_year =mysql_result($result,$i,"start_year";
$start_hour =mysql_result($result,$i,"start_hour";
$start_min =mysql_result($result,$i,"start_min";
$start_ampm =mysql_result($result,$i,"start_ampm";
$end_month =mysql_result($result,$i,"end_month";
$end_day =mysql_result($result,$i,"end_day";
$end_year =mysql_result($result,$i,"end_year";
$end_hour =mysql_result($result,$i,"end_hour";
$end_min =mysql_result($result,$i,"end_min";
$end_ampm =mysql_result($result,$i,"end_ampm";
$time_varies =mysql_result($result,$i,"time_varies";
$location =mysql_result($result,$i,"location";
$street1 =mysql_result($result,$i,"street1";
$street2 =mysql_result($result,$i,"street2";
$city =mysql_result($result,$i,"city";
$zip =mysql_result($result,$i,"zip";
$area =mysql_result($result,$i,"area";
$href =mysql_result($result,$i,"href";
$submitter_name =mysql_result($result,$i,"submitter_name";
$submitter_phone =mysql_result($result,$i,"submitter_phone";
$submitter_email =mysql_result($result,$i,"submitter_email";
$primary =mysql_result($result,$i,"primary";
echo "<b>$title</b>";"$description";"$organization";"$start_month";"$start_day";"$start_year";"$start_hour";"$start_min";"$start_ampm";"$end_month";"$end_day";"$end_year";"$end_hour";"$end_ampm";"$time_varies";"$location";"$street1";"$street2";"$city";"$zip";"$area";"$href";"$submitter_name";"$submitter_phone";"$submitter_email";"$primary";
 
$i++;
}
?>
</code></span>

•

Join Date: Aug 2006

Posts: 223

Reputation: Anonymusius is on a distinguished road

Solved Threads: 10

Anonymusius Anonymusius is offline

Offline

Posting Whiz in Training

Re: PHP results in Blank Screen

May 3rd, 2007

•

Originally Posted by Clanham

I am trying to display all data from my MYSQL database but it results in a blank page:
Help with Code Tags

(Toggle Plain Text)
 
<?
mysql_connect($host,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM events";
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
$i=0;
while ($i < $num) {
//code
}
?>
<? mysql_connect($host,$username,$password); @mysql_select_db($database) or die( "Unable to select database"); $query="SELECT * FROM events"; $result=mysql_query($query); $num=mysql_numrows($result); mysql_close(); $i=0; while ($i < $num) { //code } ?>

You misspelled mysql_num_rows, I think that because of that it returned false, so 0. And because of that the entire while loop was never executed.

To shouldn't you get every result manually. I think you should do something like:
[php]
echo "<table>\n<tr><th>Field</th><th>Value</th></tr>\n";
foreach(mysql_fetch_assoc($result) as $key => $value)
{
echo "<tr><td>$key</td><td>$value</td></tr>\n"
}
echo "</table>";
[/php]

I didn't test it, but it should work (for one result, if there are more result you should format the table different).

•

Join Date: Sep 2006

Posts: 57

Reputation: GliderPilot is an unknown quantity at this point

Solved Threads: 2

GliderPilot GliderPilot is offline

Offline

Junior Poster in Training

Re: PHP results in Blank Screen

May 3rd, 2007

As mentioned above mysql_num_rows is misspelled. Your while block is not being executed. There are some other changes you will need to make too or else you will get errors when you try and execute the script.

all your mysql_result lines are missing the ) and the end before the ; except for the first one.

You echo statement is a big mess as well. get rid of all the ; in there. You can do that in a couple different ways:

Help with Code Tags

PHP Syntax (Toggle Plain Text)

echo "<b>$title</b> $description $organization $start_month $start_day $start_year $start_hour $start_min $start_ampm $end_month $end_day $end_year $end_hour $end_ampm $time_varies $location $street1 $street2 $city $zip $area $href $submitter_name $submitter_phone $submitter_email $primary";

This will put them all on one line though. To have each on it's own line just add <br /> tags between each variable. Like this...

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
 
echo "<b>$title</b> <br />
$description <br />
$organization<br />
$start_month <br />
$start_day <br />
etc...
";
 
echo "<b>$title</b> <br />
$description <br />
$organization<br />
$start_month <br />
$start_day <br />
etc...
";

Hopefully this will help

-Chris

http://www.etyn.com

•

Join Date: Apr 2005

Posts: 16,253

Reputation: jbennet is a name known to all

Solved Threads: 540

jbennet

Offline

Moderator

Re: PHP results in Blank Screen

May 3rd, 2007

I had the same problem with PHP ande Mysql but it was in fact that i installed the server wrong (forgot to tell PHP5 where mysql was - PHP5 unlike PHP4 does NOT have mysql support by default)

Last edited by jbennet; May 3rd, 2007 at 2:16 pm.

If i am helpful, please give me reputation points.

•

Join Date: Apr 2007

Posts: 136

Reputation: dr4g is an unknown quantity at this point

Solved Threads: 5

dr4g

Offline

Junior Poster

Re: PHP results in Blank Screen

May 6th, 2007

Yep. Blank page = loop never being executed.

Anonymusius' post about the foreach() will probably be the most important thing, you (Clanham). to learn form these responses.

Good luck on your PHP adventure

GardCMS :: Open Source CMS :: Gardcms.org