PHP Programming Tutorial Video - Try for FREE

Introduction

• What This Course Covers Demo
• What You Will Need Demo
• Resources - Using PHP.net Pt.1 Demo
• Resources - Using PHP.net Pt.2 Demo
• Other PHP Resources Demo
• Hosting Resources Demo

Starting with PHP

• What is PHP Demo
• PHP Programming Standards Demo
• Embedding PHP in HTML Demo
• Embedding HTML in PHP Demo
• The All Important Semi-colon Demo
• Your First PHP Script Demo
• Comments Demo
• Chapter 2 Challenge Demo

PHP Basics

• Variables Demo
• PHP Statements Demo
• Values and Value Types Part 1 Demo
• Values and Value Types Part 2 Demo
• Referencing Variables and Constants Demo
• Superglobals Demo
• Variable Variables Demo
• Basic Operators Part 1 Demo
• Basic Operators Part 2 Demo
• Advanced Operators Demo
• Chapter 3 Challenge Demo

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