批量删除的PHP

开发者琪帆技术 2022年11月15日

0 收藏 962 点赞 4,427 浏览 1406 个字

第一个页面shanchu.php

<!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>
</head><body><h1>批量删除</h1><form action="pldel.php" method="post"><table width="100%" border="1" cellpadding="0" cellspacing="0">    <tr>
        <td>
            <input type="checkbox" name="qx" onclick="checkall(this)" />
            代号
        </td>
        <td>名称</td>
    </tr>    <?php
    $db = new MySQLi("localhost","root","root","dbname");
    $sql = "select * from nation";
    $result = $db->query($sql);
    while($arr = $result->fetch_row())
    {
        echo "<tr>
        <td>
            <input type='checkbox' value='{$arr[0]}' name='item[]' class='ck' />
            {$arr[0]}
        </td>
        <td>{$arr[1]}</td>
    </tr>";
    }    ?></table><input type="submit" value="批量删除" /></form>
<script type="text/javascript">function checkall(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>
</body>
</html>

1、item的那里加入[]代表数组

2、注意js的写法

第二个页面pldel.php

<?php$arr = $_POST["item"];$db = new MySQLi("localhost","root","root","dbname");/*foreach($arr as $v)                //不建议使用这种方式，对数据库操作过多
{
    $sql = "delete from nation where code='{$v}'";
    $db->query($sql);
}*/$str = implode("','",$arr);//注意需要替换的内容$sql = "delete from nation where code in('{$str}')";//注意拼写字符串if($db->query($sql))
{
    header("location:shanchu.php");
}