1,html部分
<!DOCTYPE html><html lang="en">
<head>
<meta charset="UTF-8">
<script type="text/javascript" src="./jquery-1.9.0.min.js"></script>
<title>Document</title>
</head>
<body>
<div class="data-table" style="margin-top:20px;">
<button style="margin-bottom: 8px;" id="s_delete">删除</button>
</div>
<div class="table-striped">
<table border="1" cellspacing="0">
<!-- 表头 -->
<thead>
<tr>
<th>
<input id="CheckAll" name='CheckAll' type='checkbox'>
<span class="copy_span">全选</span>
</th>
<th>编号</th>
<th>信息</th>
<th>备注</th>
<th>操作</th>
</tr>
</thead>
<!-- 列表 -->
<tbody>
<tr>
<td>
<input id='Check[]' name='Check[]' type='checkbox' value="1">
</td>
<td type="headimgurl">1</td>
<td >data</td>
<td >remark</td>
<td>
<a href="javascript:void(0)">查看</a> |
<a href="javascript:void(0)">编辑</a> |
<a href="javascript:void(0)" class="del">删除</a>
</td>
</tr>
<tr>
<td type="headimgurl">
<input id='Check[]' name='Check[]' type='checkbox' value="2">
</td>
<td type="headimgurl">2</td>
<td >data</td>
<td >remark</td>
<td>
<a href="javascript:void(0)">查看</a> |
<a href="javascript:void(0)">编辑</a> |
<a href="javascript:void(0)" class="del">删除</a>
</td>
</tr>
<tr>
<td type="headimgurl">
<input id='Check[]' name='Check[]' type='checkbox' value="3">
</td>
<td type="headimgurl">3</td>
<td >data</td>
<td >remark</td>
<td>
<a href="javascript:void(0)">查看</a> |
<a href="javascript:void(0)">编辑</a> |
<a href="javascript:void(0)" class="del">删除</a>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>
<script type="text/javascript">
//多选删除
$("#CheckAll").bind("click",function(){
$("input[name='Check[]']").prop("checked",this.checked);
});
//获取被选中checkbox值
var checked = function(){
var checks = $("input[name='Check[]']:checked");
if(checks.length == 0){
alert('未选中任何项!');return false;
}
var checkData = new Array();
checks.each(function(){
checkData.push($(this).val());
});
return checkData;
};
//批量删除
$("#s_delete").click(function(){
if(val = checked()){
if(confirm('确定要删除所选吗?')){
$.ajax({
type : "POST",
url : "./del_data.php",
data : {del_id:val},
dataType : "json",
success : function(data){
if(data == 1){
alert('删除成功!');
return false;
}else{
alert('删除失败!');
return false;
}
}
});
}
}
});
</script>
3,PHP部分
<?php
header('Content-Type:text/html;charset=utf-8');
// 连接数据库:mysqli_connect(服务器名,用户名,密码,数据库名)
$con = mysqli_connect("localhost","username",'password','dbname');
if(!$con){
die('Could not connect: ' . mysql_error());
}
// 设置插入数据编码为utf8
mysqli_query($con,"set names utf8");
$del_id = isset($_POST['del_id']) ? $_POST['del_id'] : 0;
$str_id = implode(',',$del_id);
$sql = "delete from tb_name where id in (".$str_id.")";
$del_res = $conn -> query($sql);
if($del_res){
echo 1;die;//删除成功
}else{
echo 0;die;//删除失败
}
$conn -> close();