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

English | MP4 + Project Files | 1280 x 720 | AVC ~1200 kbps | 25 fps

AAC | 126 Kbps | 44.1 KHz | 1 channel | 11h 30min | 1.73 GB

Genre: Video Tutorial / Web Development for a PHP / MySQL

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