PHP & MySQL – Learn The Easy Way. Master PHP & MySQL Quickly

Course Curriculum

Chapter 1: Getting Started

Lecture 1: PHP Working Files – Download These First

Lecture 2: 0101 What The Course Covers

Lecture 3: 0102 Course Setup Using XAMPP

Lecture 4: 0103 Installing XAMPP On Windows

Lecture 5: 0104 Installing MAMP On The Mac

Lecture 6: 0105 Installing XAMPP On Linux

Lecture 7: 0106 Configuring PHP And MySQL

Lecture 8: 0107 Configuring Apache

Lecture 9: 0108 Using Editors And IDEs

Lecture 10: 0109 Saving Your Code

Lecture 11: 0110 Searching PHP And MySQL Documentation

Lecture 12: 0111 Getting Help And Verifying XAMPP Status

Lecture 13: 0112 Setup And Finding Course Files:

Lecture 14: 0113 Lab: Building A New Website

Lecture 15: 0114 Solution: Building A New Website

Chapter 2: Understanding The Basics

Lecture 1: 0201 Creating Variables In PHP

Lecture 2: 0202 Assigning Different Data Types

Lecture 3: 0203 Performing Arithmetic Operations

Lecture 4: 0204 Adding Comments To The Code

Lecture 5: 0205 Assigning Constant Values In PHP

Lecture 6: 0206 Using The printf Command To Format A String

Lecture 7: 0207 Understanding The substr Command

Lecture 8: 0208 Working With Strings

Lecture 9: 0209 Debugging An Application

Lecture 10: 0210 Lab: Mixing HTML And PHP

Lecture 11: 0211 Solution: Mixing HTML And PHP

Chapter 3: Working With Arrays

Lecture 1: 0301 Working With Numeric Keys

Lecture 2: 0302 Working With Associative Arrays

Lecture 3: 0303 Assigning Values To Arrays

Lecture 4: 0304 Creating A Multidimensional Array

Lecture 5: 0305 Searching Arrays

Lecture 6: 0306 Sorting Arrays

Lecture 7: 0307 Removing Values From Arrays

Lecture 8: 0308 Measuring Array Differences

Lecture 9: 0309 Merging Arrays

Lecture 10: 0310 Lab: Using An Array To Generate A Drop Down Menu

Lecture 11: 0311 Solution: Using An Array To Generate A Drop Down Menu

Chapter 4: Creating Control Structures: Looping And Branching

Lecture 1: 0401 Comparing Values

Lecture 2: 0402 Using if, else, And elseif

Lecture 3: 0403 Using switch

Lecture 4: 0404 Setting Up A for Loop

Lecture 5: 0405 Configuring while And do while Loops

Lecture 6: 0406 Using A foreach Loop

Lecture 7: 0407 Branching With continue, break, And goto

Lecture 8: 0408 Lab: Using Loops To Display Rows Of Data On A Web Page

Lecture 9: 0409 Solution: Using Loops To Display Rows Of Data On A Web Page

Chapter 5: Managing The Code: Functions

Lecture 1: 0501 Using Built-In Functions

Lecture 2: 0502 Creating Your Own Functions

Lecture 3: 0503 Returning Values

Lecture 4: 0504 Defining Mandatory And Optional Parameters

Lecture 5: 0505 Using Parameters By Reference

Lecture 6: 0506 Handling A Variable Number Of Parameters

Lecture 7: 0507 Understanding Global Variables In PHP

Lecture 8: 0508 Lab: Creating A Function Which Paginates Rows Of Data

Lecture 9: 0509 Solution: Creating A Function Which Paginates Rows Of Data

Chapter 6: Managing The Code: Object-Oriented Programming

Lecture 1: 0601 Defining Classes

Lecture 2: 0602 Adding Properties

Lecture 3: 0603 Creating Methods

Lecture 4: 0604 Determining The Visibility Level

Lecture 5: 0605 Building Classes By Inheritance

Lecture 6: 0606 Handling Exceptions

Lecture 7: 0607 Introducing The MVC (Model-View-Controller) Design Pattern

Lecture 8: 0608 Lab: Building An MVC Website Using OOP

Lecture 9: 0609 Solution: Building An MVC Website Using OOP

Chapter 7: Managing The Code: External Libraries

Lecture 1: 0701 Loading Code With include

Lecture 2: 0702 Loading Code With require

Lecture 3: 0703 Loading Code Once Only

Lecture 4: 0704 PHP Extensions And PECL

Lecture 5: 0705 PHP Libraries And PEAR

Lecture 6: 0706 Lab: Downloading An External Library

Lecture 7: 0707 Solution: Downloading An External Library

Chapter 8: Managing Files

Lecture 1: 0801 Using The f* Family

Lecture 2: 0802 Using The *file* Family

Lecture 3: 0803 Understanding Streams

Lecture 4: 0804 Updating The Error_Log

Lecture 5: 0805 Parsing Directory Structures

Lecture 6: 0806 Lab: Reading A CSV File

Lecture 7: 0807 Solution: Reading A CSV File

Chapter 9: Managing A MySQL Database

Lecture 1: 0901 Understanding RDBMS Terminology

Lecture 2: 0902 Command Line Access

Lecture 3: 0903 Using phpMyAdmin

Lecture 4: 0904 Configuration

Lecture 5: 0905 Creating A Database

Lecture 6: 0906 Managing Tables – Part 1

Lecture 7: 0907 Managing Tables – Part 2

Lecture 8: 0908 Understanding Indexes And Relationships

Lecture 9: 0909 Establishing Relationships And Constraints

Lecture 10: 0910 Lab: Defining Tables And Relationships For A Website

Lecture 11: 0911 Solution: Defining Tables And Relationships For A Website

Chapter 10: Understanding Structured Query Language (SQL)

Lecture 1: 1001 Retrieving Data Using SELECT