Real World PHP Programming Tutorial: The Basics

We hope you enjoyed the FREE lessons above. To view the complete contents, including the chapters below, please purchase the CD.
CLICK HERE TO BUY THIS CD

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 - Lesson 1
A Functional Website Example - Lesson 2
A Functional Website Example - Lesson 3
A Functional Website Example - Lesson 4
A Functional Website Example - Lesson 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 - Lesson 1
Configuring Users in MYSQL - Lesson 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 - Lesson 1
EXAMPLE: Creating A Table Statement - Lesson 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 - Lesson 1
Session Tracking With Databases - Lesson 2

Final Words
Where to go from here

Credits
About the Author