Understanding PHP Data Objects (PDO)
3.8 (18 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
353 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Understanding PHP Data Objects (PDO) to your Wishlist.

Add to Wishlist

Understanding PHP Data Objects (PDO)

Learn to use the PDO library to access databases using PHP
3.8 (18 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
353 students enrolled
Last updated 2/2017
English
Curiosity Sale
Current price: $10 Original price: $50 Discount: 80% off
30-Day Money-Back Guarantee
Includes:
  • 1.5 hours on-demand video
  • 3 Articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Work with MySQL and other database software from PHP including connecting, inserting, updating records, displaying database records in lists within HTML and database security.
View Curriculum
Requirements
  • Will require a webserver (Apache or Nginx) with PHP 5.1 or greater, and MySQL installed. Students will also require database management software such as Sequel Pro (Mac), HeidiSQL (Windows) or MySQL workbench (Linux).
Description

The course teaches PHP Data Objects (PDO), the preferred way to connect to databases within PHP. It covers connecting to the database, and using all the features required to build fast, scalable applications that use a database connection. It covers essential concepts like security, and best practices with using the data retrieved from the database.

While a basic knowledge of PHP is recommended for this course, both beginners and experienced web developers will gain a complete understanding of how PHP Data Objects work.

A basic knowledge of PHP is recommended for this course. You will need to be able to open and write to a basic PHP file and be able to have a server and database installed. This course will use MySQL server.

Exactly What Is PDO?

The PHP Data Objects (PDO) extension defines a lightweight, consistent interface for accessing databases in PHP. Each database driver that implements the PDO interface can expose database-specific features as regular extension functions. Note that you cannot perform any database functions using the PDO extension by itself; you must use a database-specific PDO driver to access a database server.

PDO provides a data-access abstraction layer, which means that, regardless of which database you're using, you use the same functions to issue queries and fetch data. PDO does not provide a database abstraction; it doesn't rewrite SQL or emulate missing features. You should use a full-blown abstraction layer if you need that facility.

Who is the target audience?
  • Anyone with basic knowledge of PHP, database experience not required but is helpful, as this is demonstrated.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
19 Lectures
01:44:01
+
Introduction
1 Lecture 05:45

Download the course files here.

Preview 05:45
+
Understanding PHP Data Objects (PDO)
4 Lectures 22:25

Explains how to list the available database drivers installed on the system that can be used with PDO

Preview 03:05

Setting up an example database, explaining each column and inserting some example records that we can use throughout the series.

Preview 04:12

Using PHP to connect to the database and checking what we can do if a connection fails

Connecting
08:40

Setting error levels for PDO, so we can check for errors in different ways.

Error Levels
06:28
+
Fetching Results
6 Lectures 39:28

Sending a basic query to the database server.

Basic Queries
05:02

Fetching a list of results from our database table, and examining the data we receive

Fetching Results
08:57

Looping over results so we can display them in a list or modify them. We use some HTML to display results to a user on a page.

Looping
05:02

Showing an easier way to fetch all results using one method so we don't need to loop over each row

Fetch All
05:15

Fetching results as an object, so we can work with data in true object oriented style and make our application clean and the data easier to work with.

Fetch As Object
08:16

Getting the count of rows in the results so we can either display the amount of results we have, or use this number for later calculations.

Row Count
06:56
+
Hands On Project: User Class Dates
1 Lecture 09:51

A small side project, creating a PHP class to represent a user in the system, which allows us to implement methods (functions) for each user we get back. This keeps our application DRY (do not repeat yourself) and much easier to work with, saving time in the future.

Project: User Class Dates
09:51
+
Security
2 Lectures 13:45

A look at security, and escaping data before we use it in our database queries, to help prevent against SQL injection.

Escaping
07:27

Prepared statements that help query with large amounts of user data and more importantly automatically protect against SQL injection without having to manually escape each peice of data.

Prepared Statements
06:18
+
Inserting
3 Lectures 11:37

Inserting new records into the database.

Inserting
07:14

Getting the last inserted ID of the record so we can perform future queries using the last record as a reference.

Last Inserted ID
04:01

Request a Course
00:22
+
Bonus Material
2 Lectures 01:17
Bonus Lecture: Certificate of Completion
01:03

Bonus Lecture: Course Discounts
00:14
About the Instructor
Stone River eLearning
4.2 Average rating
16,714 Reviews
275,583 Students
201 Courses
270,000+ Happy Udemy Students

At Stone River eLearning, technology is all we teach. If you're interested in programming, development or design - we have it covered. 

Check out our huge catalog of courses and join the over 450,000 students currently taking Stone River eLearning courses. We currently offer 100+ different technology training courses on our Stone River eLearning website and are adding new courses on hot and trending topics every month. A subscription option is available for those with a real passion for learning.