php拼装sql
2020-09-07 本文已影响0人
dongdog
private static function getInsertSql($table, $log)
{
$keys = "";
$values = "";
foreach ($log as $key => $value) {
if ($key == 'ps3') {
$keys .= "`{$key}`";
$values .= "'{$value}'";
} else {
$keys .= "`{$key}`,";
$values .= "'{$value}',";
}
}
$keys .= ") VALUES (";
$values .= ");";
return "INSERT INTO `{$table}` (" . $keys . $values;
}