Sunday, March 30, 2008

PHP and MySQL at home

I'm a coder/scripter... I'm not the person who deals with or likes to deal with installations of programming/scripting environments which made trying to "serve the web" from home last summer so frustrating.

But I had to get back to that... because I had a new project I wanted to work on that required using PHP and MySQL. So I had to get all that set up. Since I had downloaded (and thought I installed all that) months ago, there have been new releases of both. I went back to mysql.com and php.net and downloaded: mysql-essential-5.0.51a-win32.msi and php-5.2.3-win32-installer.msi respectfully.

Configuring PHP worked well - there are changes to the httpd.conf file found in Apache's setup directory but MySQL was driving me crazy until a friend pointed out that I didn't have the "mysql" extension installed. I had to reinstall PHP with the mysql extension. Once that happened, all was well!

I wish I had seen the following website before I began:
http://www.php-mysql-tutorial.com/

It's fantastic and would have saved me a couple hours. :)

2 comments:

Ryan said...

You could also use Wampserver:
http://www.wampserver.com/en/

I've used it before to set up a wikimedia site running off my home PC. It's pretty much a one-step install.

Cheers,
Ryan

Adeena said...

Well heck - of course someone would make a tool such as that. Never mind all the pain I went through to get these 3 items up and running. When I get my next computer, I'll try this Wampserver. Thanks!