YoVDO

Course 3: Talking to a MySQL Database in PHP

Offered By: SymfonyCasts

Tags

MySQL Courses PHP Courses Object-oriented programming Courses SQL Injection Prevention Courses

Course Description

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

Related Courses

Introduction to Functional Programming
Delft University of Technology via edX
Introduction to Office 365 Development and APIs
Microsoft via edX
Web Development and Design using Wordpress
California Institute of the Arts via Kadenze
Build a Basic PHP Website Course (How To)
Treehouse
Web Applications for Everybody
Independent