3v4l.org

run code in 300+ PHP versions simultaneously
<?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"; }
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:
130.64 ms | 408 KiB | 5 Q