Multiple Row Deletions

[ch_ranjita]

How to delete multiple rows from DB, by selecting checkboxes from the list and click on delete button.

Also if no checkbox is selected, then it should fire an error like "Select atleast one checkbox.

[bpat1434]

Well, I'd create a group of checkboxes. Make the name of the checkbox "remove[{$id}]", give it a value of $id, and that's it for the form. So for example...

PHP Code:

$result = $stmt->fetchAll();

foreach($result as $row)
{
    $this->addEelemnt('checkbox', 'remove['.$row['id'].']', array(
        'value' => $row['id'],
        'label' => $row['title'],
    );
} 


Now, once they submit the form, all you have to do is look at $_POST['remove'] and you have all the IDs they want to delete. From there you can either run multiple delete() calls on the database, or do something like:

PHP Code:

$db->delete('table', 'id IN(' . implode(',', $_POST['remove']) . ')'); 


Hope that helps.

[sergey]

This code have the SQL-injection:

PHP Code:

$db->delete('table', 'id IN(' . implode(',', $_POST['remove']) . ')'); 


Better use quote() method:

PHP Code:

$db->delete('table', 'id IN(' . $db->quote($_POST['remove']) . ')'); 


[bpat1434]

It was just demo code, I would expect the OP to be able to realize that of course there should be some sanitation going on prior to that.