Books & Videos

Table of Contents

Chapter: Getting Started

What The Course Covers

11m 22s

Course Setup Using XAMPP

07m 0s

Installing XAMPP On Windows

06m 50s

Installing MAMP On The Mac

05m 5s

Installing XAMPP On Linux

04m 52s

Configuring PHP And MySQL

11m 59s

Configuring Apache

09m 34s

Using Editors And IDEs

06m 58s

Saving Your Code

02m 37s

Searching PHP And MySQL Documentation

07m 55s

Getting Help And Verifying XAMPP Status

07m 5s

Setup And Finding Course Files

06m 3s

Lab: Building A New Website

03m 55s

Solution: Building A New Website

03m 32s

Chapter: Understanding The Basics

Creating Variables In PHP

05m 32s

Assigning Different Data Types

09m 20s

Performing Arithmetic Operations

05m 43s

Adding Comments To The Code

02m 30s

Assigning Constant Values

04m 9s

Using The printf Command To Format A String

04m 26s

Understanding The substr Command

04m 41s

Working With Strings

08m 11s

Debugging An Application

07m 39s

Lab: Mixing HTML And PHP

03m 4s

Solution: Mixing HTML And PHP

04m 43s

Chapter: Working With Arrays

Working With Numeric Keys

03m 24s

Working With Associative Arrays

02m 1s

Assigning Values To Arrays

05m 13s

Creating A Multidimensional Array

05m 31s

Searching Arrays

05m 8s

Sorting Arrays

07m 32s

Removing Values From Arrays

04m 21s

Measuring Array Differences

03m 27s

Merging Arrays

01m 27s

Lab: Using An Array To Generate A Drop Down Menu

02m 9s

Solution: Using An Array To Generate A Drop Down Menu

04m 19s

Chapter: Creating Control Structures: Looping And Branching

Comparing Values

05m 21s

Using if, else, And elseif

07m 12s

Using switch

03m 16s

Setting Up A for Loop

04m 34s

Configuring while And do while Loops

05m 34s

Using A foreach Loop

05m 58s

Branching With continue, break, And goto

05m 19s

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

02m 16s

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

03m 23s

Chapter: Managing The Code: Functions

Using Built-In Functions

05m 36s

Creating Your Own Functions

06m 29s

Returning Values

03m 53s

Defining Mandatory And Optional Parameters

04m 11s

Using Parameters By Reference

05m 32s

Handling A Variable Number Of Parameters

04m 11s

Understanding Global Variables

06m 40s

Lab: Creating A Function Which Paginates Rows Of Data

02m 51s

Solution: Creating A Function Which Paginates Rows Of Data

08m 33s

Chapter: Managing The Code: Object-Oriented Programming

Defining Classes

09m 45s

Adding Properties

04m 56s

Creating Methods

07m 54s

Determining The Visibility Level

07m 58s

Building Classes By Inheritance

05m 14s

Handling Exceptions

07m 18s

Introducing The MVC (Model-View-Controller) Design Pattern

05m 27s

Lab: Building An MVC Website Using OOP

01m 54s

Solution: Building An MVC Website Using OOP

03m 8s

Chapter: Managing The Code: External Libraries

Loading Code With include

02m 47s

Loading Code With require

04m 34s

Loading Code Once Only

04m 5s

PHP Extensions And PECL

06m 16s

PHP Libraries And PEAR

04m 31s

Lab: Downloading An External Library

02m 19s

Solution: Downloading An External Library

03m 36s

Chapter: Managing Files

Using The f* Family

07m 16s

Using The *file* Family

05m 9s

Understanding Streams

07m 21s

Updating The Error_Log

05m 41s

Parsing Directory Structures

04m 15s

Lab: Reading A CSV File

03m 30s

Solution: Reading A CSV File

08m 37s

Chapter: Managing A MySQL Database

Understanding RDBMS Terminology

05m 52s

Command Line Access

04m 24s

Using phpMyAdmin

09m 56s

Configuration

12m 16s

Creating A Database

08m 47s

Managing Tables - Part 1

07m 57s

Managing Tables - Part 2

07m 8s

Understanding Indexes And Relationships

06m 48s

Establishing Relationships And Constraints

09m 34s

Lab: Defining Tables And Relationships For A Website

04m 32s

Solution: Defining Tables And Relationships For A Website

08m 47s

Chapter: Understanding Structured Query Language (SQL)

Retrieving Data Using SELECT

10m 46s

Adding Data Using INSERT

08m 42s

Editing Data Using UPDATE

07m 57s

Removing Data Using DELETE

05m 30s

Performing Advanced Queries Using JOIN

11m 51s

Lab: Creating Select, Insert, Update, And Delete SQL Statements

02m 24s

Solution: Creating Select, Insert, Update, And Delete SQL Statements

10m 41s

Chapter: Using PHP To Interact With A MySQL Database

Understanding The Different MySQL Database Extensions

10m 38s

Reading Data From A Table

09m 57s

Writing Data To A Table

11m 32s

Updating Data In A Table

09m 56s

Deleting Data From A Table

09m 52s

Reading Data From Multiple Tables

10m 14s

Lab: Display Products And Members Using PHP And MySQL

01m 56s

Solution: Display Products And Members Using PHP And MySQL

10m 46s

Chapter: Using Regular Expressions

Understanding The Three Regular Expression Command Sets

08m 27s

Defining Basic Patterns

09m 12s

Using preg_match For Form Validation

08m 38s

Finding All Matches With preg_match_all

04m 16s

Using preg_replace For Intelligent Search And Replace

06m 41s

Lab: Using Regular Expressions To Validate Form Data

03m 16s

Solution: Using Regular Expressions To Validate Form Data

10m 13s

Chapter: Managing Email

Sending Mail Using mail

10m 14s

Using External Mail Libraries

10m 48s

Adding An Attachment To Email

07m 0s

Sending Email Using SMTP

04m 0s

Lab: Using PHP To Send A Confirmation Email

03m 11s

Solution: Using PHP To Send A Confirmation Email

04m 53s

Chapter: Working With Date And Time

Understanding Timestamps

06m 48s

Using The date Command

04m 20s

Using The DateTime Class

07m 42s

Performing Date Arithmetic

09m 27s

Lab: Capturing Date Of Birth Using DateTime

01m 38s

Solution: Capturing Date Of Birth Using DateTime

08m 46s

Chapter: Managing Web Operations

Reading Inbound Information From Built-In Global Variables

05m 55s

Handling Cookies

12m 41s

Managing Sessions

09m 21s

Setting Headers And Performing Redirection

07m 42s

Reading Incoming Header Information

06m 34s

Using Output Buffering

06m 31s

Deploying An Application To A Website

07m 52s

Lab: Using Cookies And Sessions To Implement A Shopping Cart

07m 31s

Solution: Using Cookies And Sessions To Implement A Shopping Cart - Part 1

06m 55s

Solution: Using Cookies And Sessions To Implement A Shopping Cart - Part 2

06m 55s

Chapter: Building Web Forms

Capturing Form Data

16m 19s

Understanding Form Input Elements

07m 55s

Working With Select Tags

08m 11s

Defining Checkboxes And Radio Buttons

09m 14s

Handling File Uploads

08m 40s

Securing Form Data: Inbound Filtering

06m 47s

Securing Form Data: Form Data Validation

09m 17s

Securing Form Data: Output Escaping

06m 39s

Lab: Integrating Form Data With The Database

02m 41s

Solution: Integrating Form Data With The Database

07m 2s

Chapter: About The Author

About The Author

02m 2s