db\QueryBuilder update()

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

doc_Yii
2016-10-30 16:59:23
Comments
Leave a Comment

Please login to continue.