From: ralphyz at gmail dot com
Operating system: W2K3 SP2
PHP version: 5.2.9
PHP Bug Type: IIS related
Bug description: The Page Cannot Be Displayed
Description:
------------
I get "The Page Cannot Be Displayed" error message when there are 3 print
statements in a row which display the contents of an array (which only has
1 column, and 3 rows). When I comment out any of the three print
statements, the page displays without a problem.
I tested this code on Ubuntu - and it works without a problem.
Also commenting out any of the following three lines makes this work
without a problem:
print ("id: $id <BR>");
print ("name:" . $name . "<BR>");
print ("description:" . $description . "<BR>");
If I comment out any of those lines, but replace the "IF" statement with a
"FOR" statement to run through all my records ($num_rows = 31), I get the
same error (The Page Cannot Be Displayed).
The print statements with "got here" in them seem to have no negative
effect on the script.
Reproduce code:
---------------
<?php
$DBHost = "x.x.x.x"; // IP-address of MySQL server
$DBLogin = "username"; // Username of MySQL user
$DBPassword = "password"; // Password of MySQL user
$DBDatabase = "database"; // Name of database
$db_error = "";
$sql = "select A, B, C from employee";
$data_set = get_data($sql);
$num_rows = mysql_num_rows($data_set);
if($num_rows > 0)
{
$row = mysql_fetch_array($data_set, MYSQL_NUM);
$id = $row[0];
$name = $row[1];
$description = $row[2];
print ("id: $id <BR>");
print ("name:" . $name . "<BR>");
print ("description:" . $description . "<BR>");
print ("got here");
print ("got here");
print ("got here");
print ("got here");
print ("got here");
print ("got here");
print ("got here");
print ("got here");
print ("got here");
print ("got here");
}
function get_data($sql)
{
global $DBHost, $DBLogin, $DBPassword, $DBDatabase, $db_error;
if(!mysql_connect("$DBHost", "$DBLogin", "$DBPassword"))
{
return "$db_error";
}
else
{
mysql_select_db("$DBDatabase");
return mysql_query($sql);
}
}
?>
Expected result:
----------------
This should display:
1
John Smith
Staff
got heregot heregot heregot heregot heregot heregot heregot heregot
heregot here
Actual result:
--------------
The page cannot be displayed
There is a problem with the page you are trying to reach and it cannot be
displayed.
--------------------------------------------------------------------------------
Please try the following:
Open the x.x.x.x home page, and then look for links to the information you
want.
Click the Refresh button, or try again later.
Click Search to look for information on the Internet.
You can also see a list of related sites.
HTTP 500 - Internal server error
Internet Explorer
--
Edit bug report at http://bugs.php.net/?id=48233&edit=1
--
Try a CVS snapshot (PHP 5.2):
http://bugs.php.net/fix.php?id=48233&r=trysnapshot52
Try a CVS snapshot (PHP 5.3):
http://bugs.php.net/fix.php?id=48233&r=trysnapshot53
Try a CVS snapshot (PHP 6.0):
http://bugs.php.net/fix.php?id=48233&r=trysnapshot60
Fixed in CVS:
http://bugs.php.net/fix.php?id=48233&r=fixedcvs
Fixed in CVS and need be documented:
http://bugs.php.net/fix.php?id=48233&r=needdocs
Fixed in release:
http://bugs.php.net/fix.php?id=48233&r=alreadyfixed
Need backtrace:
http://bugs.php.net/fix.php?id=48233&r=needtrace
Need Reproduce Script:
http://bugs.php.net/fix.php?id=48233&r=needscript
Try newer version:
http://bugs.php.net/fix.php?id=48233&r=oldversion
Not developer issue:
http://bugs.php.net/fix.php?id=48233&r=support
Expected behavior:
http://bugs.php.net/fix.php?id=48233&r=notwrong
Not enough info:
http://bugs.php.net/fix.php?id=48233&r=notenoughinfo
Submitted twice:
http://bugs.php.net/fix.php?id=48233&r=submittedtwice
register_globals:
http://bugs.php.net/fix.php?id=48233&r=globals
PHP 4 support discontinued: http://bugs.php.net/fix.php?id=48233&r=php4
Daylight Savings: http://bugs.php.net/fix.php?id=48233&r=dst
IIS Stability:
http://bugs.php.net/fix.php?id=48233&r=isapi
Install GNU Sed:
http://bugs.php.net/fix.php?id=48233&r=gnused
Floating point limitations:
http://bugs.php.net/fix.php?id=48233&r=float
No Zend Extensions:
http://bugs.php.net/fix.php?id=48233&r=nozend
MySQL Configuration Error:
http://bugs.php.net/fix.php?id=48233&r=mysqlcfg
