[SOLVED] Multi Private Message Deletion

[Cless]

Hello.

 

If you had a Private Messaging Inbox system, and had a check box beside each Private Message, and at the top, there was a 'Delete Selected Private Message' option, how would you loop the data so it deletes each selected Private Message, and what would the value of the check box be? The ID of the Private Message?

 

Thanks!

[GingerRobot]

Yeah, if you set the value of the checkboxes to be the ID of the private message, and make the checkboxes an array, you can use the implode function on the checkbox array, and then use the mysql IN clause to delete them all. More efficient than looping through and doing a separate query for each. Something like:

 

<?php
$ids = implode(",",$_POST['checkboxes'];//assuming numerical IDs. If alphanumeric, use "','" as glue. 
mysql_query("DELETE FROM `yourtable` WHERE `id` IN ($ids)")or die(mysql_error());

[Cless]

I see. Thanks.

 

Though, how would you change them into an array?

[GingerRobot]

Set the names like:

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

[Cless]

Ah. Exactly like that? Would the names be checkboxes[<?PHP echo $id; ?>], or just checkboxes[]?