Home Courses Instructor Labs

Perform CRUD on MySQL Database Using PDO in PHP

(34 Ratings) 2949 Students Enrolled
Created By Sam Johnson Last Updated Sat, 07-Mar-2020 English
  • Course Duration
    1 Hours
  • Mode of Training
    Self-Paced
  • Lessons
    17 Lessons
  • Validity
    Life Time
Free
12k+ satisfied learners Read Reviews
What Will I Learn?
  • Learn CRUD (Create, Read, Update and Delete operations) in MySQL database using PDO
  • Learn PDO (PHP Data Object)
  • Project - Implement Live Search

Requirements
  • Basic Knowledge of HTML and CSS
  • Basic knowledge of PHP
+ View More
Description

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

We will be using an Object-oriented concepts to write the PHP code. With all the aquired knowledge, you will be finally creating a CRUD webpages.

After completing this course, you will be able to perform INSERT, UPDATE, DELETE and SELECT operations on your databases which will help you to create backend applications.

Curriculum For This Course
17 Lessons 1 Hours
  • Introduction to Course 00:01:39 Preview
  • What is PDO? 00:01:27
  • The PDO process 00:00:54
  • Create a local server 00:01:30
  • Create a Database in MysQL 00:03:13
  • Connect to Database 00:06:43 Preview
  • Insert into the Database 00:08:19
  • View Data from Database 00:03:50
  • Delete Data from Database 00:04:25
  • Count the number of rows affected 00:01:52
  • Update Data in Database 00:05:23 Preview
  • Search Data in Database 00:06:01
  • The final project(HTML) 00:04:09
  • The final project(CSS) 00:03:32
  • The final project(PHP) 00:09:54
  • Implement Live search 00:09:39
  • What Next? 00:00:23

Perform CRUD on MySQL Database Using PDO in PHP