PHP with PDO: Build a Basic Task List with PHP, PDO & MySQL
4.9 (53 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.
966 students enrolled
Wishlisted Wishlist

Please confirm that you want to add PHP with PDO: Build a Basic Task List with PHP, PDO & MySQL to your Wishlist.

Add to Wishlist

PHP with PDO: Build a Basic Task List with PHP, PDO & MySQL

Learn and Understand PHP Database Objects (PDO), Build a Basic Task List with PHP, PDO, MYSQL and JQuery Ajax
4.9 (53 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.
966 students enrolled
Last updated 4/2017
English
English
Current price: $10 Original price: $95 Discount: 89% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2.5 hours on-demand video
  • 3 Articles
  • 3 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Build a Basic Task List with PDO, PHP and MySQL
  • Perform CRUD (Create, Read, Update and Delete) Operations with PDO
  • Protect any web application against SQL Injection
  • In depth understanding of PHP Data Object (PDO)
  • Dealing with Errors in PDO
  • Send Request via Ajax without page Refresh
  • Prompt support and value for your money
View Curriculum
Requirements
  • Already Setup PHP Development Environment running PHP 5.1 with a basic understanding of PHP Programming Language
  • Basic understanding of SQL Language (Every Query is well explained)
  • Little OOP knowledge will be nice but not required to follow along
Description

LATEST COURSE ON PDO RELEASED ON 18/05/2016

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.

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.

Who is the target 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.
  • Want to learn and understand a multi platform database API
  • You want to migrate from MySQLi or MySQL to PDO
  • PHP Developers who want to learn how to use PDO for database driven application.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 26 Lectures Collapse All 26 Lectures 02:23:40
+
Introduction to the course
5 Lectures 29:03

I'll go over the broad topics we'll cover in the course, as well as the finish product of the system that we will develop in this course. I'll also covered what is required to take this course, target audience and the benefits that will be derived from taking this course.

Preview 02:54

In this lecture you will gain an introductory understanding of PHP Data Objects (PDO) and know why you should learn how to use it.

Preview 04:46

In this lecture you will learn how to create a PDO object and make a persistent connection to MySQL database with PHP. You will also gain an understanding of the PDO Class. 

Connecting to MySQL Database with PDO
06:52

In this lecture you will learn how to handle database connection errors with PDO.

Dealing with Errors in PDO
07:15

In this lecture, we shall create the table that will be used in the next section.

Creating a table with PDO
07:16

This quiz will test your knowledge based on the content of section 1

Section 1 - Quiz
5 questions
+
Basic Crud Operations with PDO
4 Lectures 11:32

In this lecture you will learn how to perform basic insert statement to create new record with PDO 

Create
03:57

In this lecture you will learn how to retrieve record from database table using basic PDO select statement.

Read
03:41

In this lecture you will learn how to update record in a database table using basic update statement with PDO.

Update
02:12

In this lecture you will learn how to delete record from a database table using basic delete statement with PDO.

Delete
01:42

This quiz will test your understand of the contents of section 2

Section 2 - Quiz
3 questions
+
Security
2 Lectures 12:47

In this lecture you will learn about PDO prepared statement use to protect against SQL injection and parameters. You will also learn how to use named and unnamed parameters.

Parameters and Prepared Statements
08:17

In this lecture you will earn how to bind parameters to PDO prepared statement.

Binding Parameters to Prepared Statements
04:30

This quiz will test your understand of the contents of section 3

Section 3 - Quiz
3 questions
+
Some Useful PDO Methods
2 Lectures 05:23

In this lecture you will learn how to quickly retrieve the unique identification number ID at the same time the record was created. This method works on all common database platforms that uses the auto increment feature or the equivalent.

Getting the last Inserted ID
02:17

In this lecture you will learn how to check the number of rows affected by a query. 

Number of Affected rows
03:06
+
Advanced PDO Features
3 Lectures 17:34

In this lecture, you will learn how to take advantage of the transaction feature available is PDO, you will also learn how to check if your database supports transaction and how to change the storage engine for your database table.

Transactions
09:34

In this lecture you will learn about some of the most useful data fetching modes available in PDO.

PDO Data Fetching Modes
07:59

Further Reading.

Further Reading
00:01
+
Building a Basic Task List
10 Lectures 01:07:06

in this video a I'll walk you through the project directory structure and general overview.

Preview 07:25

In this lecture we shall create a table to hold task information.

Prepping The Database
01:30

In this lecture, we prep the interface for create task, display task and style the message alert div.

Building the Interface
06:29

In this lecture you will learn how to create a task using jQuery Ajax to send request to a PHP script for processing in order to avoid page refresh.

Creating a Task with JQuery and PHP
14:24

In this lecture you will learn how to display list of existing task using jQuery Ajax and PHP.

Displaying Existing Tasks with JQuery and PHP
07:16

In this lecture you will learn how to update task details using jQuery Ajax to send request to a PHP script. You will learn how to make HTML elements editable, so that you don't need to create a separate form to edit a task, you simply click and start editing when you're done the request will be sent to PHP script for processing via Ajax.

Updating a Task with JQuery and PHP (With In-place Edit)
18:21

In this lecture you will learn how to delete a task using jQuery Ajax to send request to a PHP script for processing to avoid page refresh.

Deleting a Task with JQuery and PHP
07:02

In this lecture you'll learn how to check if a record was updated or not and display appropriate message. I also talk about validation and what to do if you need help.

Wrapping up
02:38

Source Code
00:00

Bonus Lecture
02:01
About the Instructor
Osayawe Terry Ogbemudia
4.4 Average rating
201 Reviews
3,105 Students
4 Courses
Fullstack Developer at Visual Math Interactive Sdn. Bhd

I am a professional computer scientist, web programmer and developer. My fields of expertise include Information Technology, Software Development and Web Programming. In 2007, I ventured into Software Programming and Database Administration. I graduated with a bachelor's degree in Software Engineering from University of East London, and I'm also a certified Oracle Database Professional (OCP).

I'm passionate about teaching and sharing my knowledge on various platforms. In 2008, I facilitated high-end trainings in Oracle Database, Linux Operating System, Oracle Financial 11i, and Web Design at KarRox and 2010 at NIIT. I am also the author of the best selling PHP user authentication course on Udemy.