How to enable MySQL support in PHP on IIS

[Rahulnewdelhi]

Hello all

I installed php, mysql and IIS in xp. Problem is this while i run following file

[PHP]<?php
phpinfo();
?>[/PHP]

it doesnt show mysql info table in result. I seen mysql server it is running well. While i am trying to connect my php file to mysql database then it doesnt connect. why it is happening? how to short out this problem, please help me

[Rahulnewdelhi]

hey friend finally i found the solution of this problem. i tell you

after installation of php and mysql check both r working or not.

1. open you php.ini file and find extension=mbstring.dll and remove semicolon ";" before this dll.

2. Find extension=php_mysql.dll and again remove semicolon ";" before this dll

3. Find extension_dir="./" and replace it with extension_dir=c:\php\ext

then save and exit from your php.ini file

4. right click on your mycomputer icon and click properties

(o) Select advance tab

(o) Click on environment variable

(o) Click on new button from system variable area

(o) put PHPRC as variable name and C:\php as variable value and then click several ok

(o) Restart you web server and run php file contained phpinfo(); function and you will see mysql configration table

Hello all

I installed php, mysql and IIS in xp. Problem is this while i run following file

[PHP]<?php
phpinfo();
?>[/PHP]

it doesnt show mysql info table in result. I seen mysql server it is running well. While i am trying to connect my php file to mysql database then it doesnt connect. why it is happening? how to short out this problem, please help me

[Atli]

Thank you for sharing your solution with us.

I'm changing the title to better descripe the contents of the thread.

Moderator

[Snarfblat]

Hi!! Thanks for posting that.

I'm having just that problem, BUT, all of the extensions and directories and stuff are already enabled in my setup, and it still isn't working for me. The only thing that hadn't been done was pointing PHPRC in the Environment vars towards my php installation. So I did that, rebooted, but no good.

I know mySQL is working; I can connect to it with the mySQL Admin. It also works on my two development machines (one Windows, one Linux, but both runing Apache instead of IIS).... just not on THIS server, which is my live server.

I'm considering switching it to Apache, but it's a lot of work for a test...

Any other ideas I can try? Thanks a bunch!!

Rob

[Atli]

Hi Rob.

I've had some problems like this on IIS to.
Sometimes adding the PHP installation directory to the path variable seems to work.

Most of the time when PHP wont load MySQL it's because it can't find the module .dll file, so adding the path to that file into the path variable should do the trick.

If all else fails, you could always try to copy the .dll file into the Windows directory and see what happens.

[Snarfblat]

Man this is weird. I checked PATH and the path to php was already there. So I coped php_mysql.dll into c:\windows. Still nothing.

I think I'm gonna do up an Apache config and see if I can get it working that way... will just run Apache on 8080 for now so I don't have to potentially screw up my live server. ;)

Rob

[zabsmarty]

first of all check that in php.ini that from mysql remove ; (semi colon)