Want to learn PHP

Posted on 2013-02-06
Last Modified: 2013-02-07
I'd like to learn something about PHP.  I am a retired network administrator (I worked on small systems, not giant installations) .  I have programmed some systems using Access and SQL SERVER 2000 so I am familiar with database and table constructs (third normal form, etc).

I thought I'd learn PHP by developing a simple recipe database.  I could do it by using Access and SQL SERVER but my server is old and dying, I have SQL SERVER 2000 and that is out of date.  I don't want to buy a new server and I don't want to spend money on buying software licenses.

I have some questions :

1.)  Is PHP free? If not, what is the cost ?

2.) What is required to install PHP  on a Windows 7 Pro pc?
     (perhaps you know of web sites which will answer this question)

3.)  My pc is an HP z210 , i3 processor with 8 gigs of memory.  I assume this is sufficient to run PHP?

4.)  My understanding is Mysql is no longer free.  What is needed to get PHP to work with postgreSQL?

Thank you for your help
Question by:donpick
  • 3
  • 3
  • 2
  • +3
LVL 36

Expert Comment

by:Loganathan Natarajan
ID: 38862533
PHP is free and it is open source . ref.

also you can easily install in Win 7.. by installing this suite.
LVL 36

Expert Comment

by:Loganathan Natarajan
ID: 38862537
My understanding is Mysql is no longer free.  What is needed to get PHP to work with postgreSQL?

yes, as long as it is private app, you need not worry as to use free. but for commercial selling or usage, you need to buy licese (Buy the commercial version of MySQL)
LVL 20

Accepted Solution

Mark Brady earned 167 total points
ID: 38862612
PHP comes in a package when you install any one of the packages like wamp (for windows) xamp (also for windows or mac) or lamp (for linux).

simply download one of the windows versions (wamp is easiest to setup) and you will have the following services installed and up and running without almost any configuration

Apache2 server

Once you set it up which only takes a few minutes you will be able to open a browser and type something like 'http://localhost'  and you should see a message saying it worked or something similar. That means php is running.

In any case, as you get into your learning, keep in mind that mysql is depreciated so try and learn mysqli instead which is almost the same to use but it is the future. One day they will stop supporting mysql.

There are millions of php tutorials out there so I would google "php for beginners tutorial" or something like that.

Buying a good book is even better than reading online but whatever you prefer. I could recommend a good book if you are interested.

The best way to learn is to roll up your sleeves and get dirty. You can see your progress as you go and don't forget, we are always here to answer any questions you have.
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

LVL 48

Assisted Solution

PortletPaul earned 84 total points
ID: 38862632
LAMP (Linux, Apache, MySQL, PHP) remains very popular as an architecture for "web apps" of various sorts.

Don't worry too much about the L (Linux): Apache, MySQL, PHP are all available (free) on Windows - but if you intended to make an application that will be used widely it should be workable in a LAMP environment. There are even open source starter kits (e.g. wampserver) to get you going easily.

Could I suggest you visit It provides access to numerous existing PHP applications (mostly "content management systems " hence the cms) - looking at these may give you a head start - and because they are open source you can then download those to see how they are constructed. You may even find that offering an "add-in" to some existing product is a good way to get going.

You might also look for "frameworks" that will allow you to concentrate on high level design and coding - leaving nitty gritty to the framework code.
LVL 36

Assisted Solution

by:Loganathan Natarajan
Loganathan Natarajan earned 83 total points
ID: 38862691
What is needed to get PHP to work with postgreSQL?

You need to configured with postgresql libraries while you do on PHP installation. make sure it supports in it.


The basic usage is here,
LVL 83

Assisted Solution

by:Dave Baldwin
Dave Baldwin earned 83 total points
ID: 38862882
MySQL Community Edition is a freely downloadable version of the world's most popular open source database that is supported by an active community of open source developers and enthusiasts.  You only need a license if you are going to redistribute it or if you want the 'Enterprise' version with support.

MySQL is freely available on almost All web hosting as is PHP.  WAMP and XAMPP are two free downloads that include Apache, PHP, and MySQL and install as a working platform so you don't have to learn to install and make them work together before you get anything done.  Note that you need the web server to run PHP for web pages.  There are some programs that let you run PHP without a full web server but none that I can recommend.

A book that several of us have been recommending is PHP & MySQL Novice to Ninja .
LVL 48

Expert Comment

ID: 38862919
btw: I just did a search for "php framework" here at EE and there are plenty of answers to choose from

e.g. (submitted question 2010-09-29) there may be more recent traffic of this sort.
LVL 20

Assisted Solution

by:Mark Brady
Mark Brady earned 167 total points
ID: 38863677
Personally I avoid frameworks like the plague. IMO so should anyone learning a new language. If you jump into frameworks and start using them (although they can be powerful and easy to use) you will not get to learn the fundamentals of programming.

If you wanted to learn Javascript but you immediately started using jquery, it's the same thing. Learn the language first then look at other packages to enhance your programming.
LVL 12

Assisted Solution

by:Mohamed Abowarda
Mohamed Abowarda earned 83 total points
ID: 38864056
Although some experts answered part of the question, I will try to clarify more:

1. Already answered.

2. Go on and download and install XAMPP or AppServ, once you install any of them, you computer should be running Apache/PHP/MySQL, which all you need to learn PHP.

3.  That's more than enough! you don't even need a high performance computer to run Apache/PHP, of course the higher performance, the better when handling client requests (I assume you will install PHP on Windows 7 for learning purpose only which is more than enough).

4. MySQL is FREE, when you install XAMPP or AppServ, you should have MySQL installed as well.

Forget about SQL Server for now, when you start learning PHP, use MySQL in the beginning.

Author Closing Comment

ID: 38865839
Thank you all for your answers.  I am a paying customer so I  appreciate the prompt replies.

Thank you, PortletPaul for the reference to existing code.  I learn lots from reading existing code used in real applications.

I have tried to allocate points as fairly as I can.

I see I have a lot to learn.
LVL 48

Expert Comment

ID: 38866144
a pleasure to have been of assistance - have fun. Thanks for the shared points.

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Magento: different theme for Pc and for mobile devices 4 37
mysql query for sum() 3 30
Test if unique ID is in log file 5 22
How do I show metrics with PHP or Javascript 6 34
Part of the Global Positioning System A geocode ( is the major subset of a GPS coordinate (, the other parts being the altitude and t…
This article discusses four methods for overlaying images in a container on a web page
The viewer will learn how to dynamically set the form action using jQuery.
The viewer will learn how to count occurrences of each item in an array.

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question