Learning PHP MySQL Training on DVD - UK Delivery Only

Learn how to take your skills to the next level. This Learning PHP MySQL Tutorial Video is the ultimate in comprehensive learning for the discerning professional.

The training uses broadcast quality audio and video to deliver concise and informative training right to your desktop. The training comes complete with practical working files and presented via an intuitive, easy-to-use interface, allowing you to learn at your own pace.

These Learning PHP MySQL Tutorials make learning simple, quick and enjoyable. All Training Videos are authored by professional instructors who have a passion for teaching.

View Sample from Learning PHP MySQL Training on DVD
(sample may be at reduced resolution)

01. Intro To Beginners PHP

• Intro - What This Course Covers
• What We Need 

02. Getting Started

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

03. Our First Look At MySQL And PHP

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

04. Outputting And Processing Data

• Hiding Sensitive Data
• Including Sensitive Data
• PHP Echo And Quotes - Part 1
• PHP Echo And Quotes - Part 2
• Formatting Using sprintf
• Outputting Tabular Data
• Outputting Data And Time
• Introduction To Loops
• do...while Loops
• Repetition - for Loops
• Repetition - foreach Loops
• MySQL Select
• Formatting Outputted MySQL Data
• MySQL Joins - Overview
• MySQL Joins
• MySQL Where And Order By

05. Dealing With Variables

• Intro To Sending Variables
• Using Variables With GET
• Using Variables With POST
• Inserting Sent Data In A Database
• Updating A Database With Sent Data - Part 1
• Updating A Database With Sent Data - Part 2
• Redirection In PHP
• Creating A List - Example
• Styling The List - Example
• What We Have learned

06. Inserting And Using Database Data

• Using One Page To Process Forms - Part 1
• Using One Page To Process Forms - Part 2
• Multi Part Forms
• Save And Return POST and GET
• Save And Return INSERT
• Save And Return UPDATE
• Normalization
• Simple Drop Downs
• Complex Drop Downs
• Revised Form - The Code
• Revised Form - The Result
• Lesson Review

07. MySQL Joins

• MySQL Join Types - Examples
• MySQL Join Diagrams
• Creating Nested Lists
• MySQL Nested Processing
• Styling Our Lists
• Intro To Functions
• Included Files

08. PHP Errors And Security

• Introduction To Security And Errors
• Error Types - Databases
• PHP Error Types
• Custom Error Testing
• Create A Login Page
• Passwords For Login
• Protecting Pages
• Using Cookies - Theory
• Using Cookies - Practice
• Access Levels - Basic Restriction
• Access Levels - Restrict Fields
• Managing Users - Structure
• Managing Users - Create New
• Audit Trails - Access Function
• Audit Trails - Logging Logins
• Errors And Security - Review

09. Building A Template Page

• PHP Templates
• Building Our PHP Template CSS/HTML
• Creating Template Menu
• Create Template Login Script
• Template Logout Script
• CMS Switch Statement
• Building Our CMS
• Setting up our CMS Content
• Complete CMS Module
• Review And Exercise

10. PHP Functions

• Function Structure
• Built In Functions Maths And Strings
• Built In Functions Date And Time
• Custom Functions
• Format With Functions
• Email Address Checking
• Database Functions
• Array Functions - sort And unique
• Array Functions - search, slice And merge
• Server Variables
• Browser Detection

11. Using External Files, And Images

• Reading Text Files
• Writing Text Files
• Working With Image Files - exif
• Creating Image Files With GD Library
• Managing Images With GD Library
• Resizing Images With PHP
• Uploading Files - Overview
• Uploading Files - In Action
• Remote File Parsing

12. Email With PHP

• Email With PHP And MySQL
• Sendmail SMTP Server
• Sendmail mail Function
• PHP mail CC And BCC
• HTML email Content
• Email Out - Hiding SMTP Address
• Email Out - Embedded Form
• Logging Sent Email

13. Real Life PHP Introduction

• Real Life Introduction
• Building PHP Tools - Button Maker
• Building PHP Tools - Embedded Tool
• Managing Deletions - Suspension Fields
• Managing Deletions - Suspend Record
• Managing Deletions - Restore Records
• OO Programming - A Caveat
• OO Programming Model - DB Connection
• OO Programming - DB Examples
• CMS Open Source
• CMS Joomla
• CRM Download And Extract
• CRM vTiger Install
• CRM Modifying vTiger

14. About The Author

• About The Author