Intro to Beginners PHP
  • Working Files - Download These First
  • Intro - What This Course Covers
  • What We Need
Getting Started
  • Introducing XAMPP
  • Downloading XAMPP
  • XAMPP - Installing
  • XAMPP - Setting Up
  • Setting Up A PHP Editor - bluefish
  • Introduction To bluefish
  • The bluefish Interface
  • bluefish Summary
  • Downloading PHP Snippets
  • PHP Comments
  • Our First PHP Page
  • Using PHP Snippets
  • Intro To MySQL Databases
  • Into To phpMyAdmin
  • External Helpful Resources
  • Exercises
Our First Look At MySQL And PHP
  • Connecting To A MySQL Database - Part 1
  • Connecting To A MySQL Database - Part 2
  • Our First MySQL Query - Part 1
  • Our First MySQL Query - Part 2
  • Creating A MySQL Database
  • Create MySQL Tables - Part 1
  • Create MySQL Tables - Part 2
  • Database Structure
  • Inserting Data in MySQL
  • Updating MySQL Tables
  • Updating MySQL Tables Example
  • MySQL Delete Command
  • Intro To Variables And Operators
  • Arithmetic Operators
  • Assignment Operators
  • Comparison Operators
  • Introduction To Arrays
  • Numeric Arrays
  • Associative Arrays
  • Multi-Dimensional Arrays
  • Creating And Working With Arrays
  • Creating Arrays From A Text File
  • Lesson Review
Outputting And Processing Data
  • Hiding Sensitive Data
  • Including Sensitive Data
  • PHP Echo And Quotes - Part 1
  • PHP Echo And Quotes - Part 2
  • Formatting Using sprintf
  • Outputting Tabular Data
  • Outputting Data And Time
  • Introduction To Loops
  • do...while Loops
  • Repetition - for Loops
  • Repetition - foreach Loops
  • MySQL Select
  • Formatting Outputted MySQL Data
  • MySQL Joins - Overview
  • MySQL Joins
  • MySQL Where And Order By
Dealing With Variables
  • Intro To Sending Variables
  • Using Variables With GET
  • Using Variables With POST
  • Inserting Sent Data In A Database
  • Updating A Database With Sent Data - Part 1
  • Updating A Database With Sent Data - Part 2
  • Redirection In PHP
  • Creating A List - Example
  • Styling The List - Example
  • What We Have Learned
Inserting And Using Database Data
  • Using One Page To Process Forms - Part 1
  • Using One Page To Process Forms - Part 2
  • Multi Part Forms
  • Save And Return POST and GET
  • Save And Return INSERT
  • Save And Return UPDATE
  • Normalization
  • Simple Drop Downs
  • Complex Drop Downs
  • Revised Form - The Code
  • Revised Form - The Result
  • Lesson Review
MySQL Joins
  • MySQL Join Types - Examples
  • MySQL Join Diagrams
  • Creating Nested Lists
  • MySQL Nested Processing
  • Styling Our Lists
  • Intro To Functions
  • Included Files
PHP Errors And Security
  • Introduction To Security And Errors
  • Error Types - Databases
  • PHP Error Types
  • Custom Error Testing
  • Create A Login Page