Dynamic Web Design with PHP and MySQL Training Video

expand all / collapse all

• 00. Free Videos From This Course

  • Using PHP Script Tags
  • Using The SELECT Tag
  • HTML Tables
  • Code Formatting Rules
  • Displaying A Data From A File Into An HTML Table
  • Functions That Receives Data And Returns A Value
  • Loading An Array From A File
  • Comparison Operators
  • Pass Data To A Select
  • Using Indexes
  • Subqueries - Part 1

• 01. Introduction

  • 0101 What Is PHP?
  • 0102 What Is MySQL?
  • 0103 Simple PHP Program
  • 0104 The Example Web Site - King Real Estate

• 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

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.