1: Installing PHP and SQL
The first task is to work through the installation steps including installing a text editor, install ...
2: Introduction to Structured Query Language (SQL)
We learn about single table queries and the basic syntax of the SQL language.
3: Database Design
Covering database design with multiple tables, foreign keys, and the JOIN operation..
4: Introduction to Dynamic Web Content
We look at the basic structure of a web application and how a web browser interacts with a web serve ...
5: Introduction to PHP
We begin learning PHP.
6: Overview of PHP Language
We begin the syntax of the PHP language, control structures, and expressions.
7: PHP Arrays
We look at arrays and superglobals like $_GET in PHP language.
8: PHP Functions
We look at functions in PHP language.
9: PHP Forms
We look at how HTML forms are created and processed in the PHP language.
10: PHP Objects
We look at the object oriented pattern in the PHP language.
11: PHP and MySQL
We look at how we connect to a MySQL using the Portable Data Objects (PDO) library and issue SQL com ...
12: PHP Sessions
13: Building a CRUD Application
Now we buid our first 'complete' application that has multiple screens to Create, Read, Update and D ...
This is a brief introduction to the JQuery library which is widely used to do in-browser manipulatio ...
17: JSON - JavaScipt Object Notation
18: Handlebars UI Templates
In this section we look at moving the templates to build HTML fragments from the server (PHP) in to ...
19: Advanced SQL
This section covers some advanced SQL topics.
20: SQL Transactions
This section covers SQL transactions.