yii\sphinx\QueryBuilder::batchInsert PHP Method

batchInsert() public method

For example, php $sql = $queryBuilder->batchInsert('idx_user', ['id', 'name', 'age'], [ [1, 'Tom', 30], [2, 'Jane', 20], [3, 'Linda', 25], ], $params); Note that the values in each row must match the corresponding column names.
public batchInsert ( string $index, array $columns, array $rows, array &$params ) : string
$index string the index that new rows will be inserted into.
$columns array the column names
$rows array the rows to be batch inserted into the index
$params array the binding parameters that will be generated by this method. They should be bound to the Sphinx command later.
return string the batch INSERT SQL statement
    public function batchInsert($index, $columns, $rows, &$params)
    {
        return $this->generateBatchInsertReplace('INSERT', $index, $columns, $rows, $params);
    }