<?php
$fields = "email,first,last,business,home,cell,street,city,state,zip,system,cameras,hdd";
$sql_header = '';
$sql_values = '';
$glue = '';
array_walk(
explode(',', $fields),
function ($field) use (& $sql_header, & $sql_values, & $glue) {
$sql_header .= $glue . '`' . $field . '`';
$sql_values .= $glue . "'" . $field . "'";
$glue = ',';
}
);
echo ("INSERT INTO `customers`($sql_header) VALUES ($sql_values)");
preferences:
40.99 ms | 402 KiB | 5 Q