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