php 批量删除

时间:2021-10-02 15:43:52

php 批量删除

<body>
<form action="shanchu.php" method="post">
<table width="100%" border="1" cellpadding="0" cellspacing="0">
<tr>
<td><input type="checkbox" id="qx" onclick="xuanzhong()" />全选</td>
<td>代号</td>
<td>名称</td>
</tr>

<?php
include("../fengzhuang/DBDA.class.php");
$db = new DBDA();

$sql = "select * from car";
$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="删除" onclick="return tishi()" />
</form>
</body>
<script type="text/javascript">
function xuanzhong()
{
//取全选按钮的选中状态
var zt = document.getElementById("qx").checked;

//让下面所有的checkbox选中状态改变
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()
{
//找所有选中项
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("确定要删除以下数据么:"+str+"");
}
</script>