Installing PHP 5.2.3, MySql 5.0,Apache2.2 on Windows XP

I am working with WAMP technology . As of my experience newer supposed to be struggle when configure WAMP.Here is the configuration notes of PHP to work with MYSQL and Apache2.2 on a Windows XP machine. These are the steps I took. Hope that they work for you... I installed PHP and MySQL on Windows XP platform with Apache2.2. Please note that PHP,mySQL and Apache is open source , the first thing I did was search google for "Download Apache2.2 " and go to Apache official site to download and Install it. Download Apache2.2 from here (Apache2.2 download link)

* PHP 5.2.9-1 installer [17,304Kb]: Click Here to Download

* Download MySQL 5.0 : Click Here to Download

* Download MySQL 5.0 GUI Tools : MySql 5.0 GUI Tools (Tools to help you administer database)

Installing Apache2.2 If you haven't done so already, download the Apache HTTPD Web Server from the Apache web site . Be sure to download the apache_2.2.11-win32-x86-no_ssl MSI installer here: (http://httpd.apache.org/download.cgi) Save the file to your Windows Desktop. Apache Web Server Install Window Double click the msi file saved on your Windows Desktop. You will see a window that looks like this: Click "Next>". Click the radio button "I accept the terms in the license agreement" Click "Next>". On the next window, again click "Next>". Next, fill in all the text boxes with the following information: "Network Domain": localhost "Server Name": localhost "Administrator's Email Address": your email address Make sure the radio button "for all users, on port 80, as a service - recommended" is selected. Click "Next>". On the next window, click the radio button "Custom", and then click "Next>". On the next window highlight "Apache HTTP Server" and click the "change" button. We are going to install all the packages and scripts in the folder C:\www\Apache2\ (assuming C: is your main hard drive). So in the text box "Folder name:" type in "C:\www\Apache2\". The ending backslash is important. After you have typed in the path, click "OK" and then click "Next>". At this point, you should see a window that looks like this: Apache Ready to Install Click "Install" to begin the installation. Once the Apache installation software has finished installing all the files on your computer, you will see a final window letting you know the installation was a success. Click the "Finish" button. Tips:: To check that the software was in fact installed successfully, open your favorite browser and type "http://localhost/" into the address bar. You should see a page that looks like this: Apache Success

