Course Introduction
Komodo Text Editor
Local Webserver Installation
Bare Bones HTML5
Styling with CSS
-
Introduction to Styling with CSS (5:33)
-
CSS Reset (4:39)
-
Styling with Classes and IDs (4:00)
-
Applying Classes to index.html (6:51)
-
Box Layout (10:56)
-
HTML-shiv for IE8 (5:35)
-
Styling the header and top navigation (12:33)
-
Styling the favourites and movie list panel (13:04)
-
Styling the footer (5:32)
-
Styling the single movie page (8:19)
-
Styling the admin pages (20:34)
-
Creating background images with a CSS sprite (9:17)
-
Cross-browser compatibility check (1:37)
-
Validate HTML (1:31)
Essential PHP
-
Introduction to PHP (2:02)
-
Combining PHP and HTML to display strings, variables, and HTML tags (14:45)
-
Echoing quote marks - String delimiters (4:49)
-
PHP Conditions (6:14)
-
Switch ... case (2:37)
-
PHP Loops (4:32)
-
PHP Includes (7:50)
-
Arrays (21:27)
-
Passing variables in the URL (6:09)
-
Passing variables without their appearing in the URL (4:54)
-
Guarding against missing variables (4:14)
-
Functions and variable scope (4:27)
-
Passing data to functions with parameters (5:20)
MySQL in phpMyAdmin
MySQL in PHP
-
Initialise and connect to a database with mysqli (13:33)
-
Select all records from a database (6:58)
-
Select matching records using WHERE ... AND (4:11)
-
SQL injection demonstrated (2:48)
-
Combating SQL injection with mysqli real_escape_string (2:25)
-
Combating SQL injection with prepared statements (7:13)
-
Add data through PHP interface (3:50)
-
Delete data through PHP interface (4:16)
From static HTML to dynamic PHP
-
Introduction to Section 9 - PHP (1:48)
-
Efficient, reusable code with PHP includes (9:38)
-
One index file for single movie and movies list (9:06)
-
One admin file for users and movies admin (6:36)
-
Initialise and connect to the favourite movies database (2:53)
-
Displaying dynamic data - the list of users (9:21)
-
Convert users list to function (10:19)
-
Set include paths in parent files (2:11)
-
User navigation - test if valid user set (6:09)
-
Set parameters for show users function (3:42)
-
Parameterised show users function (8:18)
-
Catching missing and invalid user_id (4:57)
-
ASSIGNMENT: Write the favourite movies display function
-
The favourite movies display function (7:36)
-
ASSIGNMENT: Write the non-favourites display function
-
The non-favourite movies display (7:26)
-
Insert personal greeting on movie list page (2:39)
-
The single movie display (2:04)
-
Catching missing and invalid user input - movie_id (6:44)
-
Catching empty movie-goers table (5:31)
-
ASSIGNMENT - Catching empty movies table
-
Catching empty movies table (3:14)
-
Data-dependent title for favourites list (4:48)
-
Data-dependent welcome in movie list display (3:47)
-
Data-dependent link on single movie page (3:32)
-
ASSIGNMENT – Putting dynamic data into the movie admin table
-
Dynamic data in movies admin table (2:57)
-
Dynamic data in users admin table (4:02)
-
Check again for cross-browser compatibility (1:24)
-
Validate HTML (2:00)
-
Format HTML source (12:15)
Essential jQuery and AJAX
-
Introduction to jQuery (4:56)
-
Install Firebug (1:06)
-
Basic jQuery syntax (4:44)
-
The $(this) selector (2:13)
-
Add/remove class and the dynamic event handler 'on' (4:21)
-
Retrieving and using HTML attributes (9:55)
-
One-way drag-and-drop effect using jQuery UI (6:50)
-
AJAX - Update database in the background with no page refresh (11:14)
-
ASSIGNMENT - The drag-to-delete AJAX call and PHP script
-
The drag-to-delete AJAX call and PHP script (8:10)
jQuery effects and AJAX interaction
-
Adapt JQuery for project (7:06)
-
Toggle background image on mouseover (2:02)
-
The click-to-add interface (7:05)
-
The drag-to-remove interface (4:16)
-
Load generic thumbnail image in case of missing image
-
ASSIGNMENT - The add/remove interface for the single movie page
-
Add-remove interface for single movie page (7:41)
-
ASSIGNMENT - Data-dependent headings - Modify PHP
-
Data-dependent headings - Modify PHP (2:38)
-
ASSIGNMENT- Data-dependent headings - jQuery
-
Data-dependent headings - jQuery version (7:10)
-
Visual enhancements and AJAX loader icon (12:14)
-
ASSIGNMENT: Visibility of admin and movie-goer menus
-
Control visibility of admin menus (3:26)
-
ASSIGNMENT - Conditional loading of Javascript files
-
Conditional loading of Javascript files (1:32)
-
Movie-goer deletion interface - preliminaries (4:00)
-
ASSIGNMENT - Movie-goer deletion interface
-
Movie-goer deletion interface (2:38)
-
The movie deletion interface (3:40)
-
Add new user interface (1) (7:33)
-
Add new user interface (2) (6:53)
-
Delete newly inserted database records (4:16)
-
Escape HTML output in jQuery (4:42)
-
Add new movie interface (2:17)
-
Update user interface - firstname (15:20)
-
ASSIGNMENT - Full update user interface
-
Full update user interface (6:17)
-
Update movie interface (2:49)
-
Catch browsers with Javascript disabled (7:50)
Online version and security considerations
Course conclusion and ... what comes next
