Beginner PHP and MySQL Tutorial

Course Curriculum

Chapter 1: Intro to Beginners PHP

Lecture 1: Working Files – Download These First

Lecture 2: Intro – What This Course Covers

Lecture 3: What We Need

Chapter 2: Getting Started

Lecture 1: Introducing XAMPP

Lecture 2: Downloading XAMPP

Lecture 3: XAMPP – Installing

Lecture 4: XAMPP – Setting Up

Lecture 5: Setting Up A PHP Editor – bluefish

Lecture 6: Introduction To bluefish

Lecture 7: The bluefish Interface

Lecture 8: bluefish Summary

Lecture 9: Downloading PHP Snippets

Lecture 10: PHP Comments

Lecture 11: Our First PHP Page

Lecture 12: Using PHP Snippets

Lecture 13: Intro To MySQL Databases

Lecture 14: Into To phpMyAdmin

Lecture 15: External Helpful Resources

Lecture 16: Exercises

Chapter 3: Our First Look At MySQL And PHP

Lecture 1: Connecting To A MySQL Database – Part 1

Lecture 2: Connecting To A MySQL Database – Part 2

Lecture 3: Our First MySQL Query – Part 1

Lecture 4: Our First MySQL Query – Part 2

Lecture 5: Creating A MySQL Database

Lecture 6: Create MySQL Tables – Part 1

Lecture 7: Create MySQL Tables – Part 2

Lecture 8: Database Structure

Lecture 9: Inserting Data in MySQL

Lecture 10: Updating MySQL Tables

Lecture 11: Updating MySQL Tables Example

Lecture 12: MySQL Delete Command

Lecture 13: Intro To Variables And Operators

Lecture 14: Arithmetic Operators

Lecture 15: Assignment Operators

Lecture 16: Comparison Operators

Lecture 17: Introduction To Arrays

Lecture 18: Numeric Arrays

Lecture 19: Associative Arrays

Lecture 20: Multi-Dimensional Arrays

Lecture 21: Creating And Working With Arrays

Lecture 22: Creating Arrays From A Text File

Lecture 23: Lesson Review

Chapter 4: Outputting And Processing Data

Lecture 1: Hiding Sensitive Data

Lecture 2: Including Sensitive Data

Lecture 3: PHP Echo And Quotes – Part 1

Lecture 4: PHP Echo And Quotes – Part 2

Lecture 5: Formatting Using sprintf

Lecture 6: Outputting Tabular Data

Lecture 7: Outputting Data And Time

Lecture 8: Introduction To Loops

Lecture 9: do…while Loops

Lecture 10: Repetition – for Loops

Lecture 11: Repetition – foreach Loops

Lecture 12: MySQL Select

Lecture 13: Formatting Outputted MySQL Data

Lecture 14: MySQL Joins – Overview

Lecture 15: MySQL Joins

Lecture 16: MySQL Where And Order By

Chapter 5: Dealing With Variables

Lecture 1: Intro To Sending Variables

Lecture 2: Using Variables With GET

Lecture 3: Using Variables With POST

Lecture 4: Inserting Sent Data In A Database

Lecture 5: Updating A Database With Sent Data – Part 1

Lecture 6: Updating A Database With Sent Data – Part 2

Lecture 7: Redirection In PHP

Lecture 8: Creating A List – Example

Lecture 9: Styling The List – Example

Lecture 10: What We Have Learned

Chapter 6: Inserting And Using Database Data

Lecture 1: Using One Page To Process Forms – Part 1

Lecture 2: Using One Page To Process Forms – Part 2

Lecture 3: Multi Part Forms

Lecture 4: Save And Return POST and GET

Lecture 5: Save And Return INSERT

Lecture 6: Save And Return UPDATE

Lecture 7: Normalization

Lecture 8: Simple Drop Downs

Lecture 9: Complex Drop Downs

Lecture 10: Revised Form – The Code

Lecture 11: Revised Form – The Result

Lecture 12: Lesson Review

Chapter 7: MySQL Joins

Lecture 1: MySQL Join Types – Examples

Lecture 2: MySQL Join Diagrams

Lecture 3: Creating Nested Lists

Lecture 4: MySQL Nested Processing

Lecture 5: Styling Our Lists

Lecture 6: Intro To Functions

Lecture 7: Included Files

Chapter 8: PHP Errors And Security

Lecture 1: Introduction To Security And Errors

Lecture 2: Error Types – Databases

Lecture 3: PHP Error Types

Lecture 4: Custom Error Testing

Lecture 5: Create A Login Page