sphinx\QueryBuilder update()

update() public method

Creates an UPDATE SQL statement.

For example,

$params = [];
$sql = $queryBuilder->update('idx_user', ['status' => 1], 'age > 30', $params);

The method will properly escape the index and column names.

public string update ( $index, $columns, $condition, &$params, $options )
$index string

The index to be updated.

$columns array

The column data (name => value) to be updated.

$condition array|string

The condition that will be put in the WHERE part. Please refer to yii\sphinx\Query::where() on how to specify condition.

$params array

The binding parameters that will be modified by this method so that they can be bound to the Sphinx command later.

$options array

List of options in format: optionName => optionValue

return string

The UPDATE SQL

doc_Yii
2016-10-30 17:12:36
Comments
Leave a Comment

Please login to continue.