Learning Dynamic Website Design – PHP MySQL and JavaScript

Course Curriculum

Chapter 1: Introduction

Lecture 1: Working Files – Download These First

Lecture 2: 0101 What is PHP

Lecture 3: What Is MySQL?

Lecture 4: Simple PHP Program

Lecture 5: The Example Web Site – King Real Estate

Chapter 2: Interface

Lecture 1: Setting Up Your Computer For PHP And MySQL

Lecture 2: Installing WAMP For Windows

Lecture 3: Installing MAMP For Macintosh – Part 1

Lecture 4: Installing MAMP For Macintosh – Part 2

Lecture 5: Using A Hosting Service

Chapter 3: PHP Basics

Lecture 1: Using PHP Script Tags

Lecture 2: Displaying HTML To Your Browser Window

Lecture 3: HTML Forms

Lecture 4: Using The SELECT Tag

Lecture 5: Using The TEXTAREA Tag

Lecture 6: Using The RADIOBUTTON Tag

Lecture 7: Using The CHECKBOX Tag

Lecture 8: Assigning Values To Variables

Lecture 9: Appending Text

Lecture 10: Debugging Techniques – Part 1

Lecture 11: Assignment 1

Lecture 12: Assignment 1 – Solution

Chapter 4: PHP Programming Fundamentals

Lecture 1: String Delimiters

Lecture 2: Simple Math

Lecture 3: HTML Tables

Lecture 4: Using IF Statements

Lecture 5: The ELSE Clause

Lecture 6: Nested IFs

Lecture 7: Code Formatting Rules

Lecture 8: Comparison Operators

Lecture 9: Using AND

Lecture 10: Using OR

Lecture 11: Using NOT

Lecture 12: Field Validations

Lecture 13: Using DIVs

Lecture 14: Using DIVs And Forms

Lecture 15: Debugging Techniques – Part 2

Lecture 16: Assignment 2

Lecture 17: Assignment 2 – Solution

Chapter 5: Advanced PHP Constructs

Lecture 1: The FOR Loop

Lecture 2: The WHILE Loop

Lecture 3: Reading A File

Lecture 4: Writing To A File

Lecture 5: Displaying A Data From A File Into An HTML Table

Lecture 6: Debugging Techniques – Part 3

Lecture 7: Assignment 3

Lecture 8: Assignment 3 – Solution

Chapter 6: Functions, Arrays, And Strings

Lecture 1: Simple Function

Lecture 2: Functions That Receives Data

Lecture 3: Functions That Returns A Value

Lecture 4: Functions That Receives Data And Returns A Value

Lecture 5: Variable Scope

Lecture 6: Functions That Returns Multiple Values

Lecture 7: Using Include Files

Lecture 8: Array Basics

Lecture 9: Sorting Arrays

Lecture 10: Loading An Array From A File

Lecture 11: Loading An Array From A Directory

Lecture 12: Recursive Programming

Lecture 13: Finding Text

Lecture 14: Finding Text With Regular Expressions

Lecture 15: Finding Simple Patterns Using Regular Expressions

Lecture 16: Debugging Techniques – Part 4

Lecture 17: Assignment 4

Lecture 18: Assignment 4 – Solution

Chapter 7: Introduction To MySQL

Lecture 1: Introduction To SQL

Lecture 2: The Example Database

Lecture 3: Interactive MySQL

Lecture 4: Creating Tables

Lecture 5: Simple SELECT Statement

Lecture 6: Comparison Operators

Lecture 7: Logical Operators

Lecture 8: Selecting Nulls

Lecture 9: Sorting Results

Lecture 10: Aggregate Functions

Lecture 11: Pattern Matching

Lecture 12: Inserting Rows

Lecture 13: Updating Table Data

Lecture 14: Deleting Rows

Lecture 15: SQL Debugging Techniques – Part 5

Lecture 16: Assignment 5

Lecture 17: Assignment 5 – Solution

Chapter 8: PHP With MySQL

Lecture 1: 0801 Connecting To MySQL Within A PHP Program

Lecture 2: 0802 Pass Data To A Select

Lecture 3: 0803 Adding Rows To A Table

Lecture 4: 0804 Deleting Rows From A Table

Lecture 5: 0805 Updating Data In A Table

Lecture 6: 0806 Populating A Select-Option List

Lecture 7: 0807 Login Validation

Lecture 8: Relative Referencing

Lecture 9: Creating Tables With phpMyAdmin

Lecture 10: Inserting Data With phpMyAdmin