Articles island - a directory of quality articles, free quality articles reprint for your web site and email newsletter.
Free Articles Reprint for Your Web Site, Email Newsletter, Blog, Ezine and RSS Feed.
Submit Your Articles to Our Article Directory for Massive Exposure.
Total Live Articles: 92683  Total Categories: 389



 
  Advanced Search
Articles island Expert Author - Rohan Jagtap
Rohan Jagtap is a philosopher. He believes that our life is nothing but the result of Law of Attraction acting upon us. He says you can change your life by changing your own thoughts. He read thousands of articles from web related with LOA. And now he knows LOA gives the answer of any problem that you are facing in your life.
Home » Computers-and-technology » Databases » Setting up Apache - PHP5 & MySQL - A Novices Experience

Articles island Expert Author - articlebuddy007
Author Name:
articlebuddy007

Country:
Australia

Member Since:
12 Jun 2007

Total Live Articles:
21



Email to Friends
Rate this Article
Bookmark this Article
Print this Article
Report this Article
Leave a Comment





Setting up Apache - PHP5 & MySQL - A Novices Experience

By: articlebuddy007
Total views: 23
Word Count: 1165
Date:Jun 12th 2007
Article Rating: No Ratings Yet

As an 'internet Marketing' newbie I recently was forced to set up a server on my laptop so I could properly test web-sites written in php code.

I am pretty much a html sort of guy and have come back around to the internet after an absence of five or six years, to find things have moved on, and that you need to be able to use this sort of stuff to do Internet marketing properly- article sights, pre made web-sites etc.

I was unable to open these 'pre-made' sights directly in Interent explorer and was only able to get a vague idea of what they looked like by opening them in Dreamweaver- which recognizes php code. I tried to open these sites in a web browser but was told I needed a local server. "How do I do that"? I asked.

So, I had no way to see what the final product would look like until I put it on my 'proper' Internet server - not a very efficient way to do things if you want to change elements around.

After a bit of a hunt around on the Internet I discovered that I needed to set up a testing server on my own computer. It seemed the easy way to do this was to get Apache server , PHP, and my SQL database installed on my machine. As there were no e-books available on this. [Is that a Niche Market?] I took a trip to my local bookstore and came away with something I thought would do the job.

There I was, filled with excitement and new ideas that this would all be nice and easy. But of course, it wasn't. My first problem was that the book told me to get Apache 1.3. But I could only find only find an Apache two download.

A search for 'Apache 1.3 download 'gives the following 'official' site

http://httpd.apache.org/download.cgi -but you have to look closely to find the 'ARCHIVE' file! Which is where the 1.3 versions live. Apparently The PHP people don't think their software works as well on the Apache2 software- probably still being ironed out- but I wanted to do what the book says. Find 1.3 versions here:

http://archive.apache.org/dist/httpd/ -

you'll need to go into the 'Binaries' for the windows download. But from there on its fairly simple. You need to fill in a few info boxes during the set up:

for network domain enter: localdomain
for Server Name enter: localhost
for Administrator email- whatever you want

Also choose to 'run as a service for All users'

So I downloaded this and installed it successfully on my computer. I then got PHP five from the 'official' PHP site -
www.php.net/downloads.php

Click the windows ZIP option: , This is not an 'Auto install' you Unzip the files and then copy them to your C:/ drive;

Make a folder and call it 'php' and copy your php files into it.

There are a number of sites on the web that will tell you which files to 'fiddle' with to make the Apache-MySQL/PHP trio work, but to keep it all in one place I'll sumarise here from my experience:

Once you have PHP installed, you will need to navigate to the back to the Apache Folder httpd file -

C:\Apache\conf\httpd.conf

Open it with notepad and find the 'AddModule' section. [Hint: use Control F [windows find] and type 'AddModule'] insert the following lines after the final AddModule command: EXACTLY

#start addition

LoadModule php5_module c:/php/php5apache.dll
AddModule mod_php5.c
AddType application/x-httpd-php .php .phtml

#end addition

the bits with the # will not be recognized. I know this is a bit bamboozling but it was for me too! So don't give up yet.

Next, You will navigate to the Folder contining all the PHP files [should be C:/php] and locate the file labeled

php.ini_recommended

Find the line that says

doc_root =

Change this to read- .

