Learn PDO By Creating A CRUD Website (PHP & MySQL)

In this course, you'll learn how to connect to a database and perform various CRUD operations in PHP using PDO in MySQL.

What you'll learn

CRUD (Create, Read, Update, Delete) Operations on Database
PDO (PHP Data Objects)
Implement Live Search using JavaScript

Requirements

Basic understanding of HTML and CSS

Description

In this course, you will learn how to use PDO (PHP Data Objects) in PHP to perform operations on a database securely. We will be using the MySQL database in this class. But you can use other supported databases and almost all the code will be the same.

We will be using an Object-oriented approach to write the PHP code. So, you will even learn how to create a class, instantiate it and call the methods on the object.

At last, I will develop a web page where all the knowledge you have acquired during the course will be used to create a complete CRUD web page. As a bonus lecture, I will also show you how to code the Live Search mechanism in your webpage where you can perform operations on the database without reloading the page.

For taking this course, it is would be great if you have the following prerequisites:

Basic knowledge of HTML and CSS

Although there are these prerequisites, I will explain each and every line of code that we are going to write. So, even if you are a complete beginner, you can join in. Just follow along and you will learn a lot.

After completing this course, you will be able to perform Insert, Delete, Update and Select operations on your database. This will help you in creating backend applications.

Some examples where you can use this knowledge are:

Creating a to-do application

Creating a blog

Creating a simple registration system

Creating contact form

And more…

I will you all the best. Keep learning and happy coding.

Who this course is for:

Beginner Web Developers
Beginner PHP Developers