PHP & MySql

This is the more advanced aspect of web pages development. The following lessons have a focus on Javascript, PHP and MySQL.

Languages covered are HTML, CSS, Javascript, PHP and MySQL.

Tools

Visual Studio Code
Note, that since the pdf's were created the editor Visual Studio Code(VSC) has replaced Expression Web. VSC is a superior editor that is cross platform (works on Windows, Linux and Mac) and has the ability to add additional functionality via plugins. When Expression Web is listed as part of the course, use VSC instead.

https://code.visualstudio.com/
XAMPP
This is the web server required for php & mysql.

https://www.apachefriends.org

Lessons

icon

Lesson 1

This tutorial looks at liquid layout, z-index and visibility controls through javascript. Click PDF to view the content

icon

Lesson 2

Content switching with Javascript. Modifying the DOM. Click PDF to view the content

icon

Lesson 3

Javascript - COntrolling elements on the canvas, introduction to loops. Click PDF to view the content

icon

Lesson 4

Javascript and audio. Click PDF to view the content

icon

Lesson 5

Javascript animating backgrounds and canvas elements. Click PDF to view the content

icon

Lesson 6

Javascript side scrolling game (X-wing vs Tie Fighter). Click PDF to view the content

icon

Lesson 7

A simple Javascript game. Click PDF to view the content

icon

Lesson 8

Introduction to Xampp and PHP, focus on dealing with data transfer between php pages. Click PDF to view the content

icon

Lesson 9

Xampp, MySql and PHP - Student addition to database (Focus on Create and Read). Click PDF to view the content

icon

Lesson 10

Xampp, MySQL and PHP - Student addition to database (Focus on Create, Read, Update and Delete). Click PDF to view the content

icon

Lesson 11

Xampp, MySQL and PHP - Movie database - AJAX. Click PDF to view the content