<!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='0'";//$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>选择</t<mark style="color:transparent">来4源gaodaimacom搞#代%码*网</mark><code>搞代gaodaima码</code>d> </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='delete.php?id={$data[0]}'>删除</a> <a href='xiugai.php?id={$data[0]}'>修改</a> </td> <td><input type='checkbox' name='ids[]' value='{$data[0]}'></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['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数据库批量删除方法的详细内容，更多请关注搞代码gaodaima其它相关文章！
搞代码网（gaodaima.com）提供的所有资源部分来自互联网，如果有侵犯您的版权或其他权益，请说明详细缘由并提供版权或权益证明然后发送到邮箱[email protected]，我们会在看到邮件的第一时间内为您处理，或直接联系QQ：872152909。本网站采用BY-NC-SA协议进行授权
转载请注明原文链接：php数据库批量删除方法
转载请注明原文链接：php数据库批量删除方法
