Richard Stibbard – The Ultimate Web Development Course

Richard Stibbard – The Ultimate Web Development Course

Salepage : Richard Stibbard – The Ultimate Web Development Course

Arichive : Richard Stibbard – The Ultimate Web Development Course

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.com’s hotel search.

Along the way 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.

Like me on Facebook, follow me on Twitter, find me on Google+. See my professional profile on LinkedIn and find my special deals on other Udemy courses.

Course Curriculum

Course Introduction

 PreviewIntroduction to the course (7:22)

 StartWorking Files, Accompanying eBook, and Course Bookmarks

Komodo Text Editor

 PreviewIntroducing Komodo Edit (2:05)

 PreviewDownload Komodo Edit (2:18)

 PreviewConfigure Komodo Edit (3:54)

Local Webserver Installation

 PreviewIntroducing XAMPP (2:41)

 PreviewDownload and Install XAMPP (5:51)

 PreviewChange Server Timezone (2:19)

 PreviewXAMPP Tools and phpMyAdmin (1:12)

Bare Bones HTML5

 PreviewIntroducing HTML5 (4:44)

 PreviewBare bones HTML – Movies List Page (12:20)

 PreviewBare Bones HTML – Single Movie Page (2:18)

 PreviewBare Bones HTML – Admin Page (5:26)

Styling with CSS

 PreviewIntroduction to Styling with CSS (5:33)

 PreviewCSS Reset (4:39)

 PreviewStyling with Classes and IDs (4:00)

 PreviewApplying Classes to index.html (6:51)

 PreviewBox Layout (10:56)

 PreviewHTML-shiv for IE8 (5:35)

 PreviewStyling the header and top navigation (12:33)

 PreviewStyling the favourites and movie list panel (13:04)

 PreviewStyling the footer (5:32)

 PreviewStyling the single movie page (8:19)

 PreviewStyling the admin pages (20:34)

 PreviewCreating background images with a CSS sprite (9:17)

 PreviewCross-browser compatibility check (1:37)

 PreviewValidate HTML (1:31)

Essential PHP

 PreviewIntroduction to PHP (2:02)

 PreviewCombining PHP and HTML to display strings, variables, and HTML tags (14:45)

 PreviewEchoing quote marks – String delimiters (4:49)

 PreviewPHP Conditions (6:14)

 PreviewSwitch … case (2:37)

 PreviewPHP Loops (4:32)

 PreviewPHP Includes (7:36)

 PreviewArrays (21:27)

 PreviewPassing variables in the URL (6:09)

 PreviewPassing variables without their appearing in the URL (4:54)

 PreviewGuarding against missing variables (4:14)

 PreviewFunctions and variable scope (4:27)

 PreviewPassing data to functions with parameters (5:20)

MySQL in phpMyAdmin

 PreviewWhat is a Database (6:44)

 PreviewCreate a database, add tables (6:15)

 PreviewInsert data (9:11)

 PreviewImport data (4:38)

 PreviewSelect records (4:30)

 PreviewUpdate existing database records (2:25)

 PreviewSelect favourites (4:09)

 PreviewDelete records, empty and delete tables and database (3:35)

MySQL in PHP

 PreviewInitialise and connect to a database with mysqli (13:33)

 PreviewSelect all records from a database (6:58)

 PreviewSelect matching records using WHERE … AND (4:11)

 PreviewSQL injection demonstrated (2:48)

 PreviewCombating SQL injection with mysqli real_escape_string (2:25)

 PreviewCombating SQL injection with prepared statements (7:13)

 PreviewAdd data through PHP interface (3:50)

 PreviewDelete data through PHP interface (4:16)

From static HTML to dynamic PHP

 PreviewIntroduction to Section 9 – PHP (1:48)

 StartEfficient, reusable code with PHP includes (9:38)

 StartOne index file for single movie and movies list (9:06)

 StartOne admin file for both users and movies admin pages (6:36)

 StartInitialise and connect to the favourite movies database (2:53)

 StartDisplaying dynamic data – the list of users (9:21)

 StartConvert users