Checkbox in a while loop

Question

I am trying to create a function where users can check a message to delete. Obviously if more than one message is checked, they will all be deleted.

I have the following code

<form action="process.php" method="post">
    <input type="hidden" name="deleteMessages" />
    <?php
    while($row=mysql_fetch_assoc($q))
    {
        if($row['to_viewed'] == 0)
        {
        ?>
        <tr>
            <td><input type="hidden" name="check_box_1" value="0" />
                <input type="checkbox" name="check_box_1" value="1" />
            </td>
            <td><b><a href='<?php echo $_SERVER['PHP_SELF']; ?>?p=view&mid=<?php echo $row['id']; ?>'><?php echo $row['title'] ?></a></b></td>
            <td><b><a href='<?php echo $_SERVER['PHP_SELF']; ?>?p=view&mid=<?php echo $row['id']; ?>'><?php echo $row['from']; ?></a></b></td>                
            <td><b><?php echo $row['created']; ?></b></td>
        </tr>
        <?php
        }
        else if($row['to_viewed'] == 1)
        {
        ?>
        <tr>
            <td><input type="hidden" name="check_box_1" value="0" />
                <input type="checkbox" name="check_box_1" value="1" />
            </td>
            <td><a href='<?php echo $_SERVER['PHP_SELF']; ?>?p=view&mid=<?php echo $row['id']; ?>'><?php echo $row['title'] ?></a></td>
            <td><a href='<?php echo $_SERVER['PHP_SELF']; ?>?p=view&mid=<?php echo $row['id']; ?>'><?php echo $row['from']; ?></a></td>                
            <td><?php echo $row['created']; ?></td>
        </tr>
        <?php
        }
    }
    ?>
    <input type="submit" value="Delete All" />
    </form>

I want to pass the checkbox through and if the value is 1, process it and delete it. But how would I achieve this with mulitple messages no matter if there is one message or ten? Thanks

fred · Accepted Answer · 2010-12-05 22:27:59Z

2

In your form put:

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

Then to process:

if(isset($_POST['check_box_delete']))
{
    foreach($_POST['check_box_delete'] as $id)
    {
        // Delete $id
    }
}

answered Dec 5, 2010 at 22:27

fred

2682 silver badges4 bronze badges

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

4 Comments

sark9012 Over a year ago

Perfect thankyou. I just couldnt work out how to use an array here!

mpen Over a year ago

I wouldn't use foreach though. You can to it in a single SQL query.

fred Over a year ago

While you could do it without foreach (or any looping method) it would be very difficult to do all the required auth checking etc. It would be fine to create a single delete query after all checks have been done.

sark9012 Over a year ago

All done, implemented and works a treat. THanks for the tip bud.

Cobra_Fast · Accepted Answer · 2010-12-05 22:26:15Z

0

You can let php store mutliple values in an array by naming the input fields with an array designator suffix []. For example, all checkboxes named checkbox[] will then be stored in $_POST['checkbox'][]. Note that this may not be applicable to checkboxes as their $_POST value only exists if they were checked.

answered Dec 5, 2010 at 22:26

Cobra_Fast

16.2k8 gold badges64 silver badges106 bronze badges

Comments

Komal12 · Accepted Answer · 2017-07-04 08:17:13Z

0

<input type="checkbox" 
       name="mid_to_delete[]" 
       value="some message id"
       id="mid_to_delete_some_message_id">
<label for="mid_to_delete_some_message_id">Delete "Some subject"</label>

and then

<?php
    foreach ($_POST['mid_to_delete'] as $mid) {
        delete_some_message_id($mid);
    }
?>

Since only successful controls are submitted, and unchecked checkboxes are not successful, all the values you get will be ones that have been selected for deletion. (Obviously you still need to perform auth/authz to make sure that the messages being deleted are ones the user is allowed to delete)

edited Jul 4, 2017 at 8:17

Komal12

3,3584 gold badges18 silver badges25 bronze badges

answered Dec 5, 2010 at 22:25

Quentin

949k136 gold badges1.3k silver badges1.4k bronze badges

Collectives™ on Stack Overflow

Checkbox in a while loop

3 Answers 3

4 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related