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 |