12-29 Bulk Delete

<form action= "shanchu.php" method= "POST" >
<table width= "100%" border= "1" cellpadding= "0" cellspacing= "0" >
<tr>
<td><input type= "checkbox" id= "QX" onclick= "Xuanzhong ()"/> Select all </td>
<td> Code </td>
<td> name </td>
</tr>

<?php
Include (".. /fengzhuang/dbda.class.php ");
$db = new Dbda ();

$sql = "SELECT * From Nation";
$attr = $db->query ($sql);

foreach ($attr as $v)
{
echo "<tr>
<td><input type= ' checkbox ' name= ' ck[] ' class= ' ck ' value= ' {$v [0]} '/></td>
<td>{$v [0]}</td>
<td>{$v [1]}</td>
</tr> ";
}

?>

</table>
<input type= "Submit" value= "delete" onclick= "return Tishi ()"/>
</form>
</body>
<script type= "Text/javascript" >
function Xuanzhong ()
{
Select All selected Buttons
var zt = document.getElementById ("QX"). Checked;

Let all of the checkboxes in the following check state change
var ck = document.getelementsbyclassname ("ck");

for (Var i=0;i<ck.length;i++)
{
if (ZT)
{
Ck[i].setattribute ("Checked", "checked");
}
Else
{
Ck[i].removeattribute ("checked");
}
}
}

function Tishi ()
{
Find All Selected items
var ck = document.getelementsbyclassname ("ck");

var str = "";

for (Var i=0;i<ck.length;i++)
{
if (ck[i].checked)
{
str + = ck[i].value+ ",";
}
}

return confirm ("OK to delete the following data:" +str+ "");
}
</script>

Effect:

Delete Page

<?php
$ck = $_post["ck"];

Include (".. /fengzhuang/dbda.class.php ");
$db = new Dbda ();

The first way
/*foreach ($ck as $v)
{
$sql = "Delete from Nation where code= ' {$v} '";
$db->query ($sql, 0);
}*/

The second way
In (",", ",", ",")
$str = Implode ("', '", $ck);

$str = "(' {$str} ')";

$sql = "Delete from Nation where code in {$str}";
$db->query ($sql, 0);

Header ("location:main.php");

12-29 Bulk Delete