Open
Description
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;
}
Metadata
Metadata
Assignees
Labels
No labels