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 |
Please login to continue.