PHP MySQL Lectures Notes

Oct 05, 2015

By mogmachine

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


Ref: http://www.mogmachine.com/php-mysql-lecture-notes/

Top