PHP MySQL Lectures Notes

These lecture slides were used to teach PHP/MySQL on the following courses:

  • Multimedia Production Diploma, SAE 2005-2007
  • Web Design & Development Diploma, Qantm 2007-2009
  • Citigroup custom Corporate Training, 2007
  • Private Custom Training, 2006-2009

Although getting slightly dated now, this collection of lecture notes are somthing i know past students and myself included do come back to for reference, so here they remain, for your viewing pleasure.

01. Introduction To PHP

The fist lecture of the class, discussions on what makes a dynamic site different to a static site, and then going on to discuss PHP & MySQL definitions with a look and explanation of the 3 tier application system.

01. Introduction To PHP – Download the PDF

01. Introduction To PHP – Download the IPOD VIDEO

02. Syntax, Variables & Strings

A look at basic PHP syntax, then moving onto talk about variables and strings.

02. Syntax, Variables & Strings – Download the PDF

02. Syntax, Variables & Strings – Download the IPOD VIDEO

03. Operators & Conditionals

A look at Arithmetic, Assignment and Comparison Operators, moving logically on to IF, IF ELSE and finally SWITCH statements

03. Operators & Conditionals – Download the PDF

03. Operators & Conditionals – Download the IPOD VIDEO

04. Arrays & Loops

Here we go, time for me to get out the boxes and start explaining Arrays, multi-dimensional Arrays, then once we have that hard-wired, it is time to get a little loopy with all of those lovely little PHP loops, WHILE, DO…WHILE, FOR and FOREACH.

04. Arrays & Loops – Download the PDF

04. Arrays & Loops – Download the IPOD VIDEO

05. Functions

Now it is time to look at functions, from creating your own simple functions, to passing parameters and returning values.

05. Functions – Download the PDF

05. Functions – Download the IPOD VIDEO

06. Forms & User Input

A Short set of slides here, but one of the most important, the fundamentals of passing data using Forms.

06. Forms & User Input – Download the PDF

06. Forms & User Input – Download the IPOD VIDEO

07. _GET & _POST

Now we are passing data with Forms it might be a good idea to take an in-depth look at both $_GET & $_POST, with even a little mention of $_REQUEST too.

07. _GET & _POST – Download the PDF

07. _GET & _POST – Download the IPOD VIDEO

08. Mail

A look at the basic Mail function in PHP, sending email via Forms. Also an introductory look at email injection and PHP Filters

08. Mail – Download the PDF

08. Mail – Download the IPOD VIDEO

08+. Mail Scripts

Also included are two mail scripts for download, the first being the most simple of PHP mail functionality, and the second being a NON-WORKING collection of all of the possible spam replacement, SQL injection protection and valid email checking, easily customizable for you usage.

08. Mail – Download the MAIL SCRIPTS

09. Introduction To SQL

A look at the basic features of SQL. This does not cover the more advanced functionality of SQL, but provides more than enough to get you through your first few projects and further.

09. Intro To SQL – Download the PDF

09. Intro To SQL – Download the IPOD VIDEO

10. _COOKIES & _SESSIONS

Cookies and sessions explained with an accompanying login system example showing basic, retrieving and deletion of both, and displaying ‘selective’ user content.

10. Cookies&Sessions – Download the PDF

10. Cookies&Sessions – Download the IPOD VIDEO

10. Cookies&Sessions – Download the LOGIN SYSTEM FILES

11. Date / Timestamps

Cookies and sessions explained with an accompanying login system example showing basic, retrieving and deletion of both, and displaying ‘selective’ user content.

11. Date – Download the PDF

11. Date – Download the IPOD VIDEO

11+. Deathclock / Fag Stats

Just a nice morbidly fun way to illustrate date and timestamp functionality, and maybe persuade a few people to smoke a bit less.

11+. Date – Download the FILES

*these notes are not intended as stand alone source material, rather they are supplemental lecture material.

Leave a comment...

16 comments

  1. tom says:

    just to let u know – i think i love PHP :)

  2. mog says:

    All that late night love for PHP, ..and none for me :( …i guess i should take pleasure in opening up your love.
    Don’t cheat on her though, .she is a fickle mistress.

  3. Anrem J. Balonton says:

    simple and good lecture notes,,can you add some more notes with the mysql to enahnce futher the learning…thank you…

  4. mog says:

    Thanks for your feedback, ..these notes are not used by me anymore as they are slightly dated although still providing a good grounding.
    They were however largely based on the W3C Schools notes which you can find current up to date versions of here: http://www.w3schools.com/

    enjoi.

  5. imdad (bcs-5) says:

    goooood and thanks

  6. imdad says:

    thanks its gooooooooooood……

  7. it-instructor says:

    it makes complex ideas into basic!…like a story telling….

  8. RASHAD MAQSOOD says:

    this site helps me a lot. i shall remember it for further help. inshallah

  9. mog says:

    No problem Rashad, glad to have helped, ..although you ma find these notes a little dated now, …for current up to date versions i suggest you visit the W3Schools site: http://www.w3schools.com/php/php_intro.asp

  10. eddy says:

    thnks 4 tha notes.lol

  11. shuvalaxmi says:

    thanks for this its good…..

  12. fuhad says:

    Every students useful

  13. KASIBANTE ROBERT says:

    i want to thank you for providing me with these notes aim trying to teach my self how to desing a web and i hope these notes will provide me with what i want.tanks

  14. felix maru says:

    Hii notes iko juu add more pliz i like it……

    thanks alot

  15. I have downloaded php tutorial pdf files. I try this programming and give feedback next time. Thank you…

  16. DAWIT says:

    pls send to me note for the above list! 10q in-advance!

This site is not up to date. I really should take it down and make a new one as I have been busy with a lot of cool projects and clients recently, but currently do not have the time to rebuild it.

So, it stays here, but please note it has not been updated in a while and if you need to get in contact with me please just email me directly at mog@mogmachine.com or phone me on +44 (0)7960 214407.

Thanks,

Marcus (mog)