Delete multiple rows in YII2

Question

I have an array of objects fetched from database:

$masterListContacts = MasterListContacts::find()
                ->select('master_list_contacts.*')
                ->innerJoin('master_contacts', '`master_contacts`.`id` = `master_list_contacts`.`master_contact_id`')
                ->with('masterContact')
                ->where(['user_id' => \Yii::$app->user->identity->id, 'slug' => $slug])
                ->all();

Under certain circumstances, I need to delete all rows from the database represented in this array. But with both delete() and deleteAll() methods I got an error Call to a member function ... on array. Could someone tell me please which one is the best way to accomplish this?

UPDATE: Here is my database structure.

Avag Sargsyan · Accepted Answer · 2015-11-25 15:31:01Z

13

Found better solution:

\Yii::$app
    ->db
    ->createCommand()
    ->delete('master_contacts', ['id' => $deletableMasterContacts])
    ->execute();

Where $deletableMasterContacts is array of master_contacts ids, which should be deleted

edited Nov 25, 2015 at 15:31

answered Nov 25, 2015 at 15:24

Avag Sargsyan

2,5194 gold badges33 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Harry B Over a year ago

Probably better to use the function specified for this. deleteAll()

Onedev_Link · Accepted Answer · 2015-11-24 16:54:27Z

11

You can painlessly remove ->select('master_list_contacts.*').

->innerJoin('master_contacts', '`master_contacts`.`id` = `master_list_contacts`.`master_contact_id`')

performs the same work that ->joinWith('masterContact').

For delete entites try use this code:

MasterListContacts::deleteAll(['user_id' => \Yii::$app->user->identity->id, 'slug' => $slug]);

answered Nov 24, 2015 at 16:54

Onedev_Link

2,01215 silver badges27 bronze badges

2 Comments

Avag Sargsyan Over a year ago

Thank you for your answer @Onedev.Link, but it throws an error: Unknown column 'user_id' in 'where clause' since I need to join table 'master_contacts' to do this......and just wondering does yii provide a way to do foreach($masterListContacts as $record) $record->delete(); but querying database once.

Onedev_Link Over a year ago

Yeah. You can use foreach($masterListContacts as $record) $record->delete(); code. Unknown column 'user_id' in 'where clause' say that table MasterListContacts::tableName() does't have user_id field. What is your database structure? If you want delete records only with relation record in master_contacts you should use leftJoin.

Collectives™ on Stack Overflow

Delete multiple rows in YII2

2 Answers 2

1 Comment

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related