doc_root = "C:\Apache\htdocs"
[if there is a # in front of the doc_root command- remove it or it wil only be seen as a comment]

You also need to locate the command

extension_dir = "./" and replace it with

extension_dir = "C:\php\ext""

The final part of the equation is the MySQL database installation, and here I encountered some problems. As I could only find a copy off my SQL5 instead of four as being suggested in the text.

MySQL 5 installation is pre-packaged, but when I came to the final part of the installation. I encountered a problem. The setup wizard said it could not fully install the database because I did not have TCP permissions on port 3306!!!!

Whaaaaaat....is a port 3306? This one again stumped me, and it was off to the mySQL frequently asked questions. Here, I finally found someone who made sense, and I paraphrase his response for any of you who are having the same problem.

here's what you need to do:

Uninstall MySQL completely, turn the computer off and then run the installer again tick all the boxes along the way.

Go to Windows Firewall. Start - Control Panels - Windows Firewall - Exceptions tab.

Click the "Add Port" button:
Name: mysql
Port: 3306

Click the "Add Program" button.
Browse to where you have installed MySQL ( C:/Programs Files/MySQL/MySQL 5.x.x/bin/mysql )

This seems this seems to satisfy Apache For those using another server you may need to follow the other procedure.

Download the the MySQL Administrator program from
dev.mysql.com or mysql.he.net
Unzip the program and launch "MySQLAdministrator.exe" directly out of the unzipped directory by double clicking on the MySQL Administrator.exe file. put in the following information:

Server host: localhost
Username: root
Password: whatever

Click "OK"

Click on the "Startup Variables" item on the left, then the "Security" tab. Check the checkbox for "Disable grant tables."

Click the "Service Control" item on the left and then the "Start/Stop Service" tab.

Click "Stop Service" -- once the services has stopped, click the button again to start the service.

Thanks to Mike from wimpyplayer.com for the bulk of that info.

So, the outcome I was desiring was partly achieved: I am now able to 'see' a full picture of a PHP webpage in the local browser on my computer- but only when I launch it from 'Dreamweaver' my web editing application, but, only one page at a time - it doesn't act like a proper website, but perhaps that's the next thing for me to learn.

About The Author-- Paul Warren is a Wealth Creation Educator and stock trader. You can download Wealth Creation Audio Books and Free Wealth Creation E-books at his site mymillionairebuddy.com

Article Source: Articles island - Free article submission and free reprint articles


Most Viewed Databases Articles




Most Viewed Databases Articles:

Microsoft Access Database Optimization
Databases love costing your company money and time. There are plenty of reasons you should start fresh, and a...

What The Heck Is An Mup.Sys Error?
There are many error messages. Find out about one that confounds many....

Understanding Data Management and Data Security
Companies today have so much data that flows in and out of the office that they need an effective system in pl...

Developing Data Services And Data Models Training
An important segment of conceptual design process - data models are data structure or data plans that are vita...

When Business Data Goes Bad!
What state is your business data in? If your database is hurting, so is your business. Fix your data, and yo...

Converting Microsoft Access Databases to MySQL
You have a Microsoft Access database that's all cozy and comfy on your desktop, but now it's time to move on t...

Backing up Critical Data: Tape Backup Drives and Tape Libraries
Although tape storage is one of the older ways to backup computer data, it remains one of the most popular and...

Setting up Apache - PHP5 & MySQL - A Novices Experience
If you want to set up a server and database on your local PC using Apache/MySQL and PHP, here's the informatio...

A Nightmare For SEO Hosting
A look at how SEO specialists could be competing for the biggest job ever with the new encylopaedia of life we...


Recent Databases Articles




Recent Databases Articles:

A Nightmare For SEO Hosting
A look at how SEO specialists could be competing for the biggest job ever with the new encylopaedia of life we...

What The Heck Is An Mup.Sys Error?
There are many error messages. Find out about one that confounds many....

Developing Data Services And Data Models Training
An important segment of conceptual design process - data models are data structure or data plans that are vita...

Setting up Apache - PHP5 & MySQL - A Novices Experience
If you want to set up a server and database on your local PC using Apache/MySQL and PHP, here's the informatio...

When Business Data Goes Bad!
What state is your business data in? If your database is hurting, so is your business. Fix your data, and yo...

Microsoft Access Database Optimization
Databases love costing your company money and time. There are plenty of reasons you should start fresh, and a...

Converting Microsoft Access Databases to MySQL
You have a Microsoft Access database that's all cozy and comfy on your desktop, but now it's time to move on t...

Backing up Critical Data: Tape Backup Drives and Tape Libraries
Although tape storage is one of the older ways to backup computer data, it remains one of the most popular and...

Understanding Data Management and Data Security
Companies today have so much data that flows in and out of the office that they need an effective system in pl...

Most Viewed Articles by articlebuddy007




Most Viewed Articles by articlebuddy007:

William Walker Atkinson and the Law of Attraction
William Walker Atkinson's book 'Thought Vibration' or law of attraction in the Thought World (1906) centers o...

Setting up Apache - PHP5 & MySQL - A Novices Experience
If you want to set up a server and database on your local PC using Apache/MySQL and PHP, here's the informatio...

Capturing the Muse - Tips and Tricks
Some tips for capturing your moment of inspiration while staying on the right side of your brain....

Getting Your Song Idea Underway
Getting an idea from the muse can be easy, but how do we pursue it and make it into a finished work?...

Lemonade and The Universal Law of Attraction
How the law of attraction made a simple idea into a money giving lifeline for one man....

Hinduism, Karma and the Law of Attraction
Positive thinking, which is an oft quoted phrase in the law of attraction, also finds its place in Hinduism....

That Law of Attraction Thing Just Doesn't Work
What you can do to get more 'tuned in' to the law of attraction and make it work in your life....

The Law of Attraction and New Thought Theories
All the methods suggested by the new thought movement and the law of attraction are aimed at making an individ...

The Law of Attraction and Manifesting
When you use the secret law of attraction and harness the power of the universe, you open doors for yourself. ...

The Law of Attraction and New Age Theories
New age theories speak to the law of attraction by their emphasis on the potential of the inner voice and the ...

You have permission to publish or reprint this article in your ezine, website, blog, forum, RSS feed or print publication, free of charge. As long as you keep this article with no changes(included Article Title, Article Body, Author Name, Article Source and keep all links in this article active)and you agree to our publisher terms of service. Below are ready HTML code for this article, you can copy and paste directly into your web page.

Setting up Apache - PHP5 & MySQL - A Novices Experience -- HTML Version:


Setting up Apache - PHP5 & MySQL - A Novices Experience -- Summary:

Setting up Apache - PHP5 & MySQL - A Novices Experience -- Keywords:
1   2   3 Good!   4   5   6 Very Good!!   7   8   9   10 Excellent!!!  
Comments:
No Comment Posted.

Leave Comment: Please Login to leave a comment. Not a member yet? Sign Up now.