Installing the PHP Instructions for installing the PHP Engine. If you haven’t done so already, download the PHP Windows Binaries - You can download the software from the PHP.net website, (http://www.php.net/downloads.php) Be sure to download PHP 5.0.4 installer Windows installer and PHP 5.0.4 zip package. (Note: the version numbers might be different). Save the files on your Windows Desktop. On your Windows Desktop, double click the PHP installer file. Once you've done that, you should see a window that looks like this: PHP Install Window Click "Next>". On the next window, click "I Agree". On the next window, click the radio button "Advanced", and click "Next>". We're going to install PHP in our server directory instead of the default PHP directory, so in the "Destination Folder" group, click "Browse". A browser window will open. Change the destination directory to "C:\www\php". There is no need for a trailing backslash. Click "OK" on the browser window, and then click "Next>". Select "Next>" on the next three screens. On the following window, leave the SMTP defaults as they are, and click "Next>". If you want, you can enter an email address. This will be used as the "From:" email address when using PHP's mail function. On the next window, make sure that the radio button "Display all errors warnings and notices" is clicked. Then click "Next>". On the next window is where you pick which web server software you are using. Since you have installed Apache, pick "Apache" from the list. Then click "Next>". On the next window make sure that the check box ".php" is checked, and then click "Next>". Now that you have set all the options, you should see a window that looks like this: PHP Ready to Install PHP is ready to install, so click "Next>" to begin the installation. If a message window pops up asking, "Do you want to keep your php.ini file", click "NO". Now a message window should pop up that looks like this: This is normal. Click "OK". When the PHP installer window pops up, click "OK" again. Now PHP is installed, but we need to change some of Apache's settings to get everything working the way it should. In Windows open "My Computer", and browse your way to the folder "C:\www\Apache2\conf". Double click the file "httpd.conf" so we can edit it. This should open the file in Notepad. Scroll to the very bottom of the page, and add these lines: ScriptAlias /php "c:/www/php/" AddType application/x-httpd-php .php Action application/x-httpd-php "/php/php-cgi.exe" You should highlight and copy the text from this page, and then paste it into the httpd.conf page to ensure there are no typos. Hit "Enter" after the last line to ensure there is one blank line at the end of the file. When we installed PHP, it created the file "C:\Windows\php.ini". We want to move that file to the directory "C:\www\php" so it’s easier to edit when we need to. # Open "My Computer" and browse to "C:\Windows". Find the file "php.ini" in the windows directory. Right-click the file and pick "Cut". Now browse to the directory "C:\www\php". Right-click an empty area in the window and select "Paste". This moves the "php.ini" file from the Windows directory to the PHP directory. Now double click the file php-5.0.4-win32.zip that is saved on your desktop. (Note: the version number might be different). Extract the contents of this file to "C:\www\php". Using Notepad, open the file "C:\www\php\php.ini". Find that line that reads: extension_dir = "./" (or something similar, as long as its the line with "extension_dir". Change the line to: extension_dir = "c:\www\php\ext" Now find the line that reads: ;extension=php_mysql.dll Delete the ; so that the line now reads: extension=php_mysql.dll Now open the directory "C:\www\MySQL\bin". Find the file "libmysql.dll". Right-click the file and select "Copy". Browse to the directory "C:\Windows\System32" and Paste the file into that directory. Now you need to restart Apache to ensure the new lines added to the httpd.conf file have an effect. On the Windows taskbar click "Start">"All Programs">"Apache HTTP Server">"Control Apache Server">"Restart". This should restart the Apache server. Now we need to create a test PHP to see if everything is working. Open Notepad (usually found in "Start">"All Programs">"Accessories">"Notepad"), and copy and paste the following lines into a new document: <?PHP phpinfo(); ?> In Notepad, click "File">"Save". Save this file in the directory "C:\www\Apache2\htdocs" as "phpinfo.php". Notepad has a bad habit of adding .txt to the end of all documents you save, so make sure from the "Save" dialog that comes up in Notepad, change "Save as type" from "Text Documents (*.txt)" to "All Files". Now click the "Save" button to save your new PHP document. Open your favorite browser and in the address bar type "http://localhost/phpinfo.php". If everything is set up correctly, you should see a page that looks like this: PHP is now installed! Tips If you want to save your time, use XAMPP software bundle or WITSuite EasyInstaller (WITSuite installation video: http://www.witsuite.com/products/installer/). It is most simple way to install Apache, PHP, MySQL on Windows. Be sure to make these last changes to the Apache configuration file to prevent a 403 FORBIDDEN message when testing to see if PHP has been successfully installed. <Directory "c:/php/"> AllowOverride None Options None Order allow,deny Allow from all </Directory>

INSTALLING MYSQL Step 1: Install MySQL 5.0. Step 2: Install MySQL 5.0 GUI Tools. These will allow you to view your databases and data structures Step 3: Configure an Instance: The best way I configured it to work successfully was once it was installed to go into the "MySQL Server Instance Configuration Wizard" and click "Detailed Configuration", "Developer Machine", "Non-Transactional Database Only", "Decision Support (DSS)/OLAP", "Check Enable TCPIP Netwokring", Port 3306, "Standard Character Set", "Install as a Windows Service", Give it a main password that you remember like "root", Click "Execute!!". *** Please note your username will be "root" and password will be whatever you typed (in this example "root"). After you hit "Execute", You should see 4 buttons light up with no red 'X's and you know MySql is configured correctly! Step 4: Open the MySQL Administrator program. Set server host = localhost, username=root and password=root or whatever you set it to. Click on catalogs, if you see "mysql" then that is a main database. This means that MySQL is installed properly!!

Step 5: I have provided a simple PHP script to test database connection to MYSQL. Copy and paste this into a file call it for example: "testmysql.php" <?PHP<br />//remember to change the password to whatever you set<br />//it to in mysql instance configuration<br /><br />//first parameter is server name, 2nd username 'root', 3rd is password<br />$rst = @mysql_connect("localhost","root","ksbalu");<br /><br />if (!$rst){<br /> echo( "<p>Unable to connect to database manager.</p>");<br /> die('Could not connect: ' . mysql_error());<br /> exit();<br />} else {<br /> echo("<p>Successfully Connected to MySQL Database Manager!</p>");<br />}<br /><br />if (! @mysql_select_db("mysql") ){<br /> echo( "<p>Unable to connect database...</p>");<br /> exit();<br />} else {<br /> echo("<p>Successfully Connected to Database 'MYSQL'!</p>");<br />}<br />?><br /> and place it into the web root folder (same folder as "phptest.php")

Step 6: If you run this script by typing: http://127.0.0.1/testmysql.php and it says "Successfully Connected to MySQL Database Manager!" and "Successfully Connected to Database 'MYSQL'" then this means that MySQL is now communicating with PHP and is installed and working properly!!! Hope it helped!