Delete Mysql record using array

Question

I am trying to delete multiple record(s) by using codeigniter

$this->db->delete() and $this->db->where()

I want to delete record(s) with an array like

$id =array(
  0=>'13',   //13 is the id
  1=>'4',    //4 is the id
  2=>'2'     //2 is the id
);

The array was generated by the users so it will be dynamic. I just want to know if codeigniter can take the array as a option in delete method.

According to this. http://codeigniter.com/user_guide/database/active_record.html

array won't work in the following method.

$this->db->delete()
$this->db->where('id', $id); //I don't think I can do this.

I could use foreach to loop but it seems to me there are better ways. I was wondering if anyone could help me about it. Thanks a lot.

RumpRanger · Accepted Answer · 2012-03-07 20:45:13Z

3

Not really familiar with codeigniters active record but I believe the stmt you would like is:

$sql = "DELETE FROM tbl WHERE id IN (".implode(',',$idsToDelete.");";
$this->db->query($sql);

This might work better with active record:

$this->db->where('IN ('.implode(',',$idsToDelete).')', NULL, FALSE);
$this->db->delete();

edited Mar 7, 2012 at 20:45

answered Mar 7, 2012 at 20:33

RumpRanger

6544 silver badges9 bronze badges

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

1 Comment

Jannis M Over a year ago

You can chain your actions: $this->db->where('IN ('.implode(',',$idsToDelete).')', NULL, FALSE)->delete()

Toto · Accepted Answer · 2012-03-08 13:26:02Z

1

The method where really accept an array as parameter?

I think your source code should look:

$this->db->delete()
$this->db->where($id['i_index']);

edited Mar 8, 2012 at 13:26

Toto

91.7k63 gold badges97 silver badges135 bronze badges

answered Mar 7, 2012 at 20:15

Petris Rodrigo Fernandes

731 silver badge7 bronze badges

Comments

Weekend32 · Accepted Answer · 2018-09-03 15:07:55Z

0

This post is dated, but I figured still deserves the best/right answer:

    $this->where_in('id', array(13, 4, 2))->delete('db_table_name');

answered Sep 3, 2018 at 15:07

Weekend32

611 silver badge3 bronze badges

Collectives™ on Stack Overflow

Delete Mysql record using array

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related