Monday, July 21, 2008

Installing Apache 2 and PHP 5 (and MySQL) on Windows XP

Installing Apache 2 and PHP 5 (and MySQL) on Windows XP


  1. Introduction

  2. Set up a directory structure

  3. Download and Install Apache 2.0

  4. Download and Install PHP 5

  5. Configuring Apache

  6. Some extra steps: Setting up a development environment and installing MySQL

  7. Conclusion

0. Introduction

First, a couple short notes on whom this tutorial is for. First, it's for people who want to install
PHP 5 and Apache 2; other versions will follow similar procedures, but they will by no means be identical, and these instructions will not work with them. Second, I've written this mostly with the beginner in mind, with the objective being to walk you through installation and setup of your own local web server to use as a learning and testing tool.That said, the instructions here should serve as useful information for the more experienced web developer/administrator who needs a refresher on installation, or runs into a problem along the way. If you're planning on connecting your server to the internet and serving files to the World, as usual, make sure you know what you're doing first -- you'll get very little sympathy if something goes wrong because you didn't.

On business: In this tutorial, I'll show you how to install Apache and PHP on Windows XP, as well as how to set up a nice working environment. As a bonus, I'll also show you how to install MySQL if you're interesed.

Below are some words of encouragement for those who might not know what all of this means. If you're already convinced, skip ahead to the next section. :-)

Note: If you're a little unsure of what a web server is, it can mean two things: (1) a computer that serves web pages and other content to web browsers and other client programs (this is the definition most people learn first), or (2) a program on a computer
that enables it to serve such content. Apache is a web server as defined in the second sense, i.e. it is software. Once you install it on your computer, you will be able to view web pages, PHP pages, etc, on your local machine as if they were on a site on the internet. In fact, other computers connected to your local network will be able to access the content you serve, and if you choose, you can even make your server available on the internet.

Many people think they need to buy web hosting in order to learn PHP and test their scripts.
You can learn a lot by having some space on a remote server, and they often have many modules and extensions installed and configured, so you can focus on your programming and not have to worry about the details. I learned to program on a remote server, and I picked up a lot of skills, like using the Linux shell, along the way. But you don't have to do it this way. Inevitably, you will eventually want to run a web server on your local machine so you can test scripts quickly and easily, and you might be surprised at how much faster you can actually program if you do this. My advice is, start early and install a web server and PHP on your local machine today!
Like learning to program remotely, it will teach you useful skills. It allows you to program more quickly, to play with different configurations both on- and offline, and best of all, if the web server is free it doesn't cost you a dime. In this tutorial, I will show you how to install one of the most popular web servers, Apache 2.0, and PHP 5 on your Windows XP machine. I'm choosing the Windows environment simply because a lot of people, especially people who are learning to program, have it and I'd like this to be useful to as many people as possible.
Apache and PHP can be installed on other versions of Windows and other operating systems as well. I've chosen Apache because it is immensely popular, and because it is free.

1. Set up a directory structure

First, let's make a directory where you can put PHP and Apache (and maybe other programs such as Perl in the future).
To avoid any potential problems, it's best to create this directory on a path that does not have any spaces. I put mine on a second partition, in the WebServer directory of the Web folder where I keep all my web development data:


Pick something similar for yourself, and create your folder.

Inside that folder, create a folder called PHP. Simple enough: now on to the good stuff.

2. Download and Install Apache 2.0

Note: I've gotten a couple questions about installing PHP 5 with Apache 2.2.
When I first wrote this tutorial, that would not work, because the php5apache2.dll
that came with PHP 5 was incompatible with Apache 2.2. However, PHP 5.2.5 (the latest version as of this revision) includes an php5apache2_2.dll file that is compatible with Apache 2.2. If you want to install Apache 2.2, use this DLL instead when following the instructions in this article. Thanks to Wouter Smit for pointing this out.

First, download the Win32 Binary (MSI Installer — see the note immediately below) from the Apache download page. To the right of the download link, you will see a link called "[MD5]". Follow this link after your file has downloaded, and you will see some text that looks like

