how to enable mysql on php5.... apache 2.2 on windows

Question

So I've uncommented the the *extension=php_mysql.dll* line in the php.ini file and I've also filled in the *extension_dir* and *doc_root* but everytime I try to run a php file with the following code:

<?php
  mysql_connect("localhost", "root", "admin") or die(mysql_error());
  echo "Connected to MySQL<br />";
?>

I get the following error:

"Fatal error: Call to undefined function mysql_connect() in C:\Program Files\Apache Software Foundation\Apache2.2\vhosts\guestbook\extract.php on line 3"

Does anyone know how to fix this?

[Reference - What does this error mean in PHP?](http://stackoverflow.com/q/12769982/367456) — hakre, Dec 15 '12 at 19:44

score 0 · Accepted Answer · answered Sep 16 '11 at 13:40

0

Your PHP is enabled - that's what's throwing the error you are seeing.

The problem is with the PHP config. The mysql extension is not loaded.

I've uncommented the the *extension=php_mysql.dll* line

And have you checked the file exists in the specified extension dir and is readable by the webserver?

Have you checked that this is the php.ini file your webserver is using? (try running a script with just a call to phpinfo() in it).

answered Sep 16 '11 at 13:40

symcbean

47,736
6
59
94

there were multiple php.ini files and that i think is what caused the problem. as soon as i removed the php.ini file that was already in the windows directory it worked. Thanks for all your help – theNoobProgrammer Sep 20 '11 at 17:24

score 0 · Answer 2 · answered Oct 19 '11 at 17:59

It sounds like you have either not restarted Apache for php.ini changes to take effect, or that you do not have the PHP /ext path in your system PATH variable (or it's set wrong in php.ini).

Consider using a pre-configured and fully set up WAMP package such as:

xampp (free) - WampDeveloper Pro (commercial) - WampServer (free)

how to enable mysql on php5.... apache 2.2 on windows

2 Answers2