yii\sphinx\Command::update PHP Method

Command Class Documentation Show file Open project: yiisoft/yii2-sphinx

update() public method

For example, php $connection->createCommand()->update('user', ['status' => 1], 'age > 30')->execute(); The method will properly escape the column names and bind the values to be updated. Note that the created command is not executed until [[execute()]] is called.

public update ( string $index, array $columns, string \| array $condition = '', array $params = [], array $options = [] )
$index	string	the index to be updated.
$columns	array	the column data (name => value) to be updated.
$condition	string \| array	the condition that will be put in the WHERE part. Please refer to [[Query::where()]] on how to specify condition.
$params	array	the parameters to be bound to the command
$options	array	list of options in format: optionName => optionValue

    public function update($index, $columns, $condition = '', $params = [], $options = [])
    {
        $sql = $this->db->getQueryBuilder()->update($index, $columns, $condition, $params, $options);
        return $this->setSql($sql)->bindValues($params);
    }

Command

addColumn

addForeignKey

addPrimaryKey

alterColumn

batchInsert

batchReplace

bindValue

bindValues

callKeywords

callSnippets

checkIntegrity