Build An Instantly Updating Dynamic Website With JQueryAJAX

Course Description

"This has been one of the best web courses ever. It should be used as a model by almost anyone thinking of teaching on the web. It has cleared out nearly a decade of web programming cobwebs. The fact you have made a course which is complete end-to-end is impressive. The fact that code examples all work puts nearly every programming book and most web courses to shame."
Paul Wolfson, Principal Investigator, Dallas Legal Technology


---------------------------------------------------------------------------------------------------------

"The Ultimate Web Development course is the most user friendly course I have encountered to date. Additionally, the lecturer, Dr. Richard Stibbard is extremely committed and accessible. Oh! If only all the on-line lecturers could take a page from his book."
Urich Wilmot-Hoyte

-----------------------------------------------------------------------------------------------------------

"Solid Full Stack Development course - I have been through numerous other books and courses trying to get up to speed on CSS, JQuery, Ajax, and PHP, and so far this is the most effective. I think there are two keys to it's success. First, the app developed throughout the course is reasonably complex and whether its a particular look in CSS or behaviour in jQuery, it accurately reflects what modern apps really look like. Next, there is enough hands on coding in all the tools that it really begins to stick. HIghly recommended for anyone wanting broad introduction to modern web development that really touches almost all the bases."
Donald Brummel

-----------------------------------------------------------------------------------------------------------

Taught by freelance developer and experienced online educator Dr. Richard Stibbard, this course takes you in easy steps through the entire process of building an up-to-date web interface which updates its database and HTML on the fly without the need for page refreshes, rather like the 'Add to Favourites' function on Youtube or Trivago's hotel search.

You will learn how to:

structure a website using HTML5
apply styling with cascading stylesheets (CSS)
convert a static site to a dynamic one using PHP
remove inefficient duplicate code
use PHP functions to isolate variables
use MySQLi and prepared statements for secure database queries
manipulate page content immediately with jQuery
update the database silently with AJAX
upload the project to a web host and deal with important security considerations.
PDF version of the course allows full-text search

The course is equally suitable for beginners or more advanced students. For beginners there are step-by-step instructions which take you through every step of the project until all the principles have been covered, and then hand over to assignments which allow you to put into practice what you have learned before you see the solutions.

For learners already familiar with some aspects of web design and development who want to move onto specific points more quickly, incremental working files and clear guidance are provided at every stage, allowing you to skip lessons you do not need and rejoin the course at any point without losing track of the necessary code.

With studio quality audio, widescreen HD video, and incremental versions of the source code, this efficiently organized course teaches up-to-date coding techniques and gives comprehensive coverage of an important aspect of modern web development.
What are the requirements?

A computer connected to the internet
The ability/permission to download software
A text editor (I recommend Komodo Edit, which is free)
Enthusiasm!

What am I going to get from this course?

Over 134 lectures and 11.5 hours of content!
Flexible course design allows for complete beginners or more advanced learners
Learn HTML5, CSS, MySQL, PHP, jQuery and AJAX in one working project
Up-to-date coding standards using mysqli and prepared statements to ensure database security
Instant update website - the most modern web interface
Detailed coverage of programming logic and dynamic website coding processes
Accompanying FREE PDF or Kindle book allows full-text search of the course

What is the target audience?

Anyone interested in web design and development
No prior knowledge needed

Curriculum
Section 1: Course Introduction
Lecture 1
Introduction
07:22


