Section 1 : Intro to Beginners PHP

Lecture 1 About Certification
Lecture 2 Intro - What This Course Covers 00:01:42 Duration
Lecture 3 What We Need 00:06:20 Duration

Section 2 : Getting Started

Lecture 1 Introducing XAMPP
Lecture 2 Downloading XAMPP 00:00:59 Duration
Lecture 3 XAMPP - Installing 00:01:56 Duration
Lecture 4 XAMPP - Setting Up 00:02:20 Duration
Lecture 5 Setting Up A PHP Editor - bluefish 00:02:35 Duration
Lecture 6 Introduction To bluefish 00:02:49 Duration
Lecture 7 The bluefish Interface 00:03:13 Duration
Lecture 8 bluefish Summary 00:01:35 Duration
Lecture 9 Downloading PHP Snippets 00:02:32 Duration
Lecture 10 PHP Comments 00:04:20 Duration
Lecture 11 Our First PHP Page 00:05:02 Duration
Lecture 12 Using PHP Snippets 00:05:22 Duration
Lecture 13 Intro To MySQL Databases 00:03:15 Duration
Lecture 14 Into To phpMyAdmin 00:05:21 Duration
Lecture 15 External Helpful Resources 00:00:43 Duration
Lecture 16 Exercises 00:01:07 Duration

Section 3 : Our First Look At MySQL And PHP

Lecture 1 Connecting To A MySQL Database - Part 1 00:06:01 Duration
Lecture 2 Connecting To A MySQL Database - Part 2 00:03:00 Duration
Lecture 3 Our First MySQL Query - Part 1 00:06:22 Duration
Lecture 4 Our First MySQL Query - Part 2 00:05:09 Duration
Lecture 5 Creating A MySQL Database 00:04:09 Duration
Lecture 6 Create MySQL Tables - Part 1 00:03:37 Duration
Lecture 7 Create MySQL Tables - Part 2 00:05:17 Duration
Lecture 8 Database Structure 00:05:41 Duration
Lecture 9 Inserting Data in MySQL 00:05:46 Duration
Lecture 10 Updating MySQL Tables 00:02:39 Duration
Lecture 11 Updating MySQL Tables Example 00:03:05 Duration
Lecture 12 MySQL Delete Command 00:06:44 Duration
Lecture 13 Intro To Variables And Operators 00:04:05 Duration
Lecture 14 Arithmetic Operators 00:03:39 Duration
Lecture 15 Assignment Operators 00:05:24 Duration
Lecture 16 Comparison Operators 00:04:15 Duration
Lecture 17 Introduction To Arrays 00:03:18 Duration
Lecture 18 Numeric Arrays 00:02:25 Duration
Lecture 19 Associative Arrays 00:04:08 Duration
Lecture 20 Multi-Dimensional Arrays 00:06:29 Duration
Lecture 21 Creating And Working With Arrays 00:04:21 Duration
Lecture 22 Creating Arrays From A Text File 00:07:18 Duration
Lecture 23 Lesson Review 00:01:23 Duration

Section 4 : Outputting And Processing Data

Lecture 1 Hiding Sensitive Data
Lecture 2 Including Sensitive Data 00:04:04 Duration
Lecture 3 PHP Echo And Quotes - Part 1 00:05:14 Duration
Lecture 4 PHP Echo And Quotes - Part 2 00:04:54 Duration
Lecture 5 Formatting Using sprint 00:05:49 Duration
Lecture 6 Outputting Tabular Data 00:04:59 Duration
Lecture 7 Outputting Data And Time 00:05:32 Duration
Lecture 8 Introduction To Loops 00:02:22 Duration
Lecture 9 do...while Loops 00:01:52 Duration
Lecture 10 Repetition - for Loops 00:01:56 Duration
Lecture 11 Repetition - foreach Loops 00:04:08 Duration
Lecture 12 MySQL Select 00:04:31 Duration
Lecture 13 Formatting Outputted MySQL Data 00:02:04 Duration
Lecture 14 MySQL Joins - Overview 00:03:58 Duration
Lecture 15 MySQL Joins 00:03:32 Duration
Lecture 16 MySQL Where And Order By 00:06:56 Duration

Section 5 : Dealing With Variables

Lecture 1 Intro To Sending Variables 00:01:48 Duration
Lecture 2 Using Variables With GET 00:07:57 Duration
Lecture 3 Using Variables With POST 00:03:27 Duration
Lecture 4 Inserting Sent Data In A Database 00:07:13 Duration
Lecture 5 Updating A Database With Sent Data - Part 1 00:03:15 Duration
Lecture 6 Updating A Database With Sent Data - Part 2 00:05:11 Duration
Lecture 7 Redirection In PHP 00:04:03 Duration
Lecture 8 Creating A List - Example 00:06:33 Duration
Lecture 9 Styling The List - Example 00:04:49 Duration
Lecture 10 What We Have Learned 00:01:09 Duration

Section 6 : Inserting And Using Database Data

Lecture 1 Using One Page To Process Forms - Part 1
Lecture 2 Using One Page To Process Forms - Part 2 00:04:08 Duration
Lecture 3 Multi Part Forms 00:03:58 Duration
Lecture 4 Save And Return POST and GET 00:03:00 Duration
Lecture 5 Save And Return INSERT 00:03:00 Duration
Lecture 6 Save And Return UPDATE 00:03:03 Duration
Lecture 7 Normalization 00:04:02 Duration
Lecture 8 Simple Drop Downs 00:04:19 Duration
Lecture 9 Complex Drop Downs358 00:03:59 Duration
Lecture 10 Revised Form - The Code 00:04:55 Duration
Lecture 11 Revised Form - The Result 00:02:50 Duration
Lecture 12 Lesson Review 00:00:56 Duration

