PHP7实战开发简单CMS内容管理系统(11)批量删除栏目数据

时间:2022-09-19 15:34:33

PHP7实战开发简单CMS内容管理系统(11)批量删除栏目数据

 

<删除>按钮:

<a class="btn btn-danger btn-xs" id="del_btn" disabled="disabled" onclick="return confirm('确定要删除?');" href="./category_del.php"><i class="fa fa-times"></i>删除</a>

checkbox :
<input data-id="<?php echo  $c['id'];?>" class="checkbox-slider colored-blue btn-xs" type="checkbox">

js:
<script>
$(function(){
var tbodyCheckbox = $('tbody input');
var delBtn = $("#del_btn");
var allCheckedIds = [];
tbodyCheckbox.on('change',function () {
//delBtn.removeAttr('disabled');
var id = $(this).data('id');
if ($(this).prop('checked')){
allCheckedIds.push(id);
}else
{
allCheckedIds.splice(allCheckedIds.indexOf(),1)
}

allCheckedIds.length ? delBtn.removeAttr('disabled'):delBtn.attr("disabled",'disabled');
delBtn.prop('search','?id='+allCheckedIds);
});
});
</script>

 

php:

if (empty($_GET['id']))
{
exit('缺少必要参数');
}

$id = $_GET['id'];

//判断id是否是数值

$affected_rows = sql_excute("delete from ft_category WHERE id in ({$id});");
if($affected_rows>0)
{
header('Location:./category_list.php');
}
else
{
exit('数据不存在!');
}