You are here: Home > Useful Guides > Learn PHP and MySQL

Learn PHP and MySQL

(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.

Keep up-to-date quickly and easily. Subscribe to my RSS feed or better yet, subscribe to my aggregated affiliate marketing RSS feed - 30 respected UK affiliate bloggers all compressed into one simple RSS feed!

You may also be interested in reading:

2 Comments

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

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)

David

@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)









Enter the URL without the http:// part else your comment won't be saved.





RSS Feed

Search DavidFiske.com