PHP-MySQLi-Database-Class
PHP-MySQLi-Database-Class copied to clipboard
insert into values (),(),(),()...
public function buildSql($tableName , $sqlStack){
$keys = \array_keys($sqlStack[0]);
$keysStr = array();
foreach($keys as $key){
$keysStr[] = '`'.$key.'`';
}
$keysStr = \implode(',', $keysStr);
$sql = 'INSERT INTO '.$tableName. '('.$keysStr. ') VALUES ';
//data
$values = array();
foreach($sqlStack as $insertData){
$fields = array();
foreach($insertData as $key=>$value){
$fields[] = is_string($value) ? '\''.$this->escape($value).'\'' : (is_null($value) ? '' : $value);
}
$fields = \implode(',', $fields);
$values[] = '('.$fields.')';
}
$values = \implode(',', $values);
$sql = $sql .$values . ';';
return $sql;
}
solved null insert instead of empty: https://github.com/ThingEngineer/PHP-MySQLi-Database-Class/pull/954