[RESOLVED] Code Results in Blank Page

Rawr

This is strange. In all of my years of coding, I've never had faulty code result in a completely blank page. I've narrowed down the general area of code in question. If there's anything you guys can catch that I wasn't able to, please help me out!

$i=0;
while ($i < $num) {
	$name	= mysql_result($result,$i,"name");
	$vip 	= mysql_result($result,$i,"vip");
	$rank	= mysql_result($result,$i,"rank");
	$kills	= mysql_result($result,$i,"kills");
	$deaths	= mysql_result($result,$i,"deaths");
	$heads	= mysql_result($result,$i,"heads");
	$join	= mysql_result($result,$i,"join");
	$spec	= mysql_result($result,$i,"spec");
	$wars	= mysql_result($result,$i,"wars");
	$gifts	= mysql_result($result,$i,"gifts");

$hsp  = round(($heads/$kills)*100, 0, PHP_ROUND_HALF_DOWN);
$kdr  = round($kills/$deaths, 2, PHP_ROUND_HALF_DOWN);
$days = round(((((strtotime("now")-strtotime($join))/60)/3600)/86400));
switch ($spec) {
	case 0: $spcl = ""; break;
	case 1: $spcl = "Deathmatch"; break;
	case 2: $spcl = "Capture the Flag"; break;
	case 3: $spcl = "Search & Destroy"; break;
}

echo "<tr"; if $vip == 1 {echo ' class="vip">'} else {echo '>'};
echo "<td>$name</td><td>$rank</td><td>$hsp</td><td>$kdr</td><td>$days</td><td>$spcl</td><td>$wars</td><td>$gifts</td></tr>";

$i++;
}

... and for those of you that insist seeing the database connection:

$conn = mysql_connect('***', '***', '***');
$result = mysql_query("SELECT * FROM hs_users");
$num = mysql_numrows($result);
mysql_close();

😕

johanafm

bad:

if $vip == 1

That line ought to give you a parse error. Turn on error logging/output.

sneakyimp

// put something like this at the top
$old_level = error_reporting(-1);
ini_set('display_errors', 1);

Rawr

Thanks for catching the parse error. I fixed it, as well as added the 2 error reporting lines at the top; but to no avail! The page still shows up completely blank. I am going into my site configuration settings to see if there's anything about error reporting there that I can mangle with as well.

If anyone sees anymore possible fixes, please let me know!

sneakyimp

It occurs to me now that if you have a syntax error in your page (which is usually the case with my first run at a script) then PHP never gets to the point where it's actually running any of the commands you have typed.

You are going to need to alter the PHP configuration either for the entire machine by editing PHP.ini (and restarting apache) OR by putting an .htaccess file in your public_html folder. You may find this article helpful:

http://perishablepress.com/press/2008/01/14/advanced-php-error-handling-via-htaccess/

Rawr

Nothing really seems to be working. I made a .htaccess file and placed it first in the subdirectory, then in the site's root. This is the one I used, a la the site provided:

# PHP error handling for development servers
php_flag display_startup_errors on
php_flag display_errors on
php_flag html_errors on
php_flag log_errors on
php_flag ignore_repeated_errors off
php_flag ignore_repeated_source off
php_flag report_memleaks on
php_flag track_errors on
php_value docref_root 0
php_value docref_ext 0
php_value error_log /home/path/public_html/domain/PHP_errors.log
php_value error_reporting 999999999
php_value log_errors_max_len 0

<Files /home/path/public_html/domain/PHP_errors.log>
 Order allow,deny
 Deny from all
 Satisfy All
</Files>

... so then I just started commenting out parts of my code. While doing so, I was able to comment the error lines! This is the source of the problem, apparently:

	if ($vip == 1) {echo '<tr class="vip">'}
		else {echo '<tr>'};

Once I commented that out, the page showed up - with a MySQL error! Yay! Glad I'm able to at least see the error now, it makes debugging so much easier.

# Warning: mysql_numrows(): supplied argument is not a valid MySQL result resource in /hsphere/local/home/c259247/rawrcasm.com/ca/index.php on line 63
#Line 63:
$num = mysql_numrows($result);

😃

Rawr

It seems a good part of the problem was that it wasn't selecting a database, so I added that in there and now I'm getting errors about the rounding functions, so I'm going to go ahead and fix that now. Thanks for everyone's help.

.. still clueless as to why it spits out a blank canvas, even with the additional .htaccess and error reporting lines in the PHP..

johanafm

open a terminal, run
tail -20 /home/path/public_html/domain/PHP_errors.log
and see what's in there.

Also, you're missing a ;

if ($vip == 1) {echo '<tr class="vip">';}

sneakyimp

The PHP.ini on your server probably has display_errors=0. You can ask your hosting provider to change that maybe? The reason the .htaccess file isn't working is an apache config thing. Talk to your hosting provider. You could also try [man]phpinfo[/man] to see what other error-related settings might be involved.

Rawr

johanafm;10924099 wrote:
Also, you're missing a ;

Yeah, I was actually missing two on that line. I went into an IRC channel for help, and after fixing that an a reserved column name in my database, as well as setting the timezone, the errors subsided. Thanks!