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 updating data in the database.  We’ll look at how to prepare queries, bind parameters, define bound values, and execute a query.


# Step 1: Write and prepare a query

Write a regular update statement and instead of values, assign the named placeholders. For example:

```
$sql = "UPDATE `users`
SET `city`= :city, `phone` = :tel
WHERE `id` = :id";

```

Prepare the query:

```
$query = $dbh->prepare($sql);
```

# Step 2: Bind parameters and execute the query

Bind the parameters:

```
$query -> bindParam(':city', $city, PDO::PARAM_STR);
$query -> bindParam(':tel' , $tel , PDO::PARAM_INT);
$query -> bindParam(':id' , $id , PDO::PARAM_INT);
```

Define the bound value:

```
$tel = '06901234567'; 
$city = 'Paris';
$id =1;
```

Execute the query:

```
$query -> execute();
```

# Step 3: Verify the results

Check that the query has been performed and that the database has been successfully updated:

```
if($query -> rowCount() > 0) {
   $count = $query -> rowCount();
   echo $count . " rows were affected."; 
}
else {
   echo "No affected rows.";
}
```

Let’s do all the steps together now.

> **Note:** The `$dbh` variable contains the database connection, which has been already initialized for the code below. The hidden code is given below:

# Step 1: Write and prepare a query

Write a regular update statement and instead of values, assign the named placeholders. For example:

```
$sql = "UPDATE `users`
SET `city`= :city, `phone` = :tel
WHERE `id` = :id";

```

Prepare the query:

```
$query = $dbh->prepare($sql);
```

# Step 2: Bind parameters and execute the query

Bind the parameters:

```
$query -> bindParam(':city', $city, PDO::PARAM_STR);
$query -> bindParam(':tel' , $tel , PDO::PARAM_INT);
$query -> bindParam(':id' , $id , PDO::PARAM_INT);
```

Define the bound value:

```
$tel = '06901234567'; 
$city = 'Paris';
$id =1;
```

Execute the query:

```
$query -> execute();
```

# Step 3: Verify the results

Check that the query has been performed and that the database has been successfully updated:

```
if($query -> rowCount() > 0) {
   $count = $query -> rowCount();
   echo $count . " rows were affected."; 
}
else {
   echo "No affected rows.";
}
```

Let’s do all the steps together now.

> **Note:** The `＄dbh` variable contains the database connection, which has been already initialized for the code below. The hidden code is given below:

Learn about updating data in 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

Updating Data in the Database

Step 1: Write and prepare a query