Course Introduction
  • Introduction
  • Working Files, eBook and Bookmarks
Komodo Text Editor
  • Introducing Komodo Edit
  • Download Komodo Edit
  • Configure Komodo Edit
Local Webserver Installation
  • Introducing XAMPP
  • Download and Install XAMPP
  • Troubleshooting XAMPP installation (1)
  • Troubleshooting XAMPP installation (2)
  • Change Server Timezone (Optional)
  • XAMPP Tools and phpMyAdmin
Bare Bones HTML5
  • Introducing HTML5
  • Bare bones HTML - Movies List Page
  • Bare Bones HTML - Single Movie Page
  • Bare Bones HTML - Admin Page
  • Test your HTML
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
  • Test your CSS
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
  • Test your PHP
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
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
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