How to update data in database using PHP functions?

You can use PHP functions to update data in the database: 1. Establish a database connection; 2. Prepare a SQL query; 3. Execute the SQL query; 4. Check the number of affected rows; 5. Close the database connection.

How to use functions in PHP to update data in the database

Using PHP to update data in the database is a common Tasks that help you maintain data stored in your application. Here's how to use PHP functions to achieve this:

1. Establish a database connection

First, you need to establish a connection to the database. You can use the mysqli_connect() or PDO function to achieve this.

2. Prepare SQL query

Next step, prepare a SQL query to update the data in the database. This query should be similar to the following format:

UPDATE table_name SET column_name = 'new_value' WHERE condition;

For example, to update a column named name in a table named users, change its value to John Doe, you can write the following query:

$query = "UPDATE users SET name = 'John Doe' WHERE id = 1;";

3. Execute SQL query

Use mysqli_query() or The execute() method in PDO executes a SQL query. This will send a query to the database and update the data.

4. Check the number of affected rows

After executing the query, you can check mysqli_affected_rows() or rowCount() to get the number of affected rows. This can help you verify that the data was updated successfully.

5. Close the database connection

Finally, after completing the update, please close the database connection to release resources. You can achieve this using the mysqli_close() or PDO::close() function.

Practical case

The following is a practical case showing how to use PHP functions to update data in the MySQL database:

Running this script will update Change the name column of the row in the users table where id is 1 to John Doe.

The above is the detailed content of How to update data in database using PHP functions?. For more information, please follow other related articles on the PHP Chinese website!