PHP Programming: The Basics
Introduction
Resources – Using PHP.net Pt.1
Resources – Using PHP.net Pt.2
Starting with PHP
PHP Basics
Referencing Variables and Constants
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
Credits
About the Author
