Skip to content

insert into values (),(),(),()... #729

Open
@getchu

Description

@getchu
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

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions