Multiple deletes with checkbox

[jbachris]

I have the follow code, it works great to delete 1 item in the database at a time. What I am trying to accomplish is deleting multiple items at a time...

<?
require ( "dbconnex.php" );	

$posts_rs = $conn->Execute ( "SELECT ID, post_title, post_modified FROM wp_posts ORDER BY post_title DESC" ) or die ( $conn->ErrorMsg() );

?>
<? while ( ! $posts_rs->EOF ) { 	?>

<input type="checkbox" id="<?=($posts_rs->Fields("ID"))?>" value="<?=($posts_rs->Fields("ID"))?>"  /><?=($posts_rs->Fields("post_title"))?>

<br /><br />
<? $posts_rs->MoveNext(); } ?>

I had this before using a normal link to delete.php, which had this code:

<?
require ( "dbconnex.php" );	
$ID = $_GET['ID'];
$deletepost = mysql_query("DELETE FROM wp_posts WHERE ID = '$ID' LIMIT 1");
$delpos = mysql_query($deletepost);

?>

Can someone help me with the delete.php portion so that all of the db entries that have their input box checked are deleted?

[roscor]

<?PHP
require ( "dbconnex.php" );    

$posts_rs = $conn->Execute ( "SELECT ID, post_title, post_modified FROM wp_posts ORDER BY post_title DESC" ) or die ( $conn->ErrorMsg() );

?>

<table width="595" border="0" cellspacing="0" cellpadding="0" align="centre" >
<table width="800" border="0" cellspacing="0" cellpadding="0" align="centre" >
  <tr>
   <td width="169" align="left"><font face="Verdana" size="2" color="#000000">ID:</font></td>   

	<td width="206" align="left"><font face="Verdana" size="2" color="#000000">Post Title:</font></td>
	<td width="83" align="left"><font face="Verdana" size="2" color="#000000">Post Modified:</font></td> 
</tr>
</table>



<table border="0" width="800" height="50"  bordercolor="#111111">


<tr>

  <td style="border-style:solid; border-width:1px; border-color:#000000;" width="100%" height="20" valign="top"  bgcolor="#FFFFFF" bordercolor="#111111">


<div class="scrollable" style="height:400px; width:800; overflow:auto;">


 <table cellSpacing="0" cellPadding="1" border="0" id="RecentFeedback" class="itemTable" width="800" height="20" align="top"> 
<td align="center"><font face="Verdana" size="2" color="#000000"></td>
<td align="center"><font face="Verdana" size="2" color="#000000"></td>
<td align="center"><font face="Verdana" size="2" color="#000000"></td>

<?PHP

$color1 = '#EEEEEE';
$color2 = '#FFFFFFF';


$i = 0;
while ($row = mysql_fetch_array($posts_rs)) {

$color = (($i%2 == 0 || $i == 0) ? $color1 : $color2);


$id=$row['id'];
$post_title=$row['post_title'];
$post_modified=$row['post_modified'];
?>
<form action="delete.php" method="post">
<th><input type="checkbox" name="ID[]" value="<?php echo $id;?>" MULTIPLE> <? echo "<td bgcolor=$color align='center' size='100'><font face='Verdana' size='2' color='#000000'>$id</td>"; ?></th>
<th><input type="hidden" size="" value="<? echo $post_title; ?>" name="company"><? echo "<td width='20%' bgcolor=$color align='center'><font face='Verdana' size='2' color='#000000'>$post_title</td>"; ?></th>
<th><input type="hidden" size="" value="<? echo $post_modified; ?>" name="company"><? echo "<td width='20%' bgcolor=$color align='center'><font face='Verdana' size='2' color='#000000'>$post_modified</td>"; ?></th>
</form>

Then delete.php

<?
$id=$row['ID'];

foreach($_POST['ID'] as $key => $value) {

require ( "dbconnex.php" );    

$deletepost = mysql_query("DELETE FROM wp_posts WHERE ID = '$value'");
$delpos = mysql_query($deletepost);
 if ($delpos) {
      echo($value.' <font face ="verdana" size="2"> Record successfully deleted!<br />');

}
else {

die(print "<font face ='verdana' size='2'>Failed to Delete Record<br>Go <a href='Back_Page.php'>Back</a> and try again</font>");
}
}
}



}
?> 

I have created the selected into an array using 'ID[]' MULTIPLE allows the selection which is then sent using the form to delete.php.

Untested, hope this helps,

roscor

[cgraz]

or

delete from <table> where <Primary Key> in ('" . implode("','", $_POST['delete']) . "')"

assuming your checkbox has name="delete[]" don't forget to sanitize for sql injection though!