<!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");};};Start building with 50+ products and up to 12 months usage for Elastic Compute Service
1 on 1 presale consultation
24/7 Technical Support 6 Free Tickets per Quarter Faster Response
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.
A comprehensive suite of global cloud computing services to power your business
Payment Methods We Support
