Real World PHP Programming: The Basics

To access all of the tutorials click here

Real World PHP Programming: The Basics

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