Online PHP editor | refs for 94P9g

<?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"; }