How to make a nonstandard delete request in yii2

Question

There is a SQL query

DELETE FROM tbl_um_keys WHERE user_id = 6 AND module_id IN (20, 21, 31);

How this request can be implemented using Yii2

Lesha Marchenkovsky Lesha Marchenkovsky 462 2 eight · Accepted Answer · 2017-02-22T12:55:13

Using ActiveRecord

 YourModel::deleteAll(['user_id' => 6, 'module_id' => [20, 21, 31]]);

Or by means of Connection

 \Yii::$app->db->createCommand() ->delete('tbl_um_keys', ['user_id' => 6, 'module_id' => [20, 21, 31]]) ->execute()

Al Mr Al Mr 1.279 2 6 nineteen · Answer 2 · 2017-02-22T12:21:23

Something like that

  $records=tbl_um_keys::find()->where(['user_id'=>6])->andWhere(['in','module_id',[20,21,31]])->all(); $records->delete();

2 answers 2