The Ultimate Web Development Course 

Introduction

Working Files, eBook and Bookmarks

Section 2: Komodo Text Editor

Introducing Komodo Edit

Download Komodo

Configure Komodo Edit

Section 3: Local Webserver Installation

Introducing XAMPP

Download and Install XAMPP

Change Server Timezone

XAMPP Tools and phpMyAdmin

Section 4: Bare Bones HTML5

Introducing HTML5

Bare bones HTML Movies List Page

Bare Bones HTML Single Movie Page

Bare Bones HTML Admin Page

Quiz 1

Test your HTML

3 questions

Section 5: Styling with CSS

Introduction to Styling with CSS

CSS Reset

Styling with Classes and IDs

Applying Classes to index.html

Box Layout

HTML shiv for IE8

Styling the header and top navigation

Styling the favourites and movie list panel

Styling the footer

Styling the single movie page

Styling the admin pages

Creating background images with a CSS sprite

Cross browser compatibility check

Validate HTML

Quiz 2

Test your CSS

3 questions

Section 6: Essential PHP

Introduction to PHP

Combining PHP and HTML to display strings, variables, and HTML tags

Echoing quote marks String delimiters

PHP Conditions

Switch case

PHP Loops

PHP Includes

Arrays

Passing variables in the URL

Passing variables without their appearing in the URL

Guarding against missing variables

Functions and variable scope

Passing data to functions with parameters

Quiz 3

Test your PHP

4 questions

Section 7: MySQL in phpMyAdmin

What is a Database

Create a database, add tables

Insert data

Import data

Select records

Update existing database records

Select favourites

Delete records, empty and delete tables and database

Section 8: MySQL in PHP

Initialise and connect to a database with mysqli

Select all records from a database

Select matching records using WHERE AND SQL injection demonstrated

Combating SQL injection with mysqli real_escape_string

Combating SQL injection with prepared statements

Add data through PHP interface

Delete data through PHP interface

Section 9: From static HTML to dynamic PHP

Introduction to Section 9 PHP

Efficient, reusable code with PHP includes

One index file for single movie and movies list

One admin file for users and movies admin

Initialise and connect to the favourite movies database

Displaying dynamic data the list of users

Convert users list to function

Set include paths in parent files

User navigation test if valid user set

Set parameters for show users function

Parameterised show users function

Catching missing and invalid user_id

ASSIGNMENT: Write the favourite movies display function

The favourite movies display function

ASSIGNMENT: Write the non favourites display function

The non favourite movies display

Insert personal greeting on movie list page

The single movie display

Catching missing and invalid user input movie_id

Catching empty movie goers table

ASSIGNMENT Catching empty movies table

Catching empty movies table

Data dependent title for favourites list

Data dependent welcome in movie list display

Data dependent link on single movie page

ASSIGNMENT Putting dynamic data into the movie admin table

Dynamic data in movies admin table

Dynamic data in users admin table

Check again for cross browser compatibility

Validate HTML

Format HTML source

Section 10: Essential jQuery and AJAX

Introduction to jQuery

Install Firebug

Basic jQuery syntax

The $(this) selector

Add/remove class and the dynamic event handler on

Retrieving and using HTML attributes

One way drag and drop effect using jQuery UI

AJAX Update database in the background with no page refresh

ASSIGNMENT The drag to delete AJAX call and PHP script

1 page

The drag to delete AJAX call and PHP script

Section 11: jQuery effects and AJAX interaction

Adapt JQuery for project

Toggle background image on mouseover

The click to add interface