PHPinfo not showing mysql

[jasone]

Hello all,

I am a complete newbie to mysql / php i have installed apache, php and mysql and they are all working independently and php is working with apache.

I have created a database using mysql but when i came to getting the info from the database using php nothing was showing in the browser.

I checked the php info page and i noticed that there is no 'mysql' section so im guessing that php just doesn't realize that is should be communicating with mysql.

please could some one give me step by step instructions to solve this problem, i have installed all the latest versions and it is running on windows xp.

many thanks in advance

Jason

[Atli]

Firstly, you have to go into the php.ini file and find these two line and remove the ; thingies.

Change:
;extension=php_mysql.dll
;extension=php_mysqli.dll
 
Into:
extension=php_mysql.dll
extension=php_mysqli.dll
 

Now you must find the 'ext' directory in your PHP installation directory.
Copy the path to your 'ext' directory and paste it into the php.in file, in the 'extension_dir' line

extension_dir ="D:\Program Files\PHP\ext"
 

Next you must go to that directory and make sure the files from the first two lines you edited are in there. If they are not you must download the ZIP version of PHP from www.php.net and copy the files to the 'ext' directory.

Finally you should go to the PHP directory and copy the 'libmysql.dll' into the 'bin' directory in you Apache root folder.
For example 'C:\Program Files\Apache group\Apache\bin'
(Note that this step may be avoided on windows if the PHP root dir has been added to the enviromental variable 'PATH')

After restarting Apache, your PHP should be able to connect to MySQL.

[jasone]

Hello,

thanks for your reply, i have made all changes as suggested! but the effect is as same as before, there is nothing showing up regarding MYSQL in the 'information' page for PHP and when i try to locally get data from a database the connection is fine but im just getting a blank page.

im sure this is uauly such an easy thing, sorry for the hassle :-S

[jasone]

ok all sorted!

managed to find a pretty good tutorial site, so if anyone gets this problem again, try using the below website:

http://www.expertsrt.com/tutorials/Matt/install-apache.html#dirsetup