From: [EMAIL PROTECTED]
Operating system: Windows 2000
PHP version: 4.0.5
PHP Bug Type: MySQL related
Bug description: Can't connect to mysql after running some code that crashes IIS 5
After running the code below, PHP 4.0.5 is no longer able to connecto to mysql. I
have tested this at 2 different locations, and the result is the same every time.
Also after visiting the website with this code in it, inetinfo.exe (IIS) crashes.
PHP was installed with php405-installer.exe. The problem occurs on Windows 2000
Professional SP1 & SP2. Windows 2000 server has not been tested. Below is the code
that should be pasted into a webpage, and then visited with any browser. I
accidentally caused inetinfo.exe to die with this:
<?
/*
This was written (accidentally) by Tyler Longren <[EMAIL PROTECTED]>.
This was found on accident...thanks to my crappy coding. :)
Date: 05-14-2001
Kills: Inetinfo.exe on Win2k
*/
session_start();
session_register('username');
session_register('password');
header("Location: $PHP_SELF");
if ($formusername) {
mysql_connect("$mysql_host","$mysql_user","$mysql_pass");
mysql_select_db("$mysql_db");
$auth_sql = mysql_query("SELECT * FROM $mysql_user_table WHERE username =
'$formusername' AND password = '$formpassword'");
$user_exists = mysql_num_rows($auth_sql);
if ($user_exists == "1") {
$username = $formusername;
$password = $formpassword;
}
else {
$login_error = "<font face=Arial size=2><b>Error:</b></font><br><font
face=Arial size=1>Wrong<br>username/password</b></font>";
session_unregister('username');
session_unregister('password');
}
}
else {
mysql_connect("$mysql_host","$mysql_user","$mysql_pass");
mysql_select_db("$mysql_db");
$auth_sql = mysql_query("SELECT * FROM $mysql_user_table WHERE username =
'$username' AND password = '$password'");
$user_exists = mysql_num_rows($auth_sql);
if ($user_exists == "1") {
// blah blah blah!
}
else {
$login_error = "<font face=Arial size=2><b>Error:</b></font><br><font
face=Arial size=1><b>Wrong<Br>username/password</b></font>";
session_unregister('username');
session_unregister('password');
}
}
if ($login == "no") {
session_destroy();
session_unregister('username');
session_unregister('password');
header("Location: $PHP_SELF");
}
?>
--
Edit Bug report at: http://bugs.php.net/?id=10930&edit=1
--
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
