You are here: Home > Useful Guides > Learn PHP and MySQL
Wednesday, 27 August 2008
(This is a prerequisite article in preparation for the "quirky affiliate site" series.)
We all have to start somewhere and for me it was coding HTML using Microsoft FrontPage. Those days are long gone now as I tend to use HTML Kit to code PHP files. Back then, I never thought I would switch from WYSIWYG editors to text editors but alas, progression dictated that!
I used one book to learn PHP - PHP and MYSQL for Dummies. I like the Dummies range of books as they are simple to use as a reference encyclopaedia as well as a book. The book has mixed reviews on Amazon so I imagine it's like Marmite - you love it or you hate it. I love it - it suited my needs when I was learning.
The book also covers MySQL, which is handy.
As I progressed, I found (and still find) Tizag extremely handy for looking at structure (mainly MySQL query structure or PHP function structure).
For on-the-go questions about PHP and MySQL, I find all my answers via Google. Sometimes the answers aren't obvious but more often than not, I forget to think logically about a problem! PHP and MySQL is a very logical orientated set of languages - If you are a logical person and can think in a logical manor, you'll get on with this like peas and sweetcorn.
That's all you need to follow the tutorials that follow. A basic understanding of how PHP / MySQL works and an open mind. If you get stuck, search Google and you'll find the answers. Promise.
You may also be interested in reading:
Comments are manually approved and hence can a while to appear. Questions, informative posts, and feedback comments are gladly accepted. Spam is deleted. Spam-type comments have their links removed (Comment Policy)
@Darrell - It depends upon how fast you can learn! There is a cheats way and that is to use ready built scripts.
Magic Parser - http://www.magicparser.com - will enable you to parse RSS feeds as well as CSV / XML datafeeds. You could use this alongside some basic PHP to parse records into a database or onto a webpage.
Price Tapestry - http://www.pricetapestry.com - is a script built using Magic Parser as part of the admin side. It allows you to register datafeeds and create a catalogue of products and prices.
For me, I took around the best part of a few months to get to grips with the technical side of data feed manipulation and Magic Parser / Price Tapestry. The scripts are easy to use and can be learned in a few minutes. Creating your own scripts thereafter is what takes the time.
PHP & MySQL took a few weeks to learn. This was for just the basics and I continue to learn to this day.
Every script you code improves your ability, confidence and imagination of what could be.
Written on Wednesday 27 August 2008 at 14:24:01 GMT (Permalink)
Darrell
How long does it take to learn PHP and MYSQL to a level where u can code simple affiliate sites to handle data feeds etc...?
My html & css skills are ok.
Written on Wednesday 27 August 2008 at 12:40:15 GMT (Permalink)