PHP3/Apache seeing MySQL

djstriker

My understanding is that MySQL is suppose to show up in the extensions block of the PHP options (called with phpinfo()). It's not there. Any suggestions on how to get PHP/Apache to see MySQL? PHP and Apache are working by themselves, and MySQL is working by itself. Just need that final link. Any help would be appreciated...

mithril

With PHP3, you still needed to load the MySQL extension. As of PHP4, the MySQL functions are compiled natively into the PHP core. To add MySQL support:

1) Make sure your extension_dir (in php3.ini) is pointing to the folder which contains the php_*.dll files. For example:

   extension_dir = "c:/php/extensions/"

A trailing slash must exist on the path and if you're on Win32 use the Unix-style forward slash instead of the Win32 back slash.

2) Add or uncomment (remove the semi-colon) the following line to php3.ini:

   extension=php_mysql.dll

3) Restart your webserver.

Calling phpinfo() should now reveal the presence of MySQL support. Of course you could always just upgrade to PHP4. Much faster and you'll have more options available to you. PHP3 is not longer being supported or developed. HTH.

Geoff A. Virgo

mithril

Just thought of something, the extension file may have been called php3_mysql.dll. Been so long since I use PHP3 that I forget. In either case, the procedure is the same. Also, if you're on *Nix substitute the .dll file extension for the .so extension.

Geoff

djstriker

Thanks, Geoff. Actually, I had already tried Nos. 2 & 3. I just looked at the extension_dir and it is set as c:\php3 (using the BAK slash). Should they be forward slashes?

I just got a new PHP and MySQL book that came with a CD with PHP4 on it. Perhaps I should upgrade (even thought I just installed PHP3). Would it install right over the old install and take care of my problems (theoretically)?

Thanks.
Douglas

///

djstriker

Well, I updated with PHP4, but the phpinfo() still references php3, and php still cannot find mysql. Perhaps I should look at it again tomorrow...

Douglas

///

djstriker

I think I found the cure thanks to http://www.thickbook.com/extra/php_apachephp4_win.phtml