How to delete table contents in batches in php
php method to delete table contents in batches: 1. Create a "list_pl.php" file; 2. Create a "shanchu.php" file to implement the deletion function; 3. Create a modification and update page; 4. Just create the batch deletion page "adminDel.php".
The operating environment of this article: Windows 7 system, PHP version 7.1, Dell G3 computer.
How to delete table contents in batches in php?
php operation form data [including batch deletion]
Rendering:
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;
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>无标题文档</title>
<style>
*{padding:0;margin:0;}
.pd-lr{padding: 5px 20px}
</style>
</head>
<body>
<table width="100%" border="1" cellpadding="0" cellspacing="0">
<thead>
<tr>
<td width="30">
全选：<input id="checkAll" type="checkbox">
</td>
<td width="30">id</td>
<td width="30">用户名</td>
<td width="30">密码</td>
<td width="30">邮箱</td>
<td width="40">操作</td>
<td width="30">提交时间</td>
</tr>
</thead>
<tbody>
<?php foreach($rows as $k => $v) {
?>
<tr>
<td><input type="checkbox" name="box" value="<?= $v['id'] ?>" class="checkOne"></td>
<td><?php echo $v['id'];?></td>
<td><?php echo $v['username'];?></td>
<td><?php echo $v['password'];?></td>
<td><?php echo $v['email'];?></td>
<td>
<a href="javascript:confirm_delete('shanchu.php?sno=<?php echo $v['id'];?>')">删除</a>
<a href='xiugai.php?sno=<?php echo $v['id'];?>'>修改</a>
</td>
<td><?php echo $v['CreateTime'];?></td>
</tr>
<?php } ?>
</tbody>
</table>
<p class="pd-lr">
<button style="float:left;">批量删除</button>
<!-- 数据表的总条数 -->
<p style="float:right;display:inline-block;">总共<span><?php
$sql2 = "SELECT COUNT(*) FROM login"; //获取某一张表的所有数据
$all_value = $con->query($sql2);
while ($nums=$all_value->fetch_assoc()) { //输出每一行数据
echo ($nums['COUNT(*)']); //获取数据库总条数
} ?></span>条</p>
</p>
<script src="./jquery-3.2.1.min.js"></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>
</body>
</html>shanchu.php (You can also directly fill in the path of adminDel.php when deleting a single item):
<?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 (modify page):
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>无标题文档</title>
</head>
<body>
<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();
?>
<form action="update.php" method="post">
<p>id：<input type="text" name="id" value="<?php echo $arr[0]; ?>"/></p>
<p>用户名：<input type="text" name="username" value="<?php echo $arr[1]; ?>"/></p>
<p>密码：<input type="text" name="password" value="<?php echo $arr[2]; ?>"/></p>
<p>邮箱：<input type="text" name="email" value="<?php echo $arr[4]; ?>"/></p>
</p>
<p><input type="submit" value="修改完毕"/></p>
</form>
</body>
</html>xiugai.php The update page can also be written like this:
<?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 type="text/css">
.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>
<form action="./update.php" method="post" class="list">
<p><span style="color: #2285ed;">id：<input type="hidden" value="<?php echo $row['id'];?>" name="id" /><?php echo $row['id'];?></span></p>
<p><span>用户名：</span><input type="text" name="username" value="<?php echo $row['username'];?>" /></p>
<p><span>密码：</span><input type="text" name="password" value="<?php echo $row['password'];?>" /></p>
<p><span>邮箱：</span><input type="text" name="email" value="<?php echo $row['email'];?>" /></p>
</p>
<p class="up_btn"><input type="submit" value="修改完毕" class="tran-b"/></p>
</form>
<?php }?>update.php (update Page):
<?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 (batch delete page):
<?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);
?>Problems encountered:
ajax reports an error when submitting data. I am running it locally. Reference: https://ask.csdn.net/questions/325174dataType:'json' ,Change to dataType:'text', and it will work, or delete dataType:'json'.
Recommended learning: "PHP Video Tutorial"
The above is the detailed content of How to delete table contents in batches in php. For more information, please follow other related articles on the PHP Chinese website!
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
AI Hentai Generator
Generate AI Hentai for free.
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
CakePHP Project Configuration
Sep 10, 2024 pm 05:25 PM
In this chapter, we will understand the Environment Variables, General Configuration, Database Configuration and Email Configuration in CakePHP.
PHP 8.4 Installation and Upgrade guide for Ubuntu and Debian
Dec 24, 2024 pm 04:42 PM
PHP 8.4 brings several new features, security improvements, and performance improvements with healthy amounts of feature deprecations and removals. This guide explains how to install PHP 8.4 or upgrade to PHP 8.4 on Ubuntu, Debian, or their derivati
CakePHP Date and Time
Sep 10, 2024 pm 05:27 PM
To work with date and time in cakephp4, we are going to make use of the available FrozenTime class.
CakePHP File upload
Sep 10, 2024 pm 05:27 PM
To work on file upload we are going to use the form helper. Here, is an example for file upload.
CakePHP Routing
Sep 10, 2024 pm 05:25 PM
In this chapter, we are going to learn the following topics related to routing ?
Discuss CakePHP
Sep 10, 2024 pm 05:28 PM
CakePHP is an open-source framework for PHP. It is intended to make developing, deploying and maintaining applications much easier. CakePHP is based on a MVC-like architecture that is both powerful and easy to grasp. Models, Views, and Controllers gu
CakePHP Creating Validators
Sep 10, 2024 pm 05:26 PM
Validator can be created by adding the following two lines in the controller.
How To Set Up Visual Studio Code (VS Code) for PHP Development
Dec 20, 2024 am 11:31 AM
Visual Studio Code, also known as VS Code, is a free source code editor — or integrated development environment (IDE) — available for all major operating systems. With a large collection of extensions for many programming languages, VS Code can be c
