3v4l.org

run code in 150+ php & hhvm versions
Bugs & Features
<?php $array = array("id" => 1, "key1" => "value1", "key2" => "value2"); $sql = "UPDATE mytable set "; $assignments = array(); $where = ""; foreach($array as $key => $value) { if ($key == 'id') { $where = "id = $value"; } $assignments[] = "{$key} = :{$key}"; } $sql .= implode(',', $assignments); if ($where) { $sql .= " where $where"; print $sql; }
Output for 4.3.0 - 7.1.0
UPDATE mytable set id = :id,key1 = :key1,key2 = :key2 where id = 1