Learning PHP MySQL Tutorial DVD - Video Training

01. Intro To Beginners PHP

• Intro - What This Course Covers Demo
• What We Need Demo

02. Getting Started

• Introducing XAMPP Demo
• Downloading XAMPP Demo
• XAMPP - Installing Demo
• XAMPP - Setting Up Demo
• Setting Up A PHP Editor - bluefish Demo
• Introduction To bluefish Demo
• The bluefish Interface Demo
• bluefish Summary Demo
• Downloading PHP Snippets Demo
• Using PHP Snippets Demo
• PHP Comments Demo
• Our First PHP Page Demo
• Intro To MySQL Databases Demo
• Into To phpMyAdmin Demo
• External Helpful Resources Demo
• Exercises Demo

03. Our First Look At MySQL And PHP

• Connecting To A MySQL Database - Part 1 Demo
• Connecting To A MySQL Database - Part 2 Demo
• Our First MySQL Query - Part 1 Demo
• Our First MySQL Query - Part 2 Demo
• Creating A MySQL Database Demo
• Create MySQL Tables - Part 1 Demo
• Create MySQL Tables - Part 2 Demo
• Database Structure Demo
• Inserting Data In MySQL Demo
• Updating MySQL Tables Demo
• Updating MySQL Tables - Example Demo
• MySQL Delete Command Demo
• Intro To Variables And Operators Demo
• Arithmetic Operators Demo
• Assignment Operators Demo
• Comparison Operators Demo
• Introduction To Arrays Demo
• Numeric Arrays Demo
• Associative Arrays Demo
• Multi-Dimensional Arrays Demo
• Creating And Working With Arrays Demo
• Creating Arrays From A Text File Demo
• Lesson Review Demo

04. Outputting And Processing Data

• 0401 Hiding Sensitive Data
• 0402 Including Sensitive Data
• 0403 PHP Echo And Quotes - Part 1
• 0404 PHP Echo And Quotes - Part 2
• 0405 Formatting Using sprintf
• 0406 Outputting Tabular Data
• 0407 Outputting Data And Time
• 0408 Introduction To Loops
• 0409 do...while Loops
• 0410 Repetition - for Loops
• 0411 Repetition - foreach Loops
• 0412 MySQL Select
• 0413 Formatting Outputted MySQL Data
• 0414 MySQL Joins - Overview
• 0415 MySQL Joins
• 0416 MySQL Where And Order By

05. Dealing With Variables

• 0501 Intro To Sending Variables
• 0502 Using Variables With GET
• 0503 Using Variables With POST
• 0504 Inserting Sent Data In A Database
• 0505 Updating A Database With Sent Data - Part 1
• 0506 Updating A Database With Sent Data - Part 2
• 0507 Redirection In PHP
• 0508 Creating A List - Example
• 0509 Styling The List - Example
• 0510 What We Have learned

06. Inserting And Using Database Data

• 0601 Using One Page To Process Forms - Part 1
• 0602 Using One Page To Process Forms - Part 2
• 0603 Multi Part Forms
• 0604 Save And Return POST and GET
• 0605 Save And Return INSERT
• 0606 Save And Return UPDATE
• 0607 Normalization
• 0608 Simple Drop Downs
• 0609 Complex Drop Downs
• 0610 Revised Form - The Code
• 0611 Revised Form - The Result
• 0612 Lesson Review

07. MySQL Joins

• 0701 MySQL Join Types - Examples
• 0702 MySQL Join Diagrams
• 0703 Creating Nested Lists
• 0704 MySQL Nested Processing
• 0705 Styling Our Lists
• 0706 Intro To Functions
• 0707 Included Files

08. PHP Errors And Security

• 0801 Introduction To Security And Errors
• 0802 Error Types - Databases
• 0803 PHP Error Types
• 0804 Custom Error Testing
• 0805 Create A Login Page
• 0806 Passwords For Login
• 0807 Protecting Pages
• 0808 Using Cookies - Theory
• 0809 Using Cookies - Practice
• 0810 Access Levels - Basic Restriction
• 0811 Access Levels - Restrict Fields
• 0812 Managing Users - Structure
• 0813 Managing Users - Create New
• 0814 Audit Trails - Access Function
• 0815 Audit Trails - Logging Logins
• 0816 Errors And Security - Review

09. Building A Template Page

• 0901 PHP Templates
• 0902 Building Our PHP Template CSS/HTML
• 0903 Creating Template Menu
• 0904 Create Template Login Script
• 0905 Template Logout Script
• 0906 CMS Switch Statement
• 0907 Building Our CMS
• 0908 Setting up our CMS Content
• 0909 Complete CMS Module
• 0910 Review And Exercise

10. PHP Functions

• 1001 Function Structure
• 1002 Built In Functions Maths And Strings
• 1003 Built In Functions Date And Time
• 1004 Custom Functions
• 1005 Format With Functions
• 1006 Email Address Checking
• 1007 Database Functions
• 1008 Array Functions - sort And unique
• 1009 Array Functions - search, slice And merge
• 1010 Server Variables
• 1011 Browser Detection

11. Using External Files, And Images

• 1101 Reading Text Files
• 1102 Writing Text Files
• 1103 Working With Image Files - exif
• 1104 Creating Image Files With GD Library
• 1105 Managing Images With GD Library
• 1106 Resizing Images With PHP
• 1107 Uploading Files - Overview
• 1108 Uploading Files - In Action
• 1109 Remote File Parsing

12. Email With PHP

• 1201 Email With PHP And MySQL
• 1202 Sendmail SMTP Server
• 1203 Sendmail mail Function
• 1204 PHP mail CC And BCC
• 1205 HTML email Content
• 1206 Email Out - Hiding SMTP Address
• 1207 Email Out - Embedded Form
• 1208 Logging Sent Email

13. Real Life PHP Introduction

• 1301 Real Life Introduction
• 1302 Building PHP Tools - Button Maker
• 1303 Building PHP Tools - Embedded Tool
• 1304 Managing Deletions - Suspension Fields
• 1305 Managing Deletions - Suspend Record
• 1306 Managing Deletions - Restore Records
• 1307 OO Programming - A Caveat
• 1308 OO Programming Model - DB Connection
• 1309 OO Programming - DB Examples
• 1310 CMS Open Source
• 1311 CMS Joomla
• 1312 CRM Download And Extract
• 1313 CRM vTiger Install
• 1314 CRM Modifying vTiger

14. About The Author

• 1401 About The Author