Home >Backend Development >PHP Tutorial >PHP database batch deletion method

PHP database batch deletion method

一个新手Original: 2017-10-18 09:10:322068browse

<!DOCTYPE html>
<html>
<head>
    <meta charset="utf-8">
    <title>Title</title>
</head>
<body>
<?php
$db = new Mysqli("localhost","root","root","db_0808");
//!$db?"":die("链接错误");
empty(mysqli_connect_error())?"":die("链接错误");
$sql = "select * from student where is_delete=&#39;0&#39;";
//$data = $db->query($sql)->fetch_all();
?>
<form action="batch_delete.php" method="post">
<table border="1">
    <tr>
        <td>id</td>
        <td>名字</td>
        <td>性别</td>
        <td>班级</td>
        <td>生日</td>
        <td>操作</td>
        <td>选择</td>
    </tr>
    <?php
    $result=$db->query($sql);
    while ($data=$result->fetch_row()){
//    foreach ($data as $i){
        if ($data[2]==1){
            $data[2]="男";
        }else if ($data[2]==0){
            $data[2]="女";
        }else{
            $data[2]="保密";
        }
        echo "<tr>
                 <td>{$data[0]}</td>
                 <td>{$data[1]}</td>
                 <td>{$data[2]}</td>
                 <td>{$data[3]}</td>
                 <td>{$data[4]}</td>
                 <td><a href=&#39;delete.php?id={$data[0]}&#39;>删除</a>
                     <a href=&#39;xiugai.php?id={$data[0]}&#39;>修改</a>
                 </td>
                 <td><input type=&#39;checkbox&#39; name=&#39;ids[]&#39; value=&#39;{$data[0]}&#39;></td>                 //
              </tr>";
    }
    ?>
</table>
<form action="batch_delete.php" method="post">
<input type="submit" value="删除所选">
</form>
    <a href="add.php">新增用户</a>
</body>
</html>

<?php
/**
 * Created by fcc
 * User: Administrator
 * Date: 2017/10/17
 * Time: 15:16 */$ids=$_POST[&#39;ids&#39;];$db=new Mysqli("localhost","root","root","db_0808");empty(mysqli_connect_error())?"":die("链接错误");//$sql="DELETE FROM student WHERE Sno=&#39;{$id}&#39;";//彻底删除foreach ($ids as $i){$sql = "update student set is_delete = &#39;1&#39; where Sno= &#39;{$i}&#39;";//表面删除if ($db->query($sql)){    header("location:CURD.php");
};
};

The above is the detailed content of PHP database batch deletion method. For more information, please follow other related articles on the PHP Chinese website!

Statement：

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Previous article：Example of implementing two-dimensional array quick sorting algorithm in PHPNext article：Example of implementing two-dimensional array quick sorting algorithm in PHP

See more

PHP database batch deletion method

Related articles