@ 2018-05-07T15:34:14Z <?php
$updates = [
[
"service" => "k",
"price" => "85.0",
"id" => "442"
],
[
"service" => "τεσ",
"price" => "66.0",
"price_show" => "0",
"id" => "463"
]
];
$allowed = array_flip([
'service',
'price',
'price_show',
'id'
]);
foreach ($updates as $update) {
$update = array_intersect_key($update, $allowed);
$id = array_pop($update);
$set = [];
foreach ($update as $field => $value) {
$set[] = "`{$field}`=:{$value}";
}
$update = "UPDATE some_table SET " . implode(', ', $set). " WHERE serviceID=".$id;
echo $update, "\n";
}
Enable javascript to submit You have javascript disabled. You will not be able to edit any code.
Output for 7.1.0 - 7.1.20 , 7.2.0 - 7.2.33 , 7.3.16 - 7.3.33 , 7.4.0 - 7.4.33 , 8.0.0 - 8.0.30 , 8.1.0 - 8.1.33 , 8.2.0 - 8.2.29 , 8.3.0 - 8.3.26 , 8.4.1 - 8.4.13 UPDATE some_table SET `service`=:k, `price`=:85.0 WHERE serviceID=442
UPDATE some_table SET `service`=:τεσ, `price`=:66.0, `price_show`=:0 WHERE serviceID=463
preferences:dark mode live preview ace vim emacs key bindings
130.64 ms | 408 KiB | 5 Q