Note: If your Windows Installer (msiexec) is not up to date, using an MSI installer may not work properly. In that case (or if you're unsure), you are better off using the EXE installer instead, which you can download from one of Apache's binary mirror sites. 44358b283212d5c144524231fc0cb562 apache_1.3.34-win32-x86-no_src.exe

Leave this page open - we will use it in a minute to verify the integrity of the
installer we just downloaded.

Next, go to
and download the file to the same folder where you saved the Apache installer
(the desktop is fine), and unzip it. Make a new text file in the same folder and put the following in it:

md5sums -p -n -b apache_2.0.55-win32-x86-no_ssl.msi

(if you have downloaded a slighly different version of the installer, change the name of the file to match yours).
Save the file as check_Apache_md5.bat, and run (open) it. The screen that pops up should look something like

Compare the code in the red box to the code on the page opened by the "[MD5]" link. If it is the same, then your file integrity is good, and you can proceed. If it is different, the file is damaged and you should download it again, probably from a different mirror (see the top of the Apache download page).

Once you have a file that is authenticated, you can delete the check_Apache_md5.bat, the file, and the md5sums.exe and md5sums.txt files (although you may want to keep the md5sums program for future use).

Now we're ready to install. Double-click on the installer. Read the agreements and information, clicking next to move through each screen. On the fourth screen, you will see the following:

I'll quote the explanation of each of these settings directly from the Apache documentation:

# Network Domain. Enter the DNS domain in which your server is or will be registered in. For example, if your server's full DNS name is, you would type here.
# Server Name. Your server's full DNS name. From the example above, you
would type here.

# Administrator's Email Address. Enter the server administrator's or
webmaster's email address here. This address will be displayed along
with error messages to the client by default.

# For whom to install Apache Select for All Users, on Port 80, as a
Service - Recommended if you'd like your new Apache to listen at port
80 for incoming traffic. It will run as a service (that is, Apache will
run even if no one is logged in on the server at the moment) Select
only for the Current User, on Port 8080, when started Manually if you'd
like to install Apache for your personal experimenting or if you already
have another WWW server running on port 80.

Here you have a few options:

  • If you are going to be using Apache only for testing scripts on your own machine, you can enter localhost for the first two values and anything you'd like for the email
    address (e.g. admin@localhost). If you're only going to be using Apache sometimes and
    only when you are logged on, it does not make sense to run it as a service, because it will eat up system resources and potentially pose a security risk. Select "only for the Current User, on Port 8080, when started Manually". Press "Next" and skip ahead.

  • If you would like to install Apache to be used as a local area network server, you should set your router to assign the computer you are installing Apache on to have a static LAN ip address (if it does not already have one. This issue is beyond the scope of this article; refer to your router's documentation, or consult the person in charge of your network). Enter either this IP address, or a network name that you will use to acess the server from within your network in the first two boxes (if you choose a name, you will need to update the
    Hosts file of the users on your network so that when they type the name in a browser, it maps to your computer's IP addresss). Enter an appropriate email address in the
    third box, and choose "for All Users, on Port 80, as a Service - Recommended". Press "Next" and skip ahead.

  • If you would like your server to be accessible through the internet, you will need your computer to either have a static internet IP address and set up a domain name server
    (DNS) to point your domain name to your computer's IP (this is beyond the scope of this article). If you do not have a static IP, you can set up your computer to have a static local IP as described in the last paragraph, and use a dynmaic DNS service such as to keep your current IP up to date on the DNS. A good router
    will allow you to automatically update the dynamic DNS when the router acquires an IP address. You will also need to set up port forwarding so that all incoming traffic on port 80 is forwarded to your computers static local IP address. Enter the dynamic DNS domain name, e.g., for the first two entries, and an appropriate email adress for the third. choose "for All Users, on Port 80, as a Service - Recommended". Press "Next" and skip ahead.

If the last paragraph does not make sense, you should probably not do it yet, because there are important security issues you are most likely not aware of. Before setting up a web server to run on the internet, make sure you have educated yourself about all the factors involved. You make your computer available to outsiders at your own risk; if you make it available in ignorance, you do so at your peril.

The next screen you see will look like this:

Choose "Custom" and press "Next". On the following screen
you will see the default path Apache installs to:

Click the "Change..." button (boxed in red in the picture), and choose the WebServer folder (or
whatever other name you chose) you made when you created the directory structure above. Click "Next".

On the next screen click "Install". After it installs click "Finish". Congratulations, you just installed Apache.
It is located in your WebServer folder in the Apache2 directory.

Let's make sure it worked. Go to your programs folder in the Start menu and find the Apache HTTP Server folder.
Go to the Control Apache Server folder, and start Apache

If you installed Apache as a service, you can also start it by double-clicking on the Apache Service Monitor
tray icon (which looks like: ) and pressing the "Start" button in the window that appears.
If you did not install it as a service, you will see a blank command prompt window appear while Apache is running.
This is normal.

The first time you run Apache, you will probably see a security warning pop up:

This is because windows has detected that Apache is opening a port on your computer, and it is checking with you about whether it should let Apache continue. Click the "Unblock" button to allow Apache to function.

Note: While we're talking about these security warnings, it's worth noting that the Winows XP firewall is far from ideal, especially for advanced users. Even compared to most free alternatives, the best you can usually say is that it's better than nothing. Especially if you're considering connecting your web server to the internet, you ought to get a separate firewall program.
Some good freeware/shareware alternatives are ZoneAlarm,
Kerio Personal Firewall,
Agnitum, and
Sygate Personal Firewall.

Now, let's open up a web browser and make sure Apache is running. Type in the name of your server (e.g. localhost, or your domain name or IP address) in the location bar of the browser. If you did not install Apache as a service, follow the server name with :8080 (for example, if you are running the server as localhost, you would type localhost:8080. If Apache is working, you should see a page that looks like

If so, you're ready to move on. If not, something is wrong. It is hard to be sure what, but it might help to ask for assistance in the ERT forum. Otherwise, your best
bet is to uninstall Apache and try again.

Note if you did not install Apache as a service:

Unless you have some reason for Apache to run on port 8080, it is far more convenient to run it on port 80 instead so that you do not have to add on :8080 to your server name every time you type it (port 80 is the default HTTP port). Go to your Apache2 folder, and open the file httpd.conf in the conf folder. On around line 956, you will see

Listen 8080

change that to

Listen 80

Save the httpd.conf file, and restart Apache (in the Service Monitor, or manually quit and
start it again if you have not installed Apache as a service). We'll do more configuration of Apache later.

3. Download and Install PHP 5

The PHP documentation is very good,
I encourage you to read it over a bit before proceeding, or if you get stuck/confused below.

Start by going to the download page and getting the
PHP 5.x.x zip package under the "Windows Binaries" heading. It may seem easier to use the installer, but as you work with PHP, you will probably want to enable several extensions that are not enabled by default, and this is much simpler if you have installed PHP manually.

After the zip file downloads, place it in your WebServer\PHP directory, and unzip it there. When
it is done decompressing all the files, you can delete the zip file. Notice that there are a few executables:

  1. php-cgi.exe: This is used when you run PHP through your webserver as a CGI executable.
  2. php-win.exe: Executes scripts without having to have an open command prompt. You can drag your php scripts onto this program to execute them. You'll use this for local command line (command line interface, or CLI) programs.
  3. php.exe: the CLI interface for command line scripting. You'll use this from the command prompt to execute PHP.

For PHP to work with Apache and to make the CLI available from any command prompt window, we need to add the PHP folder to the PATH environment variable. To do this,
right click on your "My Computer" icon (either on your desktop or the start menu) and select "Properties." In the window that pops up, select the advanced tab, and click on the "Environment Variables" button.

In the window that appears, select the "Path" variable line from the "System Variables" menu, and click edit:

At the end of the "Variable Value" field, type a semicolon (;) and the type in the full path to your
PHP folder. For me, this means typing the following at the end of the "Variable Value" field:

Hit OK in each window until they have all closed, and restart your computer.
Pick up back here when you've restarted.

OK, you restarted and you're back. Let's make sure PHP is working. Go to Start->Run and type cmd and press OK to bring up a command window. At the command prompt, type php -v and press Enter. If you updated the PATH varaible correctly, you should see something like:

PHP 5.1.2 (cli) (built: Jan 11 2006 16:40:00)
Copyright (c) 1997-2006 The PHP Group
Zend Engine v2.1.0, Copyright (c) 1998-2006 Zend Technologies
If you get an error message like,

"php is not recognized as an internal or external command,
operable program or batch file
" go back and check to make sure you completed all the steps
of adding your PHP folder to your PATH variable, and that you typed the file path correctly.

Now open you PHP folder, and change the name of the file php.ini-recommended
to php.ini. The settings in this file are all pretty much exactly as they should be.
If you are installing Apache and PHP on your own system for testing purposes, it is probably a good idea to open your php.ini file in a text editor, and change the setting on or about line
357 from display_errors = Off to display_errors = On so that you will see any errors generated by your scripts and will be able to easily debug them. If you are planning on making
your server public, it is best to leave this setting Off, because displaying errors can expose information about your file system, databases, and server configuration that should be kept private. Either way, the setting on line 367, log_errors = On will ensure that you will have a log of errors that you can review.

Make the following changes to the file:

Line 512: doc_root = D:\Web\WebServer\Apache2\htdocs

Line 519: extension_dir = D:\Web\WebServer\PHP\ext

Save the php.ini file and close it. You can find more information about
configuring PHP in the Runtime Configuration section
of the PHP manual.

4. Configuring Apache

Now that we've got PHP and Apache working separately, we need to get get them to work together.
Go to your Apache2/conf folder, and open up the httpd.conf file in a text
editor. You can get Apache to run PHP as either a CGI binary, or an Apache Module. Generally speaking,
it is faster and more secure to do the latter, which you do by adding the following to your
httpd.conf file:

  1. At the top of the LoadModule section, starting around line 130, add the line

    LoadModule php5_module "D:/Web/WebServer/PHP/php5apache2.dll"

    (note those are foward slashes, not backslashes, in the path) where you
    replace "D:/Web/WebServer/PHP/php5apache2.dll" with the path to php5apache2.dll on your computer (note: if you are installing Apache 2.2, you should use the php5apache2_2.dll file instead). You can actually add settings anywhere you would like, but putting the similar ones together helps keep things organized.

  2. In the AddType section around line 754, add the following line:

    AddType application/x-httpd-php .php

    You can add other extensions besides .php if you want PHP to parse other file types as well. For example, if you want to be able to include PHP in .html documents:

    AddType application/x-httpd-php .php .html

  3. Finally, add the following line, somewhere that seems sensible to you:

    PHPIniDir "D:/Web/WebServer/PHP/"

    (again, replace the path I used with the one you chose on your computer).

Note: If Apache does not seem to recognize your PHPIniDir directive,
make sure you have the trailing slash (i.e. not PHPIniDir "D:/Web/WebServer/PHP"), as mentioned in the user comments in the PHP manual

Save the httpd.conf file, and start Apache as discussed above (or restart it if it is running).

If for some reason you need to run PHP as a CGI binary, add these lines to your httpd.conf file instead.

ScriptAlias /php/ "D:/Web/WebServer/PHP/"
AddType application/x-httpd-php .php
Action application/x-httpd-php "/PHP/php-cgi.exe"
Note that you cannot run PHP as a module and a CGI at the same time. If you are switching between the two types of setups, you'll need to comment-out (with a hash sign #) or delete the existing configuration lines before adding the new ones. Each time you change the server configuration by editing httpd.conf, you'll need to restart Apache for the changes to take effect.

Open your Apache2htdocs folder. This is the root folder for all of your web server documents that you will view in your web browser. Start by erasing all the default files currently in there. Next, make a file called phpinfo.php that contains the following:

<?php phpinfo(); ?>

and save it in your htdocs folder. Now open a web browser and go to

http://localhost/phpinfo.php. You should see a page that looks like

If not, make sure that all the lines that you added to your httpd.conf file are exactly as they appear above (including the trailing slashes where applicable), and that all paths are correct.

5. Some extra steps: Setting up a development environment and installing MySQL

In principle, we're done. You can now start writing your own PHP scripts in your htdocs folder
and viewing them in your web browser (when Apache is running, of course) at http://localhost or whatever URL where you have chosen to locate your webserver. There are a couple more things that are good to do in practice in order to set yourself up with a nice working environment.

  • Place some shortcuts on your desktop. Add one for your htdocs folder for easy access, and another to start Apache (if you're running Apache as a module, you can just as easily use the service monitor).

    Add a folder called PHPCLI to your WebServer directory, where you can will keep you command line PHP scripts. Place a shortcut to this on your desktop too, and make a file called PHPFolder.bat on your desktop that contains the following lines:

    cmd /k cd D:\Web\WebServer\PHPCLI

    This will open a command prompt in your PHPCLI folder so that you can easily test and run your CLI scripts.

  • Enable some extensions. Open up your php.ini file again, and go to abou line 620. There are a whole bunch of lines that look like


    The semicolon (;) is the comment symbol in the php.ini (don't confuse it with the #
    in the httpd.conf), and thus these lines are commented-out, and the extensions are not running. To enable any extensions that you want, just remove the semicolon at the beginning of the line.

Some of the extensions, such as MySQL, require that you have other software installed. In fact, as an added bonus, here's how to install MySQL:

Installing MySQL Server

  1. Go to the MySQL website and download the installer.
    You want the Windows (x86) version (you'll have to scroll down a bit to see it -- don't confuse it with the Windows Essentials version). Note the MD5 checksum, which
    we'll use in step 2. Choose a mirror that is a close to you a possible and download the zip file (or just click "Download" and one will be chosen for you).

  2. Check the MD5 checksum with the value they have next to the download link on the site.
    You do this in the same way you did for Apache above, but this time using the name of the zip file, e.g.

    md5sums -p -n -b

    If it checks out, unzip the file (this will produce a file called Setup.exe), and delete the zip file after it's done. If the checksum does not match, download again from another mirror.

  3. Make a MySQL folder in your WebServer directory. Run Setup.exe.
    Click "Next" at the first screen.
    At the second screen, choose "Custom" for the installation type and click "Next". Click on the "Change" button in the lower left to change the installation directory, and point it to the MySQL folder youjust created:

    Then click "Install" and let it do its thing. When it's done, you can sign up for a account if you want to. Otherwise, choose "Skip Sign-Up" in the bottom left and press Next, and then press Finish on the next screen.

  4. The MySQL Server Instance Configuration Wizard will pop up. Click "Next". Choose "Detailed Configuration"
    and click "Next". Answer the questions according to what kind of machine your computer is. The instructions are fairly straight forward. On the Windows Options Page, you may want to un-check the "Launch MySQLServer automatically" option, and check the Include Bin Directory in Windows PATH so that you can use the MySQL server from the windows command line. It is easiest to Run MySQL as a Windows service.

    Note that you can use the Apache Service monitor to start and stop MySQL (and other services).

    On the next screen, pick a root password. This is the main "superuser" password for your server:

    Finally, click the "Execute" button to configure your MySQL server:

    Its not a big deal if you do not configure your server right at first, you can always run the config wizard again later. It is in your MySQLbin folder, MySQLInstanceConfig.exe.

  5. Restart (this is so your PATH variable gets updated).
  6. Uncomment the line extension=php_mysql.dll (around line 650) in your php.ini
    and (re)start Apache.

  7. Have a look at your phpinfo.php file. If you sucessfully set up MySQL, it should have a section that looks like this:

That's all. Remember to use MySQL with PHP, it has to be running, and you need to create users, tables etc. for PHP to work with. Once MySQL is running, you can access it via the command line by typing mysql -u root -p and entering your root password (which you set during the MySQL installation) when prompted. You can also access the mysqladmin command this way to add other users to your databases (there is also a command line connection option in the MySQL section of your program list in the Start menu).

MySQL Administrator: A Graphical Interface

If you're not comfortable with using MySQL from the command line (or even if you are), you might want to get yourself a graphical administration tool. Several GUIs are available; I use the one made by MySQL, called the MySQL Administrator. Just download it
(be sure to check the MD5 checksum), and run the installer choosing the "Complete" installation type. You can install it anywhere you'd like (I put mine in my Program Files folder). Have a look at the documentation for more information about using MySQL Administrator.

Note: A couple times when I've installed MySQL Server and Administrator, I had trouble connecting to MySQL using the Administrator, even though it worked fine from the command line. I spent a very long time trying to figure out why this happened, and was never able to figure it out for sure. If this happens to you, try reconfiguring MySQL as described above (maybe you made a mistake the first time). If that doesn't work, the problem has always been solved for me by simply uninstalling both the Server and the Administrator (use the Add and Remove Programs option in your Windows XP Control Panel) and reinstalling.

6. Conclusion

Congratulations! You've got a great environment set up for building an testing websites and web applications. Hopefully you didn't find the process too painful. Have fun with it!

oDesk Certified Software Testing Engineer

Tuesday, July 15, 2008

PHP-Mysql Interview Questions

How can we submit a form without a submit button?

The main idea behind this is to use Java script submit() function in order to submit the form without explicitly clicking any submit button. You can attach the document.formname.submit() method to onclick, onchange events of different inputs and perform the form submission. you
can even built a timer function where you can automatically submit the form after xx seconds once the loading is done (can be seen in online test sites).

In how many ways we can retrieve the data in the result set of MySQL using PHP?

You can do it by 4 Ways
1. mysql_fetch_row.

2. mysql_fetch_array

3. mysql_fetch_object

4. mysql_fetch_assoc

What is the difference between mysql_fetch_object and mysql_fetch_array?

mysql_fetch_object() is similar tomysql_fetch_array(), with one difference - an object is returned, instead of an array. Indirectly, that means that you can only access the data by the field names, and not by their offsets (numbers are illegal property names).

What is the difference between $message and $$message?
It is a classic example of PHP’s variable variables. take the following example.$message = “Mizan”;$$message = “is a moderator of PHPXperts.”;$message is a simple PHP variable that we are used to. But the $$message is not a very familiar face. It creates a variable name $mizan
with the value “is a moderator of PHPXperts.” assigned. break it like this${$message} => $mizanSometimes it is convenient to be able to have variable variable names. That is, a variable name which can be set and used dynamically.

How can we extract string ‘ ‘ from a string ‘’
using regular expression of PHP?


echo $found[1];

How can we create a database using PHP and MySQL?

We can create MySQL database with the use of

mysql_create_db(“Database Name”)

What are the differences between require and include, include_once and require_once?

The include() statement includes and evaluates the specified file.The documentation below also applies to require(). The two constructs are identical in every way except how they handlefailure. include() produces a Warning while require() results in a Fatal Error. In other words, use require() if you want a missingfile to halt processing of the page.

include() does not behave this way, the script will continue regardless.

The include_once() statement includes and evaluates the specified file during the execution of the script. This is a behavior similar to the include() statement, with the only differencebeing that if the code from a file has already been included, it will not be included again. As the name suggests, it will be included just once.include_once() should be used in cases where the same file might be included and evaluated more than once during a particularexecution of a script, and you want to be sure that it is included exactly once to avoid problems with function redefinitions, variable value reassignments, etc.
should be used in cases where the same file might be included and evaluated more than once during a particular execution of a script, and you want to be sure that it is included exactly once to avoid problems with function redefinitions, variable value reassignments, etc.

Can we use include (”abc.PHP”) two times in a PHP page “makeit.PHP”?

Yes we can use include() more than one time in any page though it is not a very good practice.

What are the different tables present in MySQL, which type of table is generated when we are creating a table in the following syntax:
create table employee (eno int(2),ename varchar(10)) ?

Total 5 types of tables we can create
2. Heap
3. Merge

MyISAM is the default storage engine as of MySQL 3.23 and as a result if we do not specify the table name explicitly it will be assigned to the default engine.

How can we encrypt the username and password using PHP?
The functions in this section perform encryption and decryption, and compression and uncompression:
encryption decryption




ENCRYPT() Not available

MD5() Not available

OLD_PASSWORD() Not available

PASSWORD() Not available

SHA() or SHA1() Not available


oDesk Certified Software Testing Engineer

Get Flash Designing tips

You can get Flash Designing tips,Slideshow using flash & XML, Highslides using accordian in

oDesk Certified Software Testing Engineer