Build an instant update database interface with jQuery/AJAX
Lecture 2
Working Files, eBook and Bookmarks
Text
Section 2: Komodo Text Editor
Lecture 3
Introducing Komodo Edit
02:06
Lecture 4
Download Komodo Edit
01:37
Lecture 5
Configure Komodo Edit
03:54
Section 3: Local Webserver Installation
Lecture 6
Introducing XAMPP
02:41
Lecture 7
Download and Install XAMPP
05:51
Lecture 8
Change Server Timezone
02:19
Lecture 9
XAMPP Tools and phpMyAdmin
01:12
Section 4: Bare Bones HTML5
Lecture 10
Introducing HTML5
04:44
Lecture 11
Bare bones HTML - Movies List Page
12:20
Lecture 12
Bare Bones HTML - Single Movie Page
02:18
Lecture 13
Bare Bones HTML - Admin Page
05:26
Quiz 1
Test your HTML
3 questions
Section 5: Styling with CSS
Lecture 14
Introduction to Styling with CSS
05:33
Lecture 15
CSS Reset
04:39
Lecture 16
Styling with Classes and IDs
04:00
Lecture 17
Applying Classes to index.html
06:51
Lecture 18
Box Layout
10:56
Lecture 19
HTML-shiv for IE8
05:35
Lecture 20
Styling the header and top navigation
12:33
Lecture 21
Styling the favourites and movie list panel
13:04
Lecture 22
Styling the footer
05:32
Lecture 23
Styling the single movie page
08:19
Lecture 24
Styling the admin pages
20:34
Lecture 25
Creating background images with a CSS sprite
09:17
Lecture 26
Cross-browser compatibility check
01:37
Lecture 27
Validate HTML
01:31
Quiz 2
Test your CSS
3 questions
Section 6: Essential PHP
Lecture 28
Introduction to PHP
02:02
Lecture 29
Combining PHP and HTML to display strings, variables, and HTML tags
14:45
Lecture 30
Echoing quote marks - String delimiters
04:49
Lecture 31
PHP Conditions
06:14
Lecture 32
Switch ... case
02:37
Lecture 33
PHP Loops
04:32
Lecture 34
PHP Includes
07:50
Lecture 35
Arrays
21:27
Lecture 36
Passing variables in the URL
06:09
Lecture 37
Passing variables without their appearing in the URL
04:54
Lecture 38
Guarding against missing variables
04:14
Lecture 39
Functions and variable scope
04:27
Lecture 40
Passing data to functions with parameters
05:20
Quiz 3
Test your PHP
4 questions
Section 7: MySQL in phpMyAdmin
Lecture 41
What is a Database
06:44
Lecture 42
Create a database, add tables
06:15
Lecture 43
Insert data
09:11
Lecture 44
Import data
04:38
Lecture 45
Select records
04:30
Lecture 46
Update existing database records
02:25
Lecture 47
Select favourites
04:09
Lecture 48
Delete records, empty and delete tables and database
03:35
Section 8: MySQL in PHP
Lecture 49
Initialise and connect to a database with mysqli
13:33
Lecture 50
Select all records from a database
06:58
Lecture 51
Select matching records using WHERE ... AND
04:11
Lecture 52
SQL injection demonstrated
02:48
Lecture 53
Combating SQL injection with mysqli real_escape_string
02:25
Lecture 54
Combating SQL injection with prepared statements
07:13
Lecture 55
Add data through PHP interface
03:50
Lecture 56
Delete data through PHP interface
04:16
Section 9: From static HTML to dynamic PHP
Lecture 57
Introduction to Section 9 - PHP
01:48
Lecture 58
Efficient, reusable code with PHP includes
09:38
Lecture 59
One index file for single movie and movies list
09:06
Lecture 60
One admin file for users and movies admin
06:36
Lecture 61
Initialise and connect to the favourite movies database
02:53
Lecture 62
Displaying dynamic data - the list of users
09:21
Lecture 63
Convert users list to function
10:19
Lecture 64
Set include paths in parent files
02:11
Lecture 65
User navigation - test if valid user set
06:09
Lecture 66
Set parameters for show users function
03:42
Lecture 67
Parameterised show users function
08:18
Lecture 68
Catching missing and invalid user_id
04:57
Lecture 69
ASSIGNMENT: Write the favourite movies display function
1 page
Lecture 70
The favourite movies display function
07:36
Lecture 71
ASSIGNMENT: Write the non-favourites display function
1 page
Lecture 72
The non-favourite movies display
07:26
Lecture 73
Insert personal greeting on movie list page
02:39
Lecture 74
The single movie display
02:04
Lecture 75
Catching missing and invalid user input - movie_id
06:44
Lecture 76
Catching empty movie-goers table
05:31
Lecture 77
ASSIGNMENT - Catching empty movies table
1 page
Lecture 78
Catching empty movies table
03:14
Lecture 79
Data-dependent title for favourites list
04:48
Lecture 80
Data-dependent welcome in movie list display
03:47
Lecture 81
Data-dependent link on single movie page
03:32
Lecture 82
ASSIGNMENT – Putting dynamic data into the movie admin table
1 page
Lecture 83
Dynamic data in movies admin table
02:57
Lecture 84
Dynamic data in users admin table
04:02
Lecture 85
Check again for cross-browser compatibility
01:24
Lecture 86
Validate HTML
02:00
Lecture 87
Format HTML source
12:15
Section 10: Essential jQuery and AJAX
Lecture 88
Introduction to jQuery
04:56
Lecture 89
Install Firebug
01:06
Lecture 90
Basic jQuery syntax
04:44
Lecture 91
The $(this) selector
02:13
Lecture 92
Add/remove class and the dynamic event handler 'on'
04:21
Lecture 93
Retrieving and using HTML attributes
09:55
Lecture 94
One-way drag-and-drop effect using jQuery UI
06:50
Lecture 95
AJAX - Update database in the background with no page refresh
11:14
Lecture 96
ASSIGNMENT - The drag-to-delete AJAX call and PHP script
1 page
Lecture 97
The drag-to-delete AJAX call and PHP script
08:10
Section 11: jQuery effects and AJAX interaction
Lecture 98
Adapt JQuery for project
07:06
Lecture 99
Toggle background image on mouseover
02:02
Lecture 100
The click-to-add interface
07:05

Instructor Biography
Richard Stibbard , Web Developer and Online Educator

I have been working in web development since 2006, building custom database-driven websites from scratch, as well as customizing Moodle sites. Before that, I was a lecturer at the University of Surrey, where I specialized in distance education through the online learning platform WebCT Vista (later Blackboard).

I thus bring to Udemy a wealth of expertise not just in the technical aspects of the course, but also the educational side of online learning. My aim is to deliver courses of supreme clarity which are suitable for a range of learners, and which make learning a pleasure for all my students.