[RESOLVED] Localhost Does Not Respond When I Try to Create a MySQLi Connection (Win XP)

canbeiro

Hi people,

Two days before I installed MySQL Server 5.1, Apache 2.2 and PHP 5.31 in my Windows XP. Everything seemed ok. I could see the PHP info in my browser opening 'http://localhost/phpinfo.php'. And, from the DOS MySQL Monitor, I also could open MySQL and some of its tables.

But the things gone bad when I tried do access the mysql tables from PHP, instantiating a mysqli object. The browser quickly showed 'Connecting to localhost...' in the status bar and soon after 'Waiting answer from localhost...' for a hole minute. Then, it showed a blank page.

Trying to discover the problem, I simplified the php file to the following:

<?php
$mysqli = new mysqli("localhost" , "root" , "my_password" , "database_name");
if ($mysqli)
echo "OK !";
else
echo "Problem ! " ;
?>

I saved it in the same folder of the phpinfo.php file (the Apache2.2\htdocs folder). When I called it in the browser, the same problem happened again: a hole minute wait and a hole blank page (the "Problem !" string wasn't showed).

The php-errors.log file informs : ' PHP Fatal error: Maximum execution time of 60 seconds exceeded.' 'The connection failed because the connected host did not answer'.

I have already configured the php.ini file with extension_dir = "C:\PHP5.31\ext" and uncommented the extension=php_mysqli.dll line.

I have also configured the httpd.conf file of Apache, adding the line PHPIniDir "C:/PHP5.31/" at its the end.

Can anyone help me to solve this problem ? I will be thankful.

Marcos.

bradgrafelman

On the phpinfo() page, do you see the 'mysqli' table indicating that the extension has been successfully loaded?

canbeiro

bradgrafelman;10935118 wrote:
On the phpinfo() page, do you see the 'mysqli' table indicating that the extension has been successfully loaded?

Thanks for your post, bradgrafelman. Your question is totally pertinent. Now, that I installed XAMPP, and the problem is resolved, I can see the mysqli table. Before, in my separated installation of Apache, PHP and Mysql, when the problem was on, I can not say you, because I wasn't aware of this feature of the phpinfo() page. Thanks for telling me about it and for the instruction on how to signal my thread as resolved. Till the next and the best for you. Marcos.