Delete Selected...?

Ravenous

I've got a script that displays the contents of a database along with checkboxes for each item. If the user checks the box and then clicks "Delete Checked," I want those items to be deleted from the table. With the uncertainty involved with such an action, how can I go about deleting only those checked items and without running through one hundred unnecessary checks?

The checkboxes receive a name that is the same as that row's unique id number. They're being passed via POST. (If GET is better, let me know.)

If I'm not being clear enough, let me know. 🙂 Thanks.

scoppc

You can name each checkbox as array
example:
<input type="checkbox" name="id[0]" value="1"> and so on...

later in your PHP script, you can check by using foreach

foreach ($_POST['id'] as $key=>$value){
//$key will be the key of array
//$value will be the ID stored in value

}

cgraz

scoppc posted a good solution, but it's not necessary to assign the array keys when creating the checkboxes. Instead of doing

Makes things easier instead of having to assign array keys to each one; just allow php to do it automatically for you. The foreach loop would still be the same.

Cgraz

Ravenous

foreach ($_POST['id'] as $key=>$value){
$q = "DELETE FROM info WHERE id = ???";
$r = mysql_query($q, $db) or die("Query failed: " . mysql_error());
}

I'm kinda lost on what I need in place of those question marks.

cgraz

well your checkboxes hold the id's. So...

$q = "DELETE FROM info WHERE id ='$value'

But, if you're doing a DELETE query, I wouldn't do it like this. Too many delete statments. I'd skip the foreach loop and do it all in one query. Here's all the code you need

   $q = "DELETE FROM info WHERE id IN ('" . implode("','", $_POST['id']) . "')";
$r = mysql_query($q) or die(mysql_error());

Cgraz

Ravenous

I appreciate your help Cgraz, but I don't get anything. I tried the foreach loop as well as the code from your last reply. Both times nothing is deleted. Neither code segment causes an error or anything either. So the logic is incorrect somewhere.

If you're interested, the code is atached.. completely uncommented. 😃 You can also view the beginnings of the page at www.barbourcentral.com/dustin/index.php .

Also, if you're feeling up to it, do you think you could explain what's going on in that query of yours? I have yet to start using implode() and my MySQL syntax isn't the best either. Specifically, what does IN accomplish?

Ravenous

Bleh.. Thanks for your input, cgraz. I should be able to figure this out.