@ 2020-03-30T02:45:57Z <?php
$arr = array(
'a' => 'va',
'b' => 'vb',
'c' => 'vc',
);
$sql = "INSERT INTO Post(" .
implode(', ', array_keys($arr)) .
") VALUES ('" .
implode("', '", $arr) .
"');";
echo "$sql\n";
$sql = "INSERT INTO Post(";
$columns = $values = '';
foreach ($arr as $column => $value) {
$columns .= "$column, ";
$values .= $value ? "'$value', " : "NULL, ";
}
$sql .= trim($columns, ', ') . ") VALUES (" . trim($values, ', ') . ");";
echo "$sql\n";
$cols = count($arr);
$keys = array_keys($arr);
$sql = "INSERT INTO Post(";
$columns = $values = '';
for ($c = 0; $c < $cols; $c++) {
$key = $keys[$c];
$columns .= $key;
$values .= $arr[$key] ? "'{$arr[$key]}'" : "NULL";
if ($c < $cols - 1) {
$columns .= ', ';
$values .= ', ';
}
}
$sql .= "$columns) VALUES ($values);";
echo "$sql\n";
Enable javascript to submit You have javascript disabled. You will not be able to edit any code.
Output for 7.2.0 - 7.2.33 , 7.3.0 - 7.3.33 , 7.4.0 - 7.4.33 , 8.0.0 - 8.0.30 , 8.1.0 - 8.1.33 , 8.2.0 - 8.2.29 , 8.3.0 - 8.3.26 , 8.4.1 - 8.4.13 INSERT INTO Post(a, b, c) VALUES ('va', 'vb', 'vc');
INSERT INTO Post(a, b, c) VALUES ('va', 'vb', 'vc');
INSERT INTO Post(a, b, c) VALUES ('va', 'vb', 'vc');
preferences:dark mode live preview ace vim emacs key bindings
138.53 ms | 407 KiB | 5 Q