Duration: 6 hrs / 86 lessons
Compatibilty: Win XP, 2000, 98, NT, Mac OS X, OS 9
Introduction
What This Course Covers
What You Will Need
Resources - Using PHP.net Pt.1
Resources - Using PHP.net Pt.2
Other PHP Resources
Hosting Resources
Starting with PHP
What is PHP
PHP Programming Standards
Embedding PHP in HTML
Embedding HTML in PHP
The All Important Semi-colon
Your First PHP Script
Comments
Chapter 2 Challenge
PHP Basics
Variables
PHP Statements
Values and Value Types Part 1
Values and Value Types Part 2
Referencing Variables and Constants
Superglobals
Variable Variables
Basic Operators Part 1
Basic Operators Part 2
Advanced Operators
Chapter 3 Challenge
PHP Conditionals and Loops
The "IF" Statement
Extending "IF"
"SWITCH" Statements
The "WHILE" Structure
The "DO-WHILE" Structure
The "FOR" Loop
Chapter 4 Challenge
Applying What You Know
INCLUDE and REQUIRE
Setting up Your File Structure
Global Headers and Footers
A Functional Website Example Pt.1
A Functional Website Example Pt.2
A Functional Website Example Pt.3
A Functional Website Example Pt.4
A Functional Website Example Pt.5
A Functional Website Example - Addendum
PHP and functions
Why use functions
Variable Scope
Creating and using Functions
Functions with Parameters
Returning Values
Chapter 6 Challenge
PHP Arrays
What is an Array
Creating Arrays
Multidimensional Arrays
"FOREACH" looping - basic
"FOREACH" looping - advanced
Navigating Arrays
Manipulating Keys
Sorting Arrays
Serialization
Challenge
Starting with MYSQL
Getting Information: mysql.com
Other MYSQL Resources
What is a relational database?
Accessing MYSQL - the command line
MYSQL Basics
Configuring Users in MYSQL - Part 1
Configuring Users in MYSQL - Part 2
Creating Databases and Tables
MYSQL Data Types - Numeric Types
MYSQL Data Types - Date Types
MYSQL Data Types - String Types
EXAMPLE: Creating A Table Statement - Part 1
EXAMPLE: Creating A Table Statement - Part 2
Basic MYSQL commands - INSERT
Basic MYSQL commands - SELECT and UPDATE
Basic MYSQL commands - DELETE and DROP
Setting Up phpMyAdmin
Using phpMyAdmin
Using MYSQL with PHP
Connecting to MYSQL
Choosing a database
Querying a database
Retrieving results
Useful MySQL functions in PHP
PHP and Sessions
What is a session
set_cookie vs session_start
Session Tracking With Built in PHP Functions
Session Tracking With Databases Pt.1
Session Tracking With Databases Pt.2
Final Words
Where to go from here |
