一起源码网

标题: php实现数据库批量删除的实例 [打印本页]

作者: 云文章 时间: 2020-5-14 13:30
标题: php实现数据库批量删除的实例

<!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");
};
};

作者: 鹿1312 时间: 2022-10-7 19:18
网络游戏源码下载

欢迎光临一起源码网 (https://www.171739.xyz/)