9951 explained code solutions for 126 technologies


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

Edit this code on GitHub