ID: 47059
Updated by: paj...@php.net
Reported By: brian at alternate-zone dot com
-Status: Feedback
+Status: Bogus
Bug Type: MySQL related
Operating System: Windows XP
PHP Version: 5.2.8
New Comment:
not a developer issue, was a libmysql mess > bogus.
Previous Comments:
------------------------------------------------------------------------
[2009-01-15 20:08:07] Stan at MComputerSolutions dot com
I had multiple verions, one set located in C:\Windows\System32, of the
mysql_php.dll and libmysql.dll. All the files where the same verison.
Removed the duplicate files and now PHP can connect to mySQL.
------------------------------------------------------------------------
[2009-01-10 11:08:20] paj...@php.net
I mean which libmysql, for example if you have installed and use mysql
5.1 and libmysql 5.1 dll is used by php.
------------------------------------------------------------------------
[2009-01-10 02:25:56] brian at alternate-zone dot com
I'm using PHP5.2.8 Win32 zip package
and the mysql dll is: php_mysql.dll
------------------------------------------------------------------------
[2009-01-10 00:38:52] paj...@php.net
Which PHP binaries do you use and which mysql DLL?
------------------------------------------------------------------------
[2009-01-10 00:36:28] brian at alternate-zone dot com
Description:
------------
when I try to make a connection to the database Mysql the Apache HTTP
server crashes.
szAppName: httpd.exe szAppVer: 2.2.11.0 szModName: php5ts.dll
szModVerL 5.2.8.8 offset: 00009fe6
Reproduce code:
---------------
<?php
# Define MySQL Settings
define("MYSQL_HOST", "localhost");
define("MYSQL_USER", "root");
define("MYSQL_PASS", "password");
define("MYSQL_DB", "test");
$conn = mysql_connect("".MYSQL_HOST."", "".MYSQL_USER."",
"".MYSQL_PASS."") or die(mysql_error());
mysql_select_db("".MYSQL_DB."",$conn) or die(mysql_error());
$sql = "SELECT * FROM test";
$res = mysql_query($sql);
while ($field = mysql_fetch_array($res))
{
$id = $field['id'];
$name = $field['name'];
echo 'ID: ' . $field['id'] . '<br />';
echo 'Name: ' . $field['name'] . '<br /><br />';
}
?>
Expected result:
----------------
ID: 1
Name: John
Actual result:
--------------
Apache HTTP Server has encountered a problem and needs to close
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=47059&edit=1
