There may be a requirement where the existing data in a MySQL table needs to be modified. You can do so by using the SQL UPDATE command. This will modify any field value of any MySQL table.
The following code block has a generic SQL syntax of the UPDATE command to modify the data in the MySQL table −
UPDATE table_name SET field1 = new-value1, field2 = new-value2 [WHERE Clause]
The WHERE clause is very useful when you want to update the selected rows in a table.
You can use the SQL UPDATE command with or without the WHERE CLAUSE into the PHP function – mysqli_query(). This function will execute the SQL command in a similar way it is executed at the mysql> prompt.
The following example to update the tutorial_title field for a record having tutorial_id as 3.
<?php $dbhost = 'remotemysql.com:3036'; $dbuser = 'your_username; $dbpass = 'your_password'; $conn = mysqli_connect($dbhost, $dbuser, $dbpass); if(! $conn ) { die('Could not connect: ' . mysqli_error()); } $sql = 'UPDATE tutorials_tbl SET tutorial_title="Learning JAVA" WHERE tutorial_id=3'; mysqli_select_db('TUTORIALS'); $retval = mysqli_query( $sql, $conn ); if(! $retval ) { die('Could not update data: ' . mysqli_error()); } echo "Updated data successfully\n"; mysqli_close($conn); ?>