Difficulty: Beginner
| Format: MOV (High Quality)
So you’ve learned the basics – HTML and CSS – and are now ready to dig into building your own dynamic websites. Congratulations for getting this far; now it’s time for the fun part! In this course, I’ll teach you, from scratch, how to use PHP; we’ll also, naturally, have to learn a bit of MySQL in the process!
Includes: Project Files
Prologue
Hello!
Installation
The PHP Language
Syntax and Variables
Displaying Errors
Arrays
Modifying Arrays
Conditionals
Loops
Running Scripts
Includes and Requires
Formatted Strings
Decoding Functions and Scope
Objects at a Low Level
Heredocs
Passing Values From Page to Page
Using the Query String
$_POST
Sessions
Refactoring the Previous Lesson
Cookies
Working With Files
Creating a Counter
Manipulating Filenames
Homework Solutions
Midterm Project
A File-Based Mailing List - Part 1
A File-Based Mailing List - Part 2
MySQL
Hello MySQL
Inserting, Selecting, and Deleting
Updating Rows and Columns
Joining Tables
GUI Apps
PHP and MySQL
Anti-Pattern: PHP's MySQL API
PDO: Connecting
The Query Method
Prepared Statements
PDO Helper Functions
Namespaces
Hands-On Project
The Obligatory Blog: Part 1
The Obligatory Blog: Part 2
The Obligatory Blog: Part 3
The Obligatory Blog: Part 4
The Obligatory Blog: Part 5
The Next Level
Composer and ActiveRecord
Classes and Houses
Grouping Related Properties and Methods
An HTML Utility Class
A File Utility Class
Conclusion
Goodbye
