3v4l.org

run code in 300+ PHP versions simultaneously
<?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";
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:
138.53 ms | 407 KiB | 5 Q