反转mysql_fetch_assoc（mysql_set_assoc / mysql_encode_assoc）

Question

Is there function encoding an associative array to use in a mySQL INSERT command?

This way you could do:

$array = mysql_fetch_assoc($result);
$array['key'] = 'updated_value';
mysql_query('INSERT INTO table ' . mysql_encode_assoc($array));

mysql_encode_assoc input:

array(
    'name' => 'bob',
    'vehicle' => 'car'
)

mysql_encode_assoc output:

'(name, vehicle) VALUES(bob, car)'

Answer 1

There is now:

function mysql_encode_assoc($array) {
    $kenc = Array();
    $venc = Array();
    foreach($array as $k=>$v) {
        $kenc[] = "`".mysql_real_escape_string($k)."`";
        if( $v === null) $venc[] = "NULL";
        else $venc[] = '"'.mysql_real_escape_string($v).'"';
    }
    $keys = "(".implode(",",$kenc).")";
    $vals = "(".implode(",",$venc).")";
    return $keys." VALUES ".$vals;
}