Mysqli: Update

<?php

$sql = 'update my_table 
    set field1 = "' . $mysqli->real_escape_string($value1) . '", 
        field2 = "' . $mysqli->real_escape_string($value2) . '"
    where id = "' . $mysqli->real_escape_string($id) . '"';

$mysqli->query($sql) or die($mysqli->error);

?>

 

Related Snippets

•	Mysqli: Update from array
•	Mysqli: Select
•	Mysqli: Insert from array
•	Mysqli: Insert
•	Mysqli: Connect