[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Want to learn PHP

Posted on 2013-02-06
Medium Priority
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. http://www.php.net/license/

also you can easily install in Win 7.. by installing this suite. http://www.apachefriends.org/en/xampp-windows.html
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 668 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.
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

LVL 49

Assisted Solution

PortletPaul earned 336 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 opensourcecms.com? 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 332 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.

ref. http://www.php.net/manual/en/pgsql.setup.php

The basic usage is here,

LVL 84

Assisted Solution

by:Dave Baldwin
Dave Baldwin earned 332 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.
http://dev.mysql.com/downloads/mysql/5.6.html  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 http://www.wampserver.com/en/ and XAMPP http://www.apachefriends.org/en/xampp.html 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 http://www.sitepoint.com/books/phpmysql5/ .
LVL 49

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. http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/PHP/PHP_Frameworks/Q_26508024.html#a33796380 (submitted question 2010-09-29) there may be more recent traffic of this sort.
LVL 20

Assisted Solution

by:Mark Brady
Mark Brady earned 668 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 332 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.
AppServ: http://www.appservnetwork.com/index.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 49

Expert Comment

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

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone 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

Developers of all skill levels should learn to use current best practices when developing websites. However many developers, new and old, fall into the trap of using deprecated features because this is what so many tutorials and books tell them to u…
It’s a season to be thankful, and we’re thankful for users like you who engage on site, solve technology problems, and network with others in the industry. What tech are we most thankful for? Keep reading.
The viewer will learn how to count occurrences of each item in an array.
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.
Suggested Courses
Course of the Month19 days, 3 hours left to enroll

834 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