Autoplay
Autocomplete
Speed
Previous Lecture
Complete and Continue
The Ultimate Web Development Course
Chapter 01 - Course Introduction
01-01 Course Description (7:24)
01-02 Download Working Files, course bookmarks and ebook
Chapter 02 - Komodo Edit Text Editor
02-01 Introducing Komodo Edit (2:29)
02-02 Download Komodo Edit (2:39)
02-03 Configure Komodo Edit (6:40)
Chapter 03 - Local webserver installation
03-01 Introducing XAMPP (2:41)
03-02 Download and Install XAMPP (3:53)
03-03 Troubleshooting XAMPP installation (1) (2:54)
03-04 Troubleshooting XAMPP installation (2) (7:52)
03-05 Change timezone (2:20)
03-06 XAMPP tools & PHPMyAdmin (1:46)
Chapter 04 - Bare bones HTML5
04-01 Introduction to HTML5 (4:46)
04-02 Bare bones HTML - movies list (12:22)
04-03 Bare bones HTML - single movie (2:19)
04-04 Bare bones HTML - admin page (5:28)
Chapter 05 - Styling with CSS
05-01 Introduction to Styling (5:35)
05-02 CSS reset (4:41)
05-03 Styling with classes and IDs (4:02)
05-04 Applying Classes to index.html (6:58)
05-05 Box layout (10:58)
05-06 HTML-shiv for IE8 (5:37)
05-07 Styling the header and top navigation (12:35)
05-08 Styling the favourites and movie list panel (13:06)
05-09 Styling the footer (5:34)
05-10 Styling the single movie page (8:21)
05-11 Styling the admin pages (20:36)
05-12 Creating background images with a CSS sprite (9:19)
05-13 Cross-browser compatibility check (1:37)
05-14 Validate HTML (1:36)
Chapter 06 - Essential PHP
06-01 Introduction to PHP (2:03)
06-02 Combining PHP and HTML to display strings, variables, and HTML tags (14:47)
06-03 String delimiters (4:51)
06-04 Conditions (6:16)
06-05 Switch-case (2:38)
06-06 Loops (4:34)
06-07 PHP includes (7:36)
06-08 Arrays (21:29)
06-09 Passing variables in the URL (6:11)
06-10 Passing variables without their appearing in the URL (4:56)
06-11 Guarding against missing variables (4:16)
06-12 Functions and variable scope (4:29)
06-13 Passing data to functions with parameters (5:22)
Chapter 07 - MySQL in phpMyAdmin
07-01 What is a database (6:46)
07-02 Create database, add tables (6:17)
07-03 Insert data (9:13)
07-04 Import data (4:40)
07-05 Select Records (4:32)
07-06 Update existing database records (2:25)
07-07 Select favourites (4:11)
07-08 Delete records, empty and delete tables and database (3:36)
Chapter 08 - MySQL in PHP
08-01 Initialise and connect to a database (13:35)
08-02 Select all records from database (7:00)
08-03 Select records using WHERE ... AND (4:13)
08-04 SQL injection (2:49)
08-05 Combating SQL injection with mysqli real_esape_string (2:25)
08-06 Combatting SQL injection with prepared statements (7:13)
08-07 Add data through PHP interface (3:51)
08-08 Delete data through PHP interface (4:18)
Chapter 09 - From static HTML to dynamic PHP
09-00 Introduction to PHP (1:48)
09-01 Efficient, reusable code with PHP includes (9:40)
09-02 One index file for single movie and movies list (9:08)
09-03 One admin file for users and movies admin (6:38)
09-04 Initialise and connect to the favourite movies database (2:54)
09-05 Displaying dynamic data - the list of movie-goers (9:23)
09-06 Convert users list to function (10:21)
09-07 Set include paths (2:12)
09-08 User navigation - test if valid user set (6:09)
09-09 Set parameters for show users function (3:43)
09-10 Parameterised show users function (8:20)
09-11 Catching missing and invalid user_id (4:57)
09-12 ASSIGNMENT - Write the favourite movie display function
09-13 Favourite movies display function (7:38)
09-14 ASSIGNMENT - The non-favourites movies display function
09-15 The non-favourite movies display (7:28)
09-16 Insert personal greeting on movie list page (2:40)
09-17 The single movie display (2:04)
09-18 Catching missing and invalid user input - movie_id (6:46)
09-19 Catching empty movie-goers table (5:33)
09-20 ASSIGNMENT - Catching empty movies table
09-21 Catching empty movies table (3:15)
09-22 Data-dependent title for favourites list (4:50)
09-23 Data-dependent welcome in movie list display (3:48)
09-24 Data-dependent link on single movie page (3:33)
09-25 ASSIGNMENT – Putting dynamic data into the movie admin table
09-26 Dynamic data in movies admin table (2:58)
09-27 Dynamic data in users admin table (4:04)
09-28 Cross browser compatibility (1:24)
09-29 Validate HTML (2:01)
09-30 Format HTML source (12:17)
Chapter 10 - Essential jQuery and AJAX
10-01 Introduction to jQuery (4:56)
10-02 Install Firebug (1:06)
10-03 jQuery syntax (4:44)
10-04 The 'this' selector (2:13)
10-05 Add-remove class and the dynamic event handler 'on' (4:21)
10-06 Retrieving and using HTML attributes (9:57)
10-07 One-way drag-and-drop effect using jQuery UI (6:52)
10-08 AJAX - Update database with no page refresh (11:16)
10-09 ASSIGNMENT - The drag-to-delete AJAX call and PHP script
10-10 The drag-to-delete AJAX call and PHP script (8:12)
Chapter 11 - jQuery effects and AJAX interaction
11-01 Adapt JQuery for project (7:06)
11-02 Toggle background image on mouseover (2:02)
11-03 The click-to-add interface (7:07)
11-04 The drag-to-remove interface (4:16)
11-05 Load generic image in case of missing image (2:02)
11-06 Add-remove interface for the single movie page
11-07 Add-remove interface for single movie page (7:41)
11-08 ASSIGNMENT - Data-dependent headings - Modify PHP
11-09 Data-dependent headings - Modify PHP (2:38)
11-10 ASSIGNMENT- Data-dependent headings - jQuery
11-11 Data-dependent headings- jQuery version (7:10)
11-12 Visual enhancements and AJAX loader icon (12:16)
11-13 ASSIGNMENT - Visibility of admin and movie-goer menus
11-14 Control visibility of admin menus (3:26)
11-15 ASSIGNMENT - Conditional loading of Javascript files
11-16 Conditional loading of Javascript files (1:32)
11-17 Movie-goer deletion interface - preliminaries (4:00)
11-18 ASSIGNMENT - Movie-goer deletion interface
11-19 Movie-goer deletion interface (2:38)
11-20 The movie deletion interface (3:40)
11-21 Add new user interface (1) (7:35)
11-22 Insert new user interface (2) (6:55)
11-23 Delete newly inserted database records (4:16)
11-24 Escape HTML output in jQuery (4:42)
11-25 Add new movie interface (2:17)
11-26 Update existing user - firstname (15:22)
11-27 ASSIGNMENT - Full update user interface
11-28 Full update user interface (6:19)
11-29 Update movie interface (2:50)
11-30 Catch browsers with Javascript disabled (7:52)
Chapter 12 - Online version and security considerations
12-01 Security considerations - directory browsing (1:54)
12-02 Prevent directory browsing with htaccess (2:52)
12-03 PHP redirect out of directories (1:53)
12-04 Accessing AJAX files through AJAX call only (1:55)
12-05 Uploading the project to a webhost (8:00)
12-06 Moving database connection file out of web directory (5:13)
Chapter 13 - Course conclusion and what comes next
13-01 Course conclusion and what comes next (3:48)
11-13 ASSIGNMENT - Visibility of admin and movie-goer menus
Lecture content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock