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

Name: Learn PDO By Creating A CRUD Website (PHP & MySQL)
Rating: 4.6 (71 reviews)

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

Highest Rated

Created byGodson Thomas

Last updated 4/2019

English

English [Auto],

What you'll learn

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

Course content

3 sections • 17 lectures • 1h 13m total length

Introduction To Course1:38
An introduction to what you will learn in this course and also a demo of the final project that we are going to create in this course.
What is PDO?1:26
This is a short video on what is PDO. Some major advantages of using PDO is also discussed in this video.
The PDO Process0:54
In this lecture, you will learn how the PDO code is written. We won't write any code in this video, but you will get a basic idea of how you should go about coding the page.
Create A Local Server1:29
In this lecture, learn how to create a local server for your web development. Whenever you start with a project you should start with a local server. After developing the website completely and testing it, you can move it to a web server.
We will be using a tool called XAMPP to create a local server for our PHP development.
Create A Database In MySQL3:12
In this lecture, you will learn how to create a new MySQL database and create a table in it.

Connect To Database6:42
Learn how to connect to a database using PDO. We will just echo "Database Connection Successful" if the database is connected.
Insert Into Database8:18
Learn to insert data into the database we created. We will be making use of the PDO process that we discussed in the Introduction section.
View Data From Database3:50
In this lecture, you will learn how to get data from the database. We will be creating a new method in our DB class and write the code for getting the data there. Then we can call the method by instantiating the class anywhere in our project.
Delete Data From Database4:24
Learn how to delete data from a database in this video.
Count The Number of Rows Affected1:52
There is a method in PDO called rowCount() which returns the result of the number of rows affected by the previous database operation. In this video, I demonstrate how to get the number of rows deleted from a database.
Update Data In Database5:22
In this lecture, I talk about how to update data in a database.
Search In The Database6:00
In this lecture, learn how to search in a database and display the result on the screen. I also have attached the source code for this project in this lecture. Please check it out if you have any problems with your code.

The Final Project (HTML)4:08
This is the final project that we are creating in this course. We are creating a complete CRUD web application with live search. In this video, I have added the time-lapse of me writing the markup for the project.
The Final Project (CSS)3:31
Here is a time-lapse of me writing the CSS for the final project. I have attached the source code to this lecture.
The Final Project (PHP)9:54
In this lecture, we actually write the code for the CRUD operations in the project. We will reuse some of the code from the previous project that we created.
Implement Live Search9:39
In this lecture, I will implement live search on the final project. We will use the new fetch API in ES6 to accomplish this. I have attached the source code to this lecture.
What Next?0:43

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

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

What you'll learn

Explore related topics

Course content

Introduction5 lectures • 9min

PHP Data Objects7 lectures • 36min

The Project5 lectures • 28min

Requirements

Description

Who this course is for: