PHP5 MySQL Config on XP

regards

I just installed Apache/PHP5/MySQL on my Windows PC with XP Home OS. I followed the Tut Installing PHP under Windows by Matthew Phillips Referred to in the Post: Easy to understand Apache/PHP/MySQL install on XP box

This worked OK aside from a couple obvious differences. I had the most troube getting MySQL configured with PHP and had to do some searching to find the answer. Here is what I had to do to get it working.

In the Apache httpd.conf File at 'C:\Program Files\Apache Group\Apache2\conf\httpd.conf' You have to add these lines for PHP5

LoadModule php5_module php5apache2.dll
AddType application/x-httpd-php .php

In addition to installing MySQL etc. I had to do this to get MySQL to work:

1. Make sure that you have a valid php.ini in your windows directory.
OR (Per the tut the 'php.ini' can be installed in the 'C:\Program Files\Apache Group\Apache2' folder. This works fine.)
2. copy libmysql.dll to the system32 directory (php_mysql.dll would not load without doing this)
3. set the extension_dir in php.ini to the ext directory of your PHP installation directory (like e.g. extension_dir=C:\php5\ext)
4. enable the MySQL extension in php.ini by uncommenting the line extension=php_mysql.dll
5. Restart Apache Server

Wink

R-e-g-a-r-d-s

coreymanshack

Thanks, but I'm sure there ARE tutorials out there that tell you all of this anyway, I remember when I first started php I found one, although I can't recall it.

bladesage

I also had trouble getting MySQL to work with PHP on my local server. I sat there for hours, trying so many different solutions, and none of them worked! The thing is, you can still see that the mysql extension is there, if you type C:\php5\php.exe -m into the Command Prompt; so the problem must be between PHP5 and Apache. As it states in the setup instructions for MySQL in the PHP Documentation that, while copying libmysql.dll into the system32 directory will work, it is not wise to do so. You should follow the directions there to add the PHP5 installation directory to the PATH environment variable, instead.

That aside, I found a method that allows me to make almost any PHP extension work, and it even allows me to run multiple versions of PHP at once. Instead of running PHP as an Apache module, run it as a CGI binary. Here's how:

1. In the httpd.conf file, remove the following two lines:

the-guide

Fire Boar

... or just use something like WAMP or XAMPP.

Wink

manav

wamp is great... it's damn dead easy to configure also... try it out

tamilparks

ok i will try with my XP

the-guide