<?php
"id" => 1,
"fname" => "john",
"lname" => "doe",
"dob" => "10/12/2012"
);
$table = "foo";
$set = "";
// todo sanitise with mysql_escape_string()
foreach($arr as $key => $v) {
$set .= sprintf("%s=%s%s", $key, $val, ($v == end($arr) ?
"" : ", ")); }
$sql = sprintf("UPDATE %s SET %s", $table, $set);
echo($sql);
?>
PD9waHAKIAokYXJyID0gYXJyYXkoCiAgICAiaWQiID0+IDEsCiAgICAiZm5hbWUiID0+ICJqb2huIiwKICAgICJsbmFtZSIgPT4gImRvZSIsCiAgICAiZG9iIiA9PiAiMTAvMTIvMjAxMiIKKTsKIAokdGFibGUgPSAiZm9vIjsKIAokc2V0ID0gIiI7CgovLyB0b2RvIHNhbml0aXNlIHdpdGggbXlzcWxfZXNjYXBlX3N0cmluZygpCmZvcmVhY2goJGFyciBhcyAka2V5ID0+ICR2KSB7CiAgICAkdmFsID0gaXNfbnVtZXJpYygkdikgPyAkdiA6ICInIiAuICR2IC4gIiciOwoKICAgICRzZXQgLj0gc3ByaW50ZigiJXM9JXMlcyIsICRrZXksICR2YWwsICgkdiA9PSBlbmQoJGFycikgPyAiIiA6ICIsICIpKTsKfQogCiRzcWwgPSBzcHJpbnRmKCJVUERBVEUgJXMgU0VUICVzIiwgJHRhYmxlLCAkc2V0KTsKIAplY2hvKCRzcWwpOwogCj8+