PHP MySQL Update Query

Introduction

Updating data in a database is a fundamental operation in web development, and PHP provides a convenient and powerful way to perform such updates using the "update" query. The "update" query allows developers to modify existing records in a database table, making it essential for applications that require data manipulation or maintenance.

In PHP, the "update" query is typically used in conjunction with SQL (Structured Query Language) to interact with a database system. It enables developers to change the values of specific fields within a table based on specified conditions. This flexibility allows for targeted updates, ensuring that only the desired records are modified while preserving the integrity of the database.

The "update" query follows a specific syntax, which includes specifying the table to update, the fields to modify, and the conditions that determine which records should be updated. By providing the necessary parameters and values, developers can dynamically update data in real-time, responding to user input or application logic.

One of the key advantages of using the "update" query in PHP is its ability to handle complex operations efficiently. Whether it's updating a single record or performing bulk updates, PHP's support for SQL statements makes the process straightforward and ensures optimal performance.

Syntax

The syntax of updating query in PHP is as follows:

Explanation
In the above code, you need to replace the following placeholders with your actual database credentials and query details:

• $servername:
  Your database server name or IP address.
• $username:
  Your database username.
• $password:
  Your database password.
• $dbname:
  Your database name.
• table_name:
  The name of the table you want to update.
• column1, column2:
  The columns in the table you want to update.
• new_value1, new_value2:
  The new values you want to set for the respective columns.
• condition:
  The condition that specifies which rows to update. For example, id = 1 to update a row with the ID of 1.

Run the above code in your editor for a better and clear explanation.

Where Update Query

The update query in PHP is used to modify existing records in a database table. It is typically performed using SQL statements. Here is an example of how to execute an update query in PHP:

Explanation
In the above code, you need to replace the following placeholders with your actual database credentials and query details:

• $servername:
  Your database server name or IP address.
• $username:
  Your database username.
• $password:
  Your database password.
• $dbname:
  Your database name.
• table_name:
  The name of the table you want to update.
• column1, column2:
  The columns in the table you want to update.
• new_value1, new_value2:
  The new values you want to set for the respective columns.
• condition:
  The condition that specifies which rows to update. For example, id = 1 to update a row with the ID of 1.

Run the above code in your editor for a better and clear explanation.

Examples

1. Update Query using MySQLi Procedural

Let us see the code below of how to Update Query using MySQLi Procedural :

Explanation
The above demonstrates the process of updating records in a MySQL database using PHP. It begins by establishing a connection to the MySQL database server. The server name, username, password, and database name are provided as variables ($servername, $username, $password, and $dbname, respectively). The mysqli_connect() function is used to create the connection, and if the connection fails, an error message is displayed using the mysqli_connect_error() function. Run the above code in your editor for a better and clear explanation.

2. Update Query using Object Oriented Method

Let us see the code below of how to Update Query using Object Oriented Method.

Explanation
The code establishes a MySQLi object-oriented connection to a database, executes an SQL update query to modify records in a table based on a condition, and displays a success or error message before closing the connection. Run the above code in your editor for a better and clear explanation.

Update Query using PDO

Let us see the code below of how to Update Query using PDO.

Explanation
In the above code, we are updating a record in a MySQL database. It begins by establishing a connection to the database using the PDO object. Then, an SQL statement is defined to update specific columns in the "users" table based on the provided ID. The statement is prepared, and the desired values are bound to named parameters using the bindParam() method. The execute() method is called to execute the prepared statement and make the necessary updates in the database. The rowCount() method is used to determine the number of affected rows, indicating the success of the update. Based on the result, an appropriate message is displayed to the user, indicating whether the update was successful or not. Run the above code in your editor for a better and clear explanation.