Infinite Skills: Dynamic Web Design with PHP and MySQL Training Video [repost]

In this PHP - MYSQL training course you will learn how to leverage PHP and MySQL for your website development to create dynamic, interactive websites. This training is designed for the savvy developer, you should have some experience with programming languages, and familiarity with PHP and MySQL, as well as HTML.

Author Steve Perry starts with some basics on PHP, and integrating it into a website form. The tutorial continues on with some PHP programming fundamentals, covering the most often used functions - IF, ELSE, AND, OR, NOT, and others. You then cover looping, arrays and functions. As you continue on in this video training course, you cover the basics of MySQL - adding, deleting and updating data to tables. You will then combine PHP and MySQL together for managing your data. You finish off with some CSS, JavaScript and Ajax integration to bring it all together to make your site interactive.
Throughout this video tutorial, you will complete assignments that will help you apply everything you are learning along the way. By the end of this video course, you will have a solid understanding of how to apply PHP and MySQL together to create a dynamic website. Extensive working files are provided to allow you to follow along and create a project with the author in this Dynamic Web Design Course with PHP and MySQL.

Contents:
01. Introduction
0101 What Is PHP?
0102 What Is MySQL?
0103 Simple PHP Program
0104 The Example Web Site - King Real Estate
0105 How To Access Your Working Files

02. Interface
0201 Setting Up Your Computer For PHP And MySQL
0202 Installing WAMP For Windows
0203 Installing MAMP For Macintosh - Part 1
0204 Installing MAMP For Macintosh - Part 2
0205 Using A Hosting Service

03. PHP Basics
0301 Using PHP Script Tags
0302 Displaying HTML To Your Browser Window
0303 HTML Forms
0304 Using The SELECT Tag
0305 Using The TEXTAREA Tag
0306 Using The RADIOBUTTON Tag
0307 Using The CHECKBOX Tag
0308 Assigning Values To Variables
0309 Appending Text
0310 Debugging Techniques - Part 1
0311 Assignment 1
0312 Assignment 1 - Solution

04. PHP Programming Fundamentals
0401 String Delimiters
0402 Simple Math
0403 HTML Tables
0404 Using IF Statements
0405 The ELSE Clause
0406 Nested IFs
0407 Code Formatting Rules
0408 Comparison Operators
0409 Using AND
0410 Using OR
0411 Using NOT
0412 Field Validations
0413 Using DIVs
0414 Using DIVs And Forms
0415 Debugging Techniques - Part 2
0416 Assignment 2
0417 Assignment 2 - Solution

05. Advanced PHP Constructs
0501 The for Loop
0502 The while Loop
0503 Reading A File
0504 Writing To A File
0505 Displaying A Data From A File Into An HTML Table
0506 Debugging Techniques - Part 3
0507 Assignment 3
0508 Assignment 3 - Solution

06. Functions, Arrays, And Strings
0601 Simple Function
0602 Functions That Receives Data
0603 Functions That Returns A Value
0604 Functions That Receives Data And Returns A Value
0605 Variable Scope
0606 Functions That Returns Multiple Values
0607 Using Include Files
0608 Array Basics
0609 Sorting Arrays
0610 Loading An Array From A File
0611 Loading An Array From A Directory
0612 Recursive Programming
0613 Finding Text
0614 Finding Text With Regular Expressions
0615 Finding Simple Patterns Using Regular Expressions
0616 Debugging Techniques - Part 4
0617 Assignment 4
0618 Assignment 4 - Solution

07. Introduction To MySQL
0701 Introduction To SQL
0702 The Example Database
0703 Interactive MySQL
0704 Creating Tables
0705 Simple SELECT Statement
0706 Comparison Operators
0707 Logical Operators
0708 Selecting Nulls
0709 Sorting Results
0710 Aggregate Functions
0711 Pattern Matching
0712 Inserting Rows
0713 Updating Table Data
0714 Deleting Rows
0715 SQL Debugging Techniques - Part 5
0716 Assignment 5
0717 Assignment 5 - Solution

08. PHP With MySQL
0801 Connecting To MySQL Within A PHP Program
0802 Pass Data To A Select
0803 Adding Rows To A Table
0804 Deleting Rows From A Table
0805 Updating Data In A Table
0806 Populating A Select-Option List
0807 Login Validation
0808 Relative Referencing
0809 Creating Tables With phpMyAdmin
0810 Inserting Data With phpMyAdmin
0811 Common Database Functions
0812 Debugging Techniques - Part 6
0813 Assignment 6
0814 Assignment 6 - Solution - Part 1
0815 Assignment 6 - Solution - Part 2

09. PHP With Advanced MySQL
0901 Date Functions
0902 Using Indexes
0903 Grouping Data
0904 Having Clause
0905 Joining Tables - Part 1
0906 Joining Tables - Part 2
0907 Joining Tables - Part 3
0908 Subqueries - Part 1
0909 Subqueries - Part 2
0910 Assignment 7
0911 Assignment 7 - Solution

10. PHP With CSS, JavaScript And Ajax
1001 Basic JavaScript Syntax
1002 Validating A Form Field With JavaScript
1003 Positioning A DIV With JavaScript
1004 Parsing Multiple Values JavaScript With PHP
1005 Using Simple Ajax
1006 Using Ajax To Update A Form In Place
1007 Using Ajax To Show SQL Results In Place
1008 Using Ajax To Update The Database
1009 Debugging Techniques - Part 8
1010 Assignment 8
1011 Assignment 8 - Solution - Part 1
1012 Assignment 8 - Solution - Part 2
1013 Assignment 8 - Solution - Part 3

11. Conclusion
1101 Server-Side Solutions
1102 Security Considerations
1103 Sending Email With PHP (Simple Mail Program)
1104 Next Steps
1105 About The Author

Author: Steve Perry
project files are included