[RESOLVED] a different "phpMyAdmin - Error" error

StevenJ

Hi,

I have been away from PHP/MySQL and stuff for nearly two years now, and would like to continue as a hobbyist - for my website.

I am in the process of setting up my machine with PHP & MySQL and have hit the above problem.

I have installed PHP 5.2.4 first, and got that working with Apache 2.0 (I always previously used Windows IIS), and then I went to install MySQL.

I get the error
Cannot load mysql extension. Please check your PHP configuration.

so, not being stupid, I made sure that I had "uncommented out" the

extension=php_mysql.dll

line, which I had done.

However, the extension_dir was incorrect, at just extension_dir = "./" and it should be extension_dir = "./ext"

so I changed this, reloaded a page with the function phpinfo(); - but this still shows:-

extension_dir as being ./

So, I thought maybe I was editing the wrong php.ini file - but there is only the one on my system - HELP!!

a change to the php.ini file doesn't seem to being noticed

any ideas?

Mucho appreciated.

bradgrafelman

Moved to Install forum.

StevenJ wrote:
it should be extension_dir = "./ext"

I highly doubt that - there's an "ext" directory in the same place as this script? I'm betting you mean "it should be c:/php/ext" or something of that nature.

Sounds like you didn't completely integrate PHP with Apache (and I foresee other steps you probably missed... more about those soon). Firstly, how is PHP integrated with Apache? Did you use the DLL module, or did you go the route of using the CGI binary (phpinfo() will tell you which one at the top if you're not sure).

Assuming you used the DLL module (if not - why??), you need to add the 'PHPIniDir' directive to Apache's httpd.conf file (as explained here: [man]install.windows.apache2[/man]).

Now, back to those other errors I'm foreseeing... did you also add the PHP directory (ex. c:\php) to your system's PATH environment variable? (More info about what I'm talking about can be found in this post).

EDIT: Eh... guess I should've mentioned this first. The link above takes you to my sticky regarding php_mysql.dll, but I just wanted to make sure you saw this before you go any further:

bradgrafelman wrote:
Let me preface this FAQ by suggesting you ditch the MySQL extension - hey, the PHP team already did, that's why it's not enabled by default anymore! - and instead use a more robust set of functions/classes, such as [man]MySQLi[/man] or [man]PDO[/man].

phpMyAdmin is fully capable of using the newer, "improved" [man]MySQLi[/man] extension over the old, deprecated [man]MySQL[/man] one.

StevenJ

bradgrafelman wrote:
Moved to Install forum.

I highly doubt that - there's an "ext" directory in the same place as this script? I'm betting you mean "it should be c:/php/ext" or something of that nature.

Well, that is in the php.ini file in directory c:/php/, and I thought that the ./ext would be relative from where the php.ini would be installed. I also tried specifying the path c:/php/ext but that didn't work.

PHP is fully working, and as you suggested, I had previously configured apache to use the DLL module.

bradgrafelman wrote:
Moved to Install forum.

Now, back to those other errors I'm foreseeing... did you also add the PHP directory (ex. c:\php) to your system's PATH environment variable? (More info about what I'm talking about can be found in this post).

I haven't, no. thanks........

bradgrafelman wrote:
EDIT: Eh... guess I should've mentioned this first. The link above takes you to my sticky regarding php_mysql.dll, but I just wanted to make sure you saw this before you go any further: phpMyAdmin is fully capable of using the newer, "improved" [man]MySQLi[/man] extension over the old, deprecated [man]MySQL[/man] one.

I will also look into this. I actually have got it working, but what I did was just use an old version of MySQL (version 4.some.thing) that I had used previously successfully. Also, there was a change needed to a config file in phpMyAdmin which I had failed to change.

Thank you once again for your reply. I look at the suggestion for MySQLi, and mark this thread RESOLVED.

Cheers