Section 7 : MySQL Joins

Lecture 1 MySQL Join Types - Examples 00:05:57 Duration
Lecture 2 MySQL Join Diagrams 00:01:44 Duration
Lecture 3 Creating Nested Lists 00:04:35 Duration
Lecture 4 MySQL Nested Processing 00:03:33 Duration
Lecture 5 Styling Our Lists 00:05:12 Duration
Lecture 6 Intro To Functions 00:07:34 Duration
Lecture 7 Included Files 00:08:28 Duration

Section 8 : PHP Errors And Security

Lecture 1 Introduction To Security And Errors
Lecture 2 Error Types - Databases 00:08:26 Duration
Lecture 3 PHP Error Types 00:06:41 Duration
Lecture 4 Custom Error Testing 00:08:12 Duration
Lecture 5 Create A Login Page 00:08:12 Duration
Lecture 6 Passwords For Login 00:03:02 Duration
Lecture 7 Protecting Pages 00:08:36 Duration
Lecture 8 Using Cookies - Theory 00:01:34 Duration
Lecture 9 Using Cookies - Practice 00:04:42 Duration
Lecture 10 Access Levels - Basic Restriction 00:05:30 Duration
Lecture 11 Access Levels - Restrict Fields251 00:04:54 Duration
Lecture 12 Managing Users - Structure 00:04:54 Duration
Lecture 13 Managing Users - Create New 00:04:54 Duration
Lecture 14 Audit Trails - Access Function 00:04:23 Duration
Lecture 15 Audit Trails - Logging Logins 00:03:07 Duration
Lecture 16 Errors And Security - Review 00:01:08 Duration

Section 9 : Building A Template Page

Lecture 1 PHP Templates 00:03:49 Duration
Lecture 2 Building Our PHP Template CSSHTML 00:05:24 Duration
Lecture 3 Creating Template Menu 00:05:06 Duration
Lecture 4 Create Template Login Script 00:04:45 Duration
Lecture 5 Template Logout Script 00:04:29 Duration
Lecture 6 CMS Switch Statement 00:03:49 Duration
Lecture 7 Building Our CMS 00:04:29 Duration
Lecture 8 Setting up our CMS Content 00:06:08 Duration
Lecture 9 Complete CMS Module 00:02:17 Duration
Lecture 10 Review And Exercise 00:01:46 Duration

Section 10 : PHP Functions

Lecture 1 Function Structure 00:06:41 Duration
Lecture 2 Built In Functions Maths And Strings 00:07:44 Duration
Lecture 3 Built In Functions Date And Time 00:04:06 Duration
Lecture 4 Custom Functions408 00:04:09 Duration
Lecture 5 Format With Functions 00:03:19 Duration
Lecture 6 Email Address Checking 00:07:42 Duration
Lecture 7 Database Functions 00:04:34 Duration
Lecture 8 Array Functions - sort And unique 00:05:23 Duration
Lecture 9 Array Functions - search, slice And merge 00:07:09 Duration
Lecture 10 Server Variables 00:05:54 Duration
Lecture 11 Browser Detection 00:03:10 Duration

Section 11 : Using External Files, And Images

Lecture 1 Reading Text Files
Lecture 2 Writing Text Files 00:04:05 Duration
Lecture 3 Working With Image Files - exif 00:04:54 Duration
Lecture 4 Creating Image Files With GD Library 00:04:32 Duration
Lecture 5 Managing Images With GD Library 00:05:34 Duration
Lecture 6 Resizing Images With PHP 00:02:50 Duration
Lecture 7 Uploading Files - Overview 00:03:16 Duration
Lecture 8 Uploading Files - In Action 00:06:29 Duration
Lecture 9 Remote File Parsing 00:05:27 Duration

Section 12 : Email With PHP

Lecture 1 Email With PHP And MySQL 00:01:18 Duration
Lecture 2 Sendmail SMTP Server 00:02:21 Duration
Lecture 3 Sendmail mail Function 00:05:45 Duration
Lecture 4 PHP mail CC And BCC 00:03:49 Duration
Lecture 5 HTML email Content 00:06:45 Duration
Lecture 6 Email Out - Hiding SMTP Address 00:01:41 Duration
Lecture 7 Email Out - Embedded Form 00:06:48 Duration
Lecture 8 Logging Sent Email 00:06:03 Duration

Section 13 : Real Life PHP Introduction

Lecture 1 Real Life Introduction 00:01:30 Duration
Lecture 2 Building PHP Tools - Button Maker 00:05:31 Duration
Lecture 3 Building PHP Tools - Embedded Tool 00:03:59 Duration
Lecture 4 Managing Deletions - Suspension Fields 00:03:29 Duration
Lecture 5 Managing Deletions - Suspend Record 00:05:28 Duration
Lecture 6 Managing Deletions - Restore Records 00:05:09 Duration
Lecture 7 OO Programming - A Caveat 00:02:07 Duration
Lecture 8 OO Programming Model - DB Connection 00:03:37 Duration
Lecture 9 OO Programming - DB Examples 00:06:06 Duration
Lecture 10 CMS Open Source 00:01:30 Duration
Lecture 11 CMS Joomla 00:04:56 Duration
Lecture 12 CRM Download And Extract 00:03:05 Duration
Lecture 13 CRM vTiger Install 00:03:39 Duration
Lecture 14 CRM Modifying vTiger 00:02:02 Duration