php批量删除表格内容的方法:1、创建一个“list_pl.php”文件;2、创建“shanchu.php”文件用于实现删除功能;3、创建修改和更新页面;4、创建批量删除页面“adminDel.php”即可。

本文操作环境:windows7系统、PHP7.1版、Dell G3电脑。
php怎么批量删除表格内容?
php操作表格数据【含批量删除】
效果图:

list_pl.php:
<?php $con = mysqli_connect('localhost','root','123456','test');
mysqli_set_charset($con,'utf8');
if(!$con){
die('Could not connect:' . mysql_error($con));
}
$sql = "select * from login";
$result = mysqli_query($con,$sql);
$rows = array();
while($row = mysqli_fetch_assoc($result)){
$rows[] = $row;
}
?>html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<meta>
<title>无标题文档</title>
<style>
*{padding:0;margin:0;}
.pd-lr{padding: 5px 20px}
</style>
| 全选: | id | 用户名 | 密码 | 邮箱 | 操作 | 提交时间 |
| " class="checkOne"> | ')">删除 '>修改 |
总共query($sql2); while ($nums=$all_value->fetch_assoc()) { //输出每一行数据 echo ($nums['COUNT(*)']); //获取数据库总条数 } ?>条
<script></script> <script> // 单项删除 function confirm_delete(url){ if(confirm('您确定要执行删除操作?')){ window.location.href=url; }else{ return false; } } // 全选,反选 $("#checkAll").on('change', function () { if ($(this).is(":checked")) { // 全选 $(".checkOne").prop("checked",true); } else { // 反选 $(".checkOne").prop("checked",false); } }); // 批量删除 $('button').click(function(){ var ids=$('.checkOne:checkbox'); var str=''; var count=0; for(var i=0;i<ids.length;i++){ if(ids.eq(i).is(':checked')){ str+=','+ids.eq(i).val(); count++; } } var str=str.substr(1); if(confirm('你确定要删除这'+count+'条数据吗?')){ //获取id后删除 $.ajax({ type:'GET', url:'adminDel.php', // contentType: "application/json;charset=utf-8", data:{'str':str}, // dataType:'json',//用get方法时不指定这项(可能是json数据不够严谨) success:function(res){ if(res>0){ for(var i=ids.length-1;i>=0;i--){ if(ids.eq(i).is(':checked')){ ids.eq(i).parent().parent().remove(); } } } alert('删除成功!'); window.location.reload(); }, error:function(data){ console.log("数据加载失败",data); } }) } return false; }); </script>shanchu.php(单项删除也可以直接填adminDel.php的路径):
<?php
$aaa = $_GET ["sno"]; //删除方式使用的get,照旧
$db = new mysqli("localhost","root","123456","test");
$sql = "delete from login WHERE id='{$aaa}'";
if($db->query($sql)){
// header("location:list.php");
echo "<script>alert('删除成功!');window.location.href='list.php'</script>" ;
}else{
echo "删除失败";
}
?>
xiugai.php(修改页面):
<meta>
<title>无标题文档</title>
<h1>修改</h1>
<?php
$sno = $_GET{"sno"};
$db = new mysqli("localhost","root","123456","test");
$sql = "select * from login WHERE id='{$sno}'";
$r = $db->query($sql);
$arr = $r->fetch_row();
?>
xiugai.php更新页面还可以这样写:
<?php
//创建连接:四个参数分别为 服务器地址、用户名、密码、数据库名
$conn = mysqli_connect("localhost","root","123456","test");
$sno = $_GET{"sno"};
//查询数据的sql语句
$sql = "select * from login WHERE id='{$sno}'";
//执行语句接收返回值
$result = mysqli_query($conn,$sql);
//输错查询的数据
while ($row = mysqli_fetch_array($result)){?><style>
.list{margin: 0 auto;}
.list p{font-size: 1rem;padding: 5px 0;}
.list p span{display: inline-block;width: 100px;}
.list p input{padding: 5px 0;outline:none;border: 1px solid #ccc;border-radius: 4px;-webkit-box-shadow: inset 0 1px 1px rgba(0, 0, 0, .075);box-shadow: inset 0 1px 1px rgba(0, 0, 0, .075);-webkit-transition: border-color ease-in-out .15s, -webkit-box-shadow ease-in-out .15s;-o-transition: border-color ease-in-out .15s, box-shadow ease-in-out .15s;transition: border-color ease-in-out .15s, box-shadow ease-in-out .15s;}
.list p input:focus {border-color: #66afe9;outline: 0;-webkit-box-shadow: inset 0 1px 1px rgba(0,0,0,.075), 0 0 8px rgba(102, 175, 233, .6);box-shadow: inset 0 1px 1px rgba(0,0,0,.075), 0 0 8px rgba(102, 175, 233, .6);}
.list .up_btn input{padding: 5px 10px;font-size: 1rem;border: 1px solid #2285ed;background-color: #FFF;}
.list .up_btn input:hover{background-color: #2285ed;color: #fff;}
.tran-b{-webkit-transition: all ease-out .5s;-o-transition: all ease-out .5s;transition: all ease-out .5s;}
</style>
update.php(更新页面) :
<?php error_reporting(E_ALL ^ E_NOTICE);
$id = $_POST["id"];
$username = $_POST["username"];
$password = $_POST["password"];
$email = $_POST["email"];
$db = new mysqli("localhost","root","123456","test");
$sql = "update login set username='{$username}',password='{$password}',email='{$email}' WHERE id='{$id}'";
if($db->query($sql)){
// header("location:list.php");
echo "<script>alert('修改成功!');window.location.href='list_pl.php'</script>" ;
}else{
echo "修改失败";
}
?>
adminDel.php(批量删除页面):
<?php
error_reporting(E_ALL ^ E_NOTICE);
// header('content-type:text/html;charset=utf-8');
// header('Content-type: application/json;charset=utf-8');
$str=$_GET['str'];
// echo $str;
$link = mysqli_connect( 'localhost' , 'root' , '123456' , 'test' );
// mysqli_query($link,'set names utf8');
$sql='delete from login where id in ('.$str.')';
mysqli_query($link,$sql);
?>
遇到的问题:
ajax提交数据报错,我是在本地运行的,参考:https://ask.csdn.net/questions/325174把dataType:'json',改成dataType:'text',就可以运行了,或者把dataType:'json'删掉也行。
推荐学习:《PHP视频教程》
php免费学习视频:立即使用
踏上前端学习之旅,开启通往精通之路!从前端基础到项目实战,循序渐进,一步一个脚印,迈向巅峰!










