Home > Article > Backend Development > How to implement batch deletion operations in php
This article mainly introduces the PHP batch deletion operation, batch deletion page and .delete processing interface in detail. It has certain reference value. Interested friends can refer to it.
The specific content is as follows
1. Batch delete page piliangcaozuo.php
<body>
<form action="shanchu.php" method="post">
<table width="100%" border="1" cellpadding="0" cellspacing="0">
<tr>
<td><input type="checkbox" name="qx" onclick="quanxuan(this)"/>代号</td>
<td>名称</td>
</tr>
<?php
require"DBDA.class1.php";
$db = new DBDA();
$sql = "select * from nation";
$arr = $db->query($sql);
foreach($arr as $v)
{
echo "<tr>
<td><input type='checkbox' name='ck[]' class='ck' value='{$v[0]}'/>{$v[0]}</td>
<td>{$v[1]}</td>
</tr>";
}
?>
</table>
<input type="submit" value="批量删除" />
</form>
</body>
<script type="text/javascript">
function quanxuan(qx)
{
var ck=document.getElementsByClassName("ck");
if(qx.checked)
{
for(var i=0;i<ck.length;i++)
{
ck[i].setAttribute("checked","checked");
}
}
else
{
for(var i=0;i<ck.length;i++)
{
ck[i].removeAttribute("checked");
}
}
}
</script>
</html>
refers to the encapsulation class DBDA.class1. php
<?php
class DBDA
{
public $host = "localhost";
public $uid = "root";
public $pwd = "123";
public $dbname = "test_123";
//执行SQL语句返回相应的结果
//$sql 要执行的SQL语句
//$type 代表SQL语句的类型，0代表增删改，1代表查询
function query($sql,$type=1)
{
$db = new MySQLi($this->host,$this->uid,$this->pwd,$this->dbname);
$result = $db->query($sql);
if($type)
{
//如果是查询，显示数据
return $result->fetch_all();
}
else
{
//如果是增删改，返回true或者false
return $result;
}
}
}
2. Delete processing interface sanchu.php
<?php
$arr = $_POST["ck"];
require"DBDA.class.php";
$db = new DBDA();
//delete from nation where code in('n001','n002','n003')
$str = implode("','",$arr);
$sql = "delete from nation where code in('{$str}')";
/*echo $sql;*/
if($db->query($sql,0))
{
header("location:piliangcaozuo.php");
}
Related recommendations:
ThinkPHP implements user information query, update and delete functions
mysql creates root ordinary users and modifiesdelete FunctionDetailed explanation
jQuery implements the add and delete function of user information table
The above is the detailed content of How to implement batch deletion operations in php. For more information, please follow other related articles on the PHP Chinese website!