Online PHP editor | refs for p35cT

<?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";