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\pgsql\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.