PHP5 and MYSQL will not communicate on iis6 server
Posted on 2006-11-09
I have been asked to develop a website on a windows 2003 server running iis6 and mysql 5.0.22 using php5 as the scripting language.
The server already has the mysql database on it and running.
I did a manual install of php5 which appears to be working without a problem. Scripts run when uploaded in web pages etc and a page with phpinfo(); returns the expected php configuration and information.
Only problem is php will not talk to mysql. Any attempt results in a blank page, no errors, just a blank page.
The phpinfo() does not show a mysql section.
What I have already figured out is :-
php5 doesn't come with mysql support enabled. So I made the following changes:-
Edited php.ini so now contains:
extension_dir = "c:/inetpub/php/ext"
php_mysql.dll and php_mysqli.dll are in c:/inetpub/php/ext/
libmySQL.dll is in c:/inetpub/php/
Set the PATH variable to include c:/inetpub/php
When I couldn't get it working I dropped the two extension dll's into c:/windows/system32/ in the hope that might wake it up but to no avail.
Each time I make a change I request a reboot to ensure everything goes through. PHP is defenitely reading the ini file because other settings like the includes directory that I set work fine and the mbstring.dll extension I enabled shows up in the phpinfo page. Just no mysql.
So I am stuck. Any help greatly appreaciated but it can't include.. use a different OS/scripting language/web server as it isn't my choice.