Installing Apache PHP and MySQL on Window Vista

Introduction.

2007-12-17T10:51:00.000-08:00

Are you really pissed off trying again and again to install
these basic web development environments on Windows
Vista and still not getting desired results? Don’t worry you
are at the right place now. I will guide you step by
step to install these free wares effectively. This process
is ridiculously painful and it took me several days to find
out a reliable solution. So, I decided to post this blog
to help installing these packages easily.

Please follow all the chapters in this website carefully
and you will be able to install all three packages without
any trouble.

Also visit:

-> www.neuronsoftsols.com

-> http://online-income-sources.blogspot.com/

GuDLuck!

I have always wanted to make money online, but didn't know where to begin. Prosperly.com supplied me with great internet marketing tips and helped me start making money.

Download Appropriate Packages.

2007-12-15T00:36:00.000-08:00

Most of the people fail to install Apache PHP and

MySQL because they do not download appropriate

packages. So, I am listing packages and links to
download them :

Apache : apache_2.2.6-win32-x86-no_ssl.msi
from http://www.apache.org/

PHP : php-5.2.5-Win32.zip
from http://www.php.net/

MySQL : mysql-5.0.45-win32.zip (with Set up) and
mysql-gui-tools-5.0-r12-win32.msi

from http://dev.mysql.com/downloads/

Also visit :

-> http://online-income-sources.blogspot.com/

to learn genuine money making techniques.

If you are facing any other problem (Error) regarding

Apache PHP and MySQL then please mail me directly

on metech11@gmail.com

GuDLuck!

Disable UAC and IIS.

2007-12-14T01:28:00.000-08:00

Before proceeding to installation we will have to disable
user account control (UAC) and Internet Information
Services (IIS) for the time being. You can enable them
again once installation is complete.

To disable UAC go to
“Start>Control Panel>User Accounts” there you will
find an option “Turn User Account Control on or off”
just click on it and uncheck “User Account Control to
help protect your computer”, click “OK”.

To disable IIS go to “Start>Control Panel>Programs and Features”
on the leftmost side you will find an option
“Turn Windows features on or off” click on it and
uncheck “Internet Information Services”, click “OK”
and restart your computer.

Also visit :

-> http://online-income-sources.blogspot.com/
to learn genuine money making techniques.

If you are facing any other problem (Error)
regarding Apache PHP and MySQL then please
mail me directly on metech11@gmail.com

GuDLuck!

Installing Apche 2.2.6

2007-12-13T01:35:00.000-08:00

Installing apache is easy. Just double click on the icon to run
the installation wizard Click next until you see the Server
Information window. You can enter “localhost” for both the
“Network Domain” and “Server Name”. As for the
administrator's email address you can nter anything you
want.

Click the Next button and choose “Typical installation”,
Click “Next” one more time and choose “C:\Apache\”
as your installation directory instead of
“C:\Program Files\Apache Software Foundation\Apache2.2\”
which is the default installation directory(*Program Files in
Vista is locked by Microsoft Corporation). Click “Next” then
“Install” to complete the installation process. Click the
Next button and choose “Typical installation”. Click “Next”
one more time and choose “C:\Apache\” as your installation
directory instead of
“C:\Program Files\Apache Software Foundation\Apache2.2\”
Which is the default installation directory (*Program Files in
Vista is locked by Microsoft Corporation). Click “Next” then
“Install” to complete the installation process.

To see if your Apache installation was successful open up your
browser and type http://localhost/ in the address bar. If
everything is Okay, you should see a message like this:

It works!

Installing PHP 5.2.5

2007-12-12T03:04:00.000-08:00

Steps to setting up PHP 5.2.5 :

1. Install PHP :

First, extract the PHP package to “C:\PHP\”(make a new
folder name it as “PHP” and extract files in this folder).
Then make a copy of the file “php.ini-recommended” in
PHP directory and rename it to “PHP.ini”. This is the PHP
configuration file and we'll take a look what's in it
later on.

2. Up graders :

Remove the Old PHP.INI File from Your Windows Directory
If you are upgrading to PHP 5 from an older version, go to
your windows directory, typically “c:\windows”, and
delete any php.ini file that you have previously placed
there.

3. Modifying PHP Configuration File (php.ini) :

Now, open “php.ini” in some text editor. I am using
“EditPlus 2” you can choose editor of your choice and
make following changes:

Document Root :

Search for the line that reads “doc_root = ” and replace
it with “doc_root = C:/Apache/htdocs” and then search
for “; cgi.force_redirect = 1” and replace it with
“cgi.force_redirect = 0” (*document root path in php.ini
should be the same as document root path in httpd.conf
in apache server).

Short Open Tags :

Search for the line that read
“short_open_tag = Off” and replace it with
“short_open_tag = On” (* it helps to recognise tags like
“” as start tag for a PHP script).

Magic Quotes :

Similarly, replace “magic_quotes_gpc = Off” with
“magic_quotes_gpc = On”(*this allows your input data
to have the backslash (“\”) prefix).

