delete several row mysql database together?

Question

I want to delete "several row mysql database" together after select with checkbox in "codeigniter", but my function not work:(my problem is in "function delete()"). What is it?

function delete(){
    $delete = $this->input->post('delete'); // this is array => "delete[]" . value this is "id" it row in database.
    for($i=0;$i<count($delete);$i++) {
        $this->db->delete('My_Table', array('id' => $delete[$i])); 
    }
    }

What do you get if you print_r($delete); before the for loop? Does it contain what you think it should? — DaveRandom
– DaveRandom, Commented Aug 21, 2011 at 14:43

Aaron W. · Accepted Answer · 2011-08-21 14:47:18Z

1

Once you have an array of ID's in your $delete variable, you can do the following:

if(is_array($delete) && count($delete) > 0)
{
    $this->db->query("DELETE FROM `My_Table` WHERE `id` IN (" . implode(", ", $delete) . ")");
}

answered Aug 21, 2011 at 14:47

Aaron W.

9,2952 gold badges36 silver badges47 bronze badges

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

Collectives™ on Stack Overflow

delete several row mysql database together?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related