Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

SymfonyCasts

Course 3: Talking to a MySQL Database in PHP

via SymfonyCasts

Overview

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.

Syllabus

  • 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

Taught by

Ryan Weaver and Leanna Pelham

Reviews

Start your review of Course 3: Talking to a MySQL Database in PHP

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.