Register Global :

Verify that register_globals is set to Off
“register_globals = Off” (*if it is set On, it will allow
to write insecure codes).

Modifying Apache Configuration:

Apache doesn't know that you just install PHP. We need
to tell Apache about PHP and where to find it:

1. Open the Apache configuration file in
“C:\Apache\conf\httpd.conf” and add line
PHPIniDir "C:/PHP/" to the top of the file (*this line
indicates the location of php.ini).

2. Add the following lines to the end of the file:

ScriptAlias /php/ "C:/PHP/" (*this line adds script alias
for “cgi-bin”).

Action application/x-httpd-php "C:/PHP/php-cgi.exe"
(*this line tells the server to execute the PHP executable
each time it encounters a PHP script).

AddType application/x-httpd-php-source .phps
(*this line is added so that you can view your php file
source code in the browser window).

LoadModule php5_module "C:/PHP/php5apache2_2.dll"
(*this line tells Apache where to load the dll required to
execute PHP).

If you create a file index.php, and want Apache to load
it as the directory index page for your website, you will
have to add another line to the "httpd.conf" file. To do
this, look for the line in the file that begins with
"DirectoryIndex" and add "index.php" to the list of files
on that line. For example, if the line used to be:
“DirectoryIndex index.html” change it to
“DirectoryIndex index.php index.html”.

Now restart Apache for the changes to take effect
(Start >Programs >Apache HTTP Server 2.2.6 >
Control Apache Server >Restart) .

Open the folder “C:\Apache\htdocs” and delete all the
existing items from it.

To check if everything is okay create a new file, name
it as “test.php” and put it in document root directory
(C:Apache\htdocs). The content of this file
is “< *? phpphpinfo(); *?>” (remove * sign before ?
to get actual content of this file).

phpinfo() is the infamous PHP function which will spit
out all kinds of stuff about PHP and your server
configuration. Type “http://localhost/test.php” on your
browser's address bar and if everything works well you
should see something like this:

also visit:http://webdeeksha.blogspot.com/

Installing MySQL 5.0.45

2007-12-11T03:18:00.000-08:00

Steps to setting up MySQL 5.0.45 :

Firewall Issues :

1.Turn Windows Firewall on :

If you are using firewall other than windows firewall, turn it
“off” and set windows firewall “on” : go to
“Start>Control Panel>Windows Firewall” there you will find
an option “Turn Windows Firewall on or off ” click on it and
turn the Windows Firewall on.

2.Add MySQL Port “3306” to Windows Firewall :

After turning Windows Firewall on look in the same Firewall
Window below “Turn Windows Firewall on or off ” option you
will find an option “Allow a program through Windows
Firewall” click on it, you will find an option “Add Port” click
on it and fill “MySQL” in the “Name” field and “3306” as
“Port number”.

3. Run mysql-5.0.45-win32 Setup.exe :

The welcome window will popup :

Click “Next” :

Select “Custom” and click “Next” :

Now, change the “Folder name” to “C:\MySQl\”
and click “OK” :

Click “install” then Click “Next” to move through a
few advertisements until you find :

Simply, Click “Next” :

Select “Configure the MySQL Server now”
and click “Finish” :

Select “Detailed Configuration” and Click “Next” :

Select “Developer Machine” and Click “Next” :

Select “Multifunctional Database” and Click “Next” :

Click “Next” :

Select “Manual Settings” and Click “Next” :

Do not alter anything simply click “Next” :

Select “Best Support For Multilingualism”
and Click “Next” :

Sect both “Install As Windows Service” and
“Include Bin Directory in Windows Path” and
Click “Next”

Cick “Execute”, If you get a message like :

Configuration file created.
Service started successfully.
Security settings applied .

Then Click “Finish”

Else, If you get an error message Click “Retry”
until you get the above message.

Installing MySQL Gui-tools :

Installing gui-tools is quite easy, just follow the
installation wizard.

GoodLuck!

Fatal error: Call to undefined function mysql_connect()

2007-12-10T12:42:00.000-08:00

After installing Apache PHP MySQL successfully on Vista.
I expected everything to run smoothly. But, it was really
not the case. As I tried to connect to MySQL using PHP code,
I got stuck with the following error:
"Fatal error: Call to undefined function mysql_connect()"

But, finally I cracked the problem. If the same problem
is annoying you, please follow the solution below:

To connect PHP to MySQL "php_mysql.dll" is required.
We need to mention the location "php_mysql.dll" in
"php.ini"(configuration file).

1)Open "php.ini" in some text editor.2) Search for the line
"extension_dir = "./" " and mentionthe path of "ext" folder
in place of "./". For example if youhave installed PHP in
"C:/program Files" then change"extension_dir = "./" " to
"extension_dir = "C:/Program Files/php/ext" ".

3) Search for the line "extension=modulename.extension"
(You will find it in Dynamic Extensions) and change it to
"extension=php_mysql.dll".

Learn to Earn Money Online Visit:
http://online-income-sources.blogspot.com