Yii deleteByAttributs usage, use Dao's delete_PHP tutorial with caution-PHP Tutorial-php.cn

Yii deleteByAttributs usage, use Dao's delete_PHP tutorial with caution

WBOY

Release： 2016-07-13 10:43:19

Original

1000 people have browsed it

This article will introduce to you the usage of Yii deleteByAttributs. Use Dao's delete with caution. I hope this article will be helpful to everyone.

Yii framework must use Dao's delete with caution. If it accidentally fails to generate the conditions, it will become a complete table deletion.

You can use ActiveRecord’s deleteByAttributes or deleteAll methods which are relatively easy to write incorrectly.

The usage of deleteByAttributes is as follows:

The code is as follows

代码如下	复制代码
MyClass::model()->deleteAllByAttributes(array( 'phone_number'=>$phoneNumber, ));

Copy code

代码如下	复制代码
MyClass::model()->deleteAllByAttributes(array(),'`phone_number` = :phone_number',array( ':phone_number'=>$phoneNumber, ));

MyClass::model()->deleteAllByAttributes(array(
'phone_number'=>$phoneNumber,
));

代码如下	复制代码
MyClass::model()->deleteAll('`phone_number` = :phone_number',array( ':phone_number'=>$phoneNumber, ));

or if the first parameter is empty, use the second conditional parameter

代码如下

复制代码

$condition = new CDbCriteria();
$condition->addCondition('status=:status');
$condition->params = array(':status'=>1);
$condition->addInCondition('user_id',array(100111,100221,100221));
User::model()->deleteAll($condition);Dao带in条件的示例

Yii::app()->db->createCommand()
->delete('mw_user', array('and', 'user_id=:user_id', array('in', 'position_id', array(1,2,3))),array(':user_id'=>121111));

MyClass::model()->deleteAllByAttributes(array(),'`phone_number` = :phone_number',array(
':phone_number'=>$phoneNumber,
));

The code is as follows	Copy code