[RESOLVED] PHP won't connect with MySQL 5

timbr8ks

I cannot get PHP to recognize my instance of MySQL.

I'm running Windows XP Pro, and I've just installed PHP 5.2.5 and MySQL 5.0.51a. Both installed fine, and I'm able to get to phpinfo.php without any trouble. I also can access and work with the databases on my computer using Navicat. When I installed PHP, I told it to include these extensions:
- Activescript
- classkit
- Curl
- GD2
- IIS Administration
- MySQL
- PDFlib
- POP3
- SMTP
- SOAP
- Standard PHP Library, Types Addon
- uploadprogress

However, I cannot get PHP to locate the databases. I run this:

$host = "localhost";
$dbase = "myDatabase";
$user = "root";
$password = "[password]";
$link = mysql_connect($Host, $User, $Password) or die('I cannot connect to the database because: ' . mysql_error());

... and nothing happens. I can echo out anything before the $link but cannot echo out anything after the $link. In the php.ini file, I have:

error_reporting = E_ALL; display all errors, warnings and notices
display_errors = On
display_startup_errors = On

But I don't get any errors or anything.

Any ideas as to what I'm missing?

Thanks.

timbr8ks

Update: I needed to restart Windows to have display_errors = On take effect. Now when I run the above script, I get:

Fatal error: Call to undefined function mysql_connect() in C:\Inetpub\wwwroot\mypage\test.php on line 20

timbr8ks

Second update:

The PHP site says:

[INDENT]MySQL is no longer enabled by default, so the php_mysql.dll DLL must be enabled inside of php.ini. Also, PHP needs access to the MySQL client library. A file named libmysql.dll is included in the Windows PHP distribution and in order for PHP to talk to MySQL this file needs to be available to the Windows systems PATH.[/INDENT]

However, the php.ini file says:

[INDENT]Note that MySQL and ODBC support is now built in, so no dll is needed for it.[/INDENT]

Really confused.

timbr8ks

Third update:

I added extension=php_mysql.dll to php.ini, but that did nothing.

Can anyone help?

tsinka

Hi,

check the output of a phpinfo() script to see which php.ini file php loads (just to make sure that you're editing the right php.ini file.

The phpinfo output contains a mysql section if the extension has been loaded successfully. Also make sure that the file libmysql.dll is in a directory that is part of the PATH environment variable (like .e.g. \windows\system32 or \windows).

It might be sufficient to restart the iis admin service in order to enable changes in php.ini. Generally, you need to restart the web server after modifying php.ini.

Thomas

timbr8ks

Thanks, Thomas.

I know I'm editing the right php.ini file, as my changes are reflected in phpinfo. My PATH includes C:\Program Files\PHP\ which is where libmysql.dll is. However, phpinfo does not show anything for MySQL.

tsinka

Check the Windows event viewer for any messages regarding the mysql extension.

I wonder if php has a problem with the whitespace in Program Files ... copy libmysql.dll to system32 and restart iis.

timbr8ks

Nothing in the event viewer about the mysql extension. I copied libmysql.dll to system32 and restarted iis, but that had no effect.

However, each time I restart IIS, when I first launch IE (which pulls up an internal php page as the initial page), a little dialog pop-up appers that says simply ERROR with an OK button. The event viewer reports that this is a pop up, without any further explanation. That pop-up does not occur again unless I restart the computer (or IIS).

timbr8ks

After several hours of fighting with this, I believe I solved my problem. In php.ini, there was this line:

extension_dir = "./"

I changed it to this:

extension_dir = c:/Program Files/php/ext/

And that seemed to work.

Thanks again for your help, Thomas.