Home > Article > Backend Development > Example of implementing database batch deletion in PHP

Example of implementing database batch deletion in PHP

黄舟Original: 2018-05-15 10:57:182514browse

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="utf-8">
    <title>Title</title>
</head>
<body>
<? =  Mysqli("localhost","root","root","db_0808"(())?"":("链接错误" = "select * from student where is_delete=&#39;0&#39;"?>
<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>
    <?=->query( (=->
         ([2]==1[2]="男"  ([2]==0[2]="女"[2]="保密" ""?>
</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 Example of implementing database batch deletion in PHP. For more information, please follow other related articles on the PHP Chinese website!

php 数据库

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：PHP curl get post request usage example sharingNext article：PHP curl get post request usage example sharing

See more

Example of implementing database batch deletion in PHP

Related articles