php-mysqlHow to write an update query in MySQL using PHP?

An update query in MySQL using PHP can be written using the mysqli_query() function. The syntax for this function is as follows:

mysqli_query($connection, "UPDATE table_name SET column1=value1, column2=value2 WHERE some_column=some_value");

This query will update the values of column1 and column2 in the table table_name where some_column is equal to some_value.

The parts of the code are as follows:

$connection: This is the connection to the MySQL database.
UPDATE table_name: This is the name of the table to be updated.
SET column1=value1, column2=value2: This is the list of columns and values to be updated.
WHERE some_column=some_value: This is the condition for which rows should be updated.

Helpful links