Edit
In Place Editing Advanced Editing

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
doc_Yii
2025-01-10 15:47:30
Comments
Leave a Comment

Please login to continue.