Learn and Understand PHP Data Objects (PDO)

Build a Basic Task List with PDO, PHP, MySQL and JQuery Ajax.

This course teaches PHP Data Objects (PDO), one of the available API for connecting to databases within PHP. PDO is an object oriented extension which was introduced with PHP 5.1, taking advantage of several features introduced into PHP at that time.

In this step by step course both beginners and experienced web developers will gain a comprehensive understanding of the modern PDO extension and how it can be used to create scalable database driven application.

This PHP with PDO course uses MySQL database to teach PDO concept and finally you learn how to build a basic task list using the concepts that has been taught in the course.

Students will also learn how to process task with JQuery Ajax to prevent page refresh, in-place edit with css and JavaScript.

My Approach

In this course I use simple examples that can be easily understood to illustrate concepts and build upon it.

See What Students are saying

"This was perfect for my skill level as an advanced beginner to lower intermediate PHP developer. Terry wastes no time, and the whole course is packed with great information. I also really like the Material Design CSS and JS used in the course, since I had never used it before. I am very appreciative of this knowledge I gained, and plan to go through the whole thing again, and use it as a reference later." - Collin Stubblefield

"Managed to complete making a PDO tasklist! very helpful! the content is well put together! understood some core concept of PHP PDO! overall highly recommended! keep making more videos! If you can make a shopping cart! for tutorial basis! thanks!" -Brian Gichohi

"The instructor is clear and engaging also knowledgeable and passionate about the course. The course is well taught by the instructor" - Abimbola Makinwa

"Terry is a great teacher. He goes the extra mile to ensure student satisfaction. He even offers to remotely connect to your machine to help out if your code is not working the way it should. Thanks ever so much." - Sahid Camara

Timely Support!

If you ever encounter any problem why taking this course, don't worry I am always here to help and guide you through.

Enroll today and get the skills and knowledge you need to succeed as a PHP developer. Every minute you let by is money and opportunity that are passing you by.

Intended Audience: This PDO course is for anyone who is not familiar with PHP Data Objects database API and/or students looking for a quick refresher on PDO.

Welcome to the Course!
What is PHP Data Objects (PDO)?
Connecting to MySQL Database with PDO
Dealing with Errors in PDO
Creating a table with PDO
Parameters and Prepared Statements
Binding Parameters to Prepared Statements
Getting the last Inserted ID
Number of Affected rows
Further Reading
Project structure and Overview
Prepping The Database
Building the Interface
Creating a Task with JQuery and PHP
Displaying Existing Tasks with JQuery and PHP
Updating a Task with JQuery and PHP (With In-place Edit)
Deleting a Task with JQuery and PHP
Wrapping up

What's included

  • 21 Video Lessons
  • 1 Text Lesson

  • Works on all devices
  • Certificate of completion

Ogbemudia Terry Osayawe


Terry is a professional Computer Scientist, thoroughly skilled and experienced in Information Technology, Software Development and Web Programming.

He ventured into Software Programming and Database Administration in 2007. Terry holds an undergraduate degree in Software Engineering from University of East London, and is also a certified Oracle Database Professional (OCP).

Having a passion for teaching, he seizes every opportunity that he finds to impact into others. In 2008, he facilitated high-end trainings in Oracle Database, Linux Operating System, Oracle Financial 11i, and Web Design at KarRox and 2010 at NIIT.

He is the founder of Terdia Technology Solutions, an Information Technology Company, which provides integrated solutions that leverage Information Technology and knowledge of business processes.