PHP & Databases with PDO Course (How To)
Offered By: Treehouse
Course Description
Overview
Whether you have aspirations of working on a Content Management System, an E-Commerce Site, a new and exciting web app, or an API you will eventually need to work with a Database. PHP and Databases work together through the use of PHP Data Objects or PDO for short.
What you'll learn
- PHP Data Objects
- PDO
- Database Security
- Queries & Results
Syllabus
Getting Started With PDO
Now that you know the basics of the PHP language it is time for us to start talking about how to integrate with databases. For this course we are going to use a sample database that is structured to fit the construct of a Movie rental store. This sample database is called the Sakila database.
Chevron 5 steps-
Introductions
5:24
-
Connecting with PDO
6:26
-
PDO Basics
3 questions
-
Managing Errors
8:17
-
Managing Errors in PDO
3 questions
PDO Queries & Results
Queries are one of the most used items out of all of the interfacing we will want to do with our PDO object. Let's take a closer look at queries using PDO and what these queries will return to us.
Chevron 6 steps-
Queries with PDO
6:20
-
Result Sets
7:20
-
PDO Queries & Results
5 questions
-
Working With Results
6:05
-
Query by ID
5:27
-
Working With Results
3 questions
PDO Database Security
Security is very important when we start working with databases. Most all databases contain information that could be considered sensitive or private. We would not want to open up ourselves to attacks from the outside or accidental dumps of this private information.
Chevron 5 steps-
PDO Security
3:01
-
Filter Input, Escape Output
8:02
-
PDO Security
4 questions
-
Cleanup & Final Steps
10:26
-
PHP & Databases with PDO
2 objectives
Taught by
Hampton Paulk
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