multiple checkbox post form

Question

The below code will only work with one checkbox and ignores the rest. Is there any way that I can have it to delete selected checkboxes? I have tried using implode but it gives me

Warning: implode(): Invalid arguments passed

  <form action="" method="post">
 <input type="checkbox" name="id"  class="check" value = "<?php echo $row['id']; ?>">
 <?php echo $row['to_user'];?>
  <input type="submit" name="delete">
 </form>


    <?php

 if (isset($_POST['delete'])) {
 $id =  $_POST['id']; 
 $ids = implode( ',', $id );

 $mydb = new mysqli('localhost', 'root', '', 'database');
 $stmt = $mydb->prepare("update messages set deleted = 'yes' where from_user = ?  and id = ? ");
 $stmt->bind_param('ss', $user, $ids);
 $stmt->execute();

echo "Message succesfully deleted";
exit();}

?>

Where is the loop that processes the query result? Are you really creating a separate form for each checkbox, instead of multiple checkboxes in one form? — Barmar
– Barmar, Commented Aug 16, 2013 at 23:40

Barmar · Accepted Answer · 2013-08-16 23:34:01Z

3

Give the checkbox an array-style name:

<input type="checkbox" name="id[]"  class="check" value = "<?php echo $row['id']; ?>">

This will cause $_POST['id'] to be an array of all the checked values. Then delete them in a loop:

$mydb = new mysqli('localhost', 'root', '', 'database');
$stmt = $mydb->prepare("update messages set deleted = 'yes' where from_user = ? and id = ?");
$stmt->bind_param('ss', $user, $id);
foreach ($_POST['id'] as $id) {
    $stmt->execute();
}

You can't use a comma-separated list of IDs with =. You can use it with id in (...), but you can't do parameter substitution with this because the number of elements isn't known. So the loop is th best way to do it.

answered Aug 16, 2013 at 23:34

Barmar

789k57 gold badges555 silver badges669 bronze badges

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

8 Comments

Mikel Max Over a year ago

array(1) { [0]=> string(1) "4" }

Barmar Over a year ago

I don't believe you. That looks more like var_dump($_POST['id']).

Mikel Max Over a year ago

oh yeah.. it is NULL

Barmar Over a year ago

Sorry, that was a typo, I meant var_dump($_POST).

Barmar Over a year ago

But if $_POST['id'] contains that array, it should be setting deleted = yes for ID 4. I assume you're setting $user correctly, that isn't anywhere in the question.

|

Collectives™ on Stack Overflow

multiple checkbox post form

1 Answer 1

8 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

8 Comments

Your Answer

Sign up or log in

Post as a guest

Related