<?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; }
You have javascript disabled. You will not be able to edit any code.