db\BaseActiveRecord updateAll()

updateAll() public static method

Updates the whole table using the provided attribute values and conditions.

For example, to change the status to be 1 for all customers whose status is 2:

Customer::updateAll(['status' => 1], 'status = 2');
public static integer updateAll ( $attributes, $condition = '' )
$attributes array

Attribute values (name-value pairs) to be saved into the table

$condition string|array

The conditions that will be put in the WHERE part of the UPDATE SQL. Please refer to yii\db\Query::where() on how to specify this parameter.

return integer

The number of rows updated

throws yii\base\NotSupportedException

if not overridden

doc_Yii
2016-10-30 16:56:57
Comments
Leave a Comment

Please login to continue.