Gain insights into object-oriented programming in PHP. Discover classes, objects, methods, inheritance, and more. Build dynamic server-side applications using OOP techniques and PHP database management.

php-lamp.tar.gz

php-db

php-db-challenge

php-composer

php-package-install

php-redirect

Object-oriented programming is perhaps the dominant development paradigm for leading languages including Java, C#, and Python. The rich class and inheritance framework wasn’t fully implemented in modern PHP until 2015, and best practices for object-oriented programming are still emerging.

This course is an introduction to object-oriented programming in PHP. You’ll start with the basics of the OOP paradigm and get familiar with classes, objects, methods, and properties. You’ll then chain methods and properties using the this keyword before working with access modifiers and magic methods. With these basics down, you’ll take a deep dive into object-oriented programming in PHP, including inheritance, abstraction, polymorphism, and namespaces. After exploring exception handling, you’ll use these object-oriented techniques to build, manage, and edit a PHP database.

By the end of this course, you’ll be prepared to build dynamic server-side applications using object-oriented programming in PHP.

Object-Oriented Programming in PHP

In this lesson, we’ll learn about the different phases of deleting records from the database. We’ll see how we can prepare queries, bind parameters, define bound values, and execute queries.


# Step 1: Write and prepare the query 

Write the delete statement:
```
$sql = "DELETE FROM `users` WHERE `id`=:id";
```
Prepare the query:
```
$query = $dbh->prepare($sql);
```
Bind the parameters:
```
$query -> bindParam(':id', $id, PDO::PARAM_INT);
```
Define the bound value:
```
$id = 1;
```
# Step 2: Execute the query

```
$query -> execute();
```
# Step 3: Verify the results

Check that the query has been performed and that the records have been successfully deleted from the database:
```
if($query -> rowCount() > 0) {
   $count = $query -> rowCount();
   echo $count . " rows were affected."; 
}
else {
   echo "No affected rows.";
}
```

The current status of the `users` table is given below:



Learn how to delete records from the database using PHP PDO.

Introduction

Classes and Objects

Using the $this Keyword for Chaining Methods and Properties

Access Modifiers

Magic Methods and Constants Unveiled

Inheritance in Object-oriented Programming

Abstract Classes and Interfaces

Polymorphism and Type Hinting

Static Methods & Properties and Traits

Namespaces & Dependency Injection

Exception Handling

PHP Database

Model-view-controller (MVC)

Conclusion

Appendix

Deleting Records from the Database

Step 1: Write and prepare the query