php实现数据库批量删除的实例

黄舟原创: 2023-03-16 17:54:02 2111浏览

<!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='0'"?>
<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['ids'];
 $db=new Mysqli("localhost","root","root","db_0808");
 empty(mysqli_connect_error())?"":die("链接错误");
 //$sql="DELETE FROM student WHERE Sno='{$id}'";
 //彻底删除
 foreach ($ids as $i){$sql = "update student set is_delete = '1' where Sno= '{$i}'";
 //表面删除
 if ($db->query($sql)){    
 header("location:CURD.php");
};
};

以上就是php实现数据库批量删除的实例的详细内容，更多请关注php中文网其它相关文章！

php 数据库实例 PHP课程 HTML视频教程 CSS视频 JS视频教程 Vue视频教程

声明：本文内容由网友自发贡献，版权归原作者所有，本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容，请联系admin@php.cn核实处理。

上一条：php之curl get post请求用法实例分享下一条：TP5实战项目中QQ第三方登录功能的实现案例分享