Mysqli: Update from array

<?php

$data = array(
    'field1' => $value1,
    'field2' => $value2,
);

$sql_values = '';
$sep = '';
foreach ($data as $key => $val) {
    $sql_values .= $sep . '`' . $key . '` = "' . $mysqli->real_escape_string($val) . '"';
    $sep = ',';
}

$sql = 'update my_table set ' . $sql_values . 
    ' where field_id = ' . $mysqli->real_escape_string($value_id);

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

?>

 

Related Snippets

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