<form id="dataList" action="del_user.php" method="post" name="myform">
<?php $sql = "select * from klm_users"; //查询数据库中所有的用户记录
$_GET[page] == "" ? $pageNo = 1 : $pageNo = $_GET[page]; $page = new Pager($pageSize=30,$sql,$pageNo,10);//$PageSize->每页要显示的数量,&$sql->SQL语句,$pageNo->当前第几页,10->10页换行
$currentPage = $page->getStartNo();//起始页
$totalPage = $page->getPageCount();//总页数
$show = "select * from `klm_users` limit $currentPage,$pageSize";
$query = $db->query($show);
print '<table class="stripe_tb" ><caption>用 户 列 表</caption>
<tr><th></th><th>学 号</th><th>姓 名</th><th>性 别</th><th>专 业</th><th>年 级</th><th>班 级</th><th>编 辑</th><th>删 除</th></th></tr>';
while(@$print = $db->fetch_array()){
echo '<tr style="cursor:pointer;" name = "tr'.$print['user_id'].'" id="tr'.$print['user_id'].'" onclick="test(this)">
<td><input type="checkbox" name="cb1" id="chk'.$print['user_id'].'"></td>
<td style="cursor:pointer;">'.$print['user_id'].'</td>
<td style="cursor:pointer;" >'.$print['user_name'].'</td>
<td style="cursor:pointer;" >'.$print['user_sex'].'</td>
<td style="cursor:pointer;" >'.$print['user_science'].'</td>
<td style="cursor:pointer;" >'.$print['user_grade'].'</td>
<td style="cursor:pointer;" >'.$print['user_class'].'</td>
<td class="center"><a href="edit_user.php?user_id='.$print['user_id'].'" title="编辑"><img src="images/edit.png"></a></td>
<td class="center"><a href="del_user.php?user_id='.$print['user_id'].'" title="删除"><img src="images/drop.png" onclick="return confirm(\'确定删除该用户吗?\')"></a></td>
</tr>';
}
//循环输出用户信息结束 print '</table>';
?>
</form>
</div>
<div id="Control">
<span class="btn_control">
<input type="button" name="CheckAll" value="全选"onClick="checkAll(document.myform.cb1)">
<input type="button" name="UnCheckAll" value="反选"onClick="uncheckAll(document.myform.cb1)">
<input type="button" value="取消" id="btn_checkNone">
<input type="button" value="批量删除" id="btn_deleteAll">
</span>
<span class="link_page">
<?php
$url="user_manage.php?";
$page->subPageCss2($url);//经典分页
mysql_close();
?>
</span>
</div>
选中了自己所需要的数据,然后点击批量删除,能删除选中的数据,希望大家帮帮忙!
<?php $sql = "select * from klm_users"; //查询数据库中所有的用户记录
$_GET[page] == "" ? $pageNo = 1 : $pageNo = $_GET[page]; $page = new Pager($pageSize=30,$sql,$pageNo,10);//$PageSize->每页要显示的数量,&$sql->SQL语句,$pageNo->当前第几页,10->10页换行
$currentPage = $page->getStartNo();//起始页
$totalPage = $page->getPageCount();//总页数
$show = "select * from `klm_users` limit $currentPage,$pageSize";
$query = $db->query($show);
print '<table class="stripe_tb" ><caption>用 户 列 表</caption>
<tr><th></th><th>学 号</th><th>姓 名</th><th>性 别</th><th>专 业</th><th>年 级</th><th>班 级</th><th>编 辑</th><th>删 除</th></th></tr>';
while(@$print = $db->fetch_array()){
echo '<tr style="cursor:pointer;" name = "tr'.$print['user_id'].'" id="tr'.$print['user_id'].'" onclick="test(this)">
<td><input type="checkbox" name="cb1" id="chk'.$print['user_id'].'"></td>
<td style="cursor:pointer;">'.$print['user_id'].'</td>
<td style="cursor:pointer;" >'.$print['user_name'].'</td>
<td style="cursor:pointer;" >'.$print['user_sex'].'</td>
<td style="cursor:pointer;" >'.$print['user_science'].'</td>
<td style="cursor:pointer;" >'.$print['user_grade'].'</td>
<td style="cursor:pointer;" >'.$print['user_class'].'</td>
<td class="center"><a href="edit_user.php?user_id='.$print['user_id'].'" title="编辑"><img src="images/edit.png"></a></td>
<td class="center"><a href="del_user.php?user_id='.$print['user_id'].'" title="删除"><img src="images/drop.png" onclick="return confirm(\'确定删除该用户吗?\')"></a></td>
</tr>';
}
//循环输出用户信息结束 print '</table>';
?>
</form>
</div>
<div id="Control">
<span class="btn_control">
<input type="button" name="CheckAll" value="全选"onClick="checkAll(document.myform.cb1)">
<input type="button" name="UnCheckAll" value="反选"onClick="uncheckAll(document.myform.cb1)">
<input type="button" value="取消" id="btn_checkNone">
<input type="button" value="批量删除" id="btn_deleteAll">
</span>
<span class="link_page">
<?php
$url="user_manage.php?";
$page->subPageCss2($url);//经典分页
mysql_close();
?>
</span>
</div>
选中了自己所需要的数据,然后点击批量删除,能删除选中的数据,希望大家帮帮忙!
$checkbox = $_POST["cb1"];
$ids = '';
for($i=0;$i<count($checkbox);$i++)
{
$ids .= "'".$checkbox[i]."',";
}
$ids = substr($ids,0,-1);使用如下sql删除:delete from klm_users where user_id in ($ids);
$ids = '';
for($i=0;$i<count($checkbox);$i++)
{
$ids .= "'".$checkbox[i]."',";
}
$ids = substr($ids,0,-1);
这段是?能解释下么?还有就是这段代码放在什么位置.希望能说清楚.谢谢~!
2: php页面
$checkbox = $_POST["cb1"];
$i = 1;
//获得要删除的ids 1,2,3,4 的形式
foreach($checkbox as $key => $value){
$ids = $i++ == 1 ? $value : ',' . $value;
}$sql = "delete * from table where user_id IN ($ids)";
//执行sql 语句就行了!~