Course 3: Talking to a MySQL Database in PHP
Offered By: SymfonyCasts
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 ProgrammingDelft 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