update() public method
Creates an UPDATE SQL statement.
For example,
$params = []; $sql = $queryBuilder->update('user', ['status' => 1], 'age > 30', $params);
The method will properly escape the table and column names.
public string update ( $table, $columns, $condition, &$params ) | ||
---|---|---|
$table | string |
The table 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\db\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 DB command later. |
return | string |
The UPDATE SQL |
Please login to continue.