Course 3: Talking to a MySQL Database in PHP

Woh, this is episode 3 of our Epic PHP series!

Yep, and this one is all about databases:

• What the heck is a database anyways?
• Connecting to MySQL
• Creating a database and tables
• INSERT queries
• SELECT queries
• UPDATE and DELETE queries
• Using PDO in PHP to run queries
• Limiting Results
• Avoiding SQL Injection Attacks
• Prepared Statements
• Optional Function Arguments

Other episodes from this series:

• Episode 1.
• Episode 2.

• How to Speak Database
• Queries, Databases and Tables: Oh My!
• INSERTing and SELECTing Data
• Updating, Deleting and Putting it All Together
• Talking to Databases in PHP
• Object-Oriented Intro: Classes and Objects
• Centralized Configuration
• Limiting the Number of Results
• Optional Function Arguments
• Using Query Parameters
• Querying for One Pet
• Preventing SQL Injection Attacks with Prepared Statements