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 MySQ

4.80 (61 reviews)
Udemy
platform
English
language
Web Development
category
instructor
Learn PDO By Creating A CRUD Website (PHP & MySQL)
3,552
students
1 hour
content
Apr 2019
last update
$54.99
regular price

What you will learn

CRUD (Create, Read, Update, Delete) Operations on Database

PDO (PHP Data Objects)

Implement Live Search using JavaScript

Why take this course?

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.

Content

Introduction

Introduction To Course
What is PDO?
The PDO Process
Create A Local Server
Create A Database In MySQL

PHP Data Objects

Connect To Database
Insert Into Database
View Data From Database
Delete Data From Database
Count The Number of Rows Affected
Update Data In Database
Search In The Database

The Project

The Final Project (HTML)
The Final Project (CSS)
The Final Project (PHP)
Implement Live Search
What Next?

Our review

--- **Overall Course Rating:** 4.80/5.0 **Course Review Synthesis** **Pros:** - **Engaging Content:** Many students found the course delivery to be excellent, with a right amount of explanation that keeps the learning process engaging without being overly verbose. (Cheryl) - **Bridging the Gap:** The course is particularly beneficial for those who have completed beginner courses and are looking to dive into practical PHP programming projects. It serves as a good bridge for understanding and applying CRUD operations with PDO. (Student feedback) - **Practical Examples:** The examples provided in the course are practical and can be adapted to real-world projects, which is highly appreciated by learners. (Student feedback) - **Efficient Presentation:** The presentation style is clear, concise, and to the point, with no wandering off-topic. This makes the learning process efficient and focused. (PdeP) - **Strong Foundation:** For newcomers to PDO, this course offers a strong fundamental understanding of CRUD operations, which is essential for further learning and development. (Student feedback) - **High-Quality Explanations:** The explanations are well-paced and comprehensive, with no unnecessary detours. (PdeP) **Cons:** - **Lack of Code Explanation:** Some students felt that the instructor typed the code without sufficient explanation, which can make it difficult to understand and learn the underlying concepts. This approach might be challenging for those who are new to programming or require more guided learning. (First review) - **Practicality of Code Practices:** The coding preferences demonstrated in the course may not align with common practices found elsewhere, potentially leading to confusion among learners. (First review) - **Code Organization:** The method of storing queries on separate pages is called into question for its practicality, as it may not reflect how queries are handled in typical CRUD applications. (First review) - **Missing Resources:** There were reports of missing resources, such as the SQL database file, which are essential for following along with the course's tutorials. (Two separate student feedback entries) - **Security Oversight:** A significant concern raised was the lack of input sanitization and database safeguarding, which is a serious oversight in a course teaching practical PHP programming. (PdeP) - **Language Barrier:** Some learners experienced difficulties due to language barriers, such as not understanding why a live search feature wasn't working, potentially indicating an issue with non-native English content or a JSON-related problem. (Last tutorial feedback) **Course Recommendation:** This course is recommended for intermediate PHP developers who have completed beginner courses and are looking to strengthen their CRUD operations with PDO. It is also beneficial for those who seek a concise, clear, and well-paced course. However, it is advised that learners be aware of the potential issues with code explanations and organization, and that they ensure all resources are downloaded before starting the course to avoid any disruptions in learning. Additionally, more experienced developers or those who prioritize comprehensive coverage of security best practices should look for alternative courses that cover these aspects in detail.

Charts

Price

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

Rating

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

Enrollment distribution

Learn PDO By Creating A CRUD Website (PHP & MySQL) - Distribution chart
2301426
udemy ID
4/1/2019
course created date
4/27/2019
course indexed date
Bot
course submited by