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

Title

= Mysqli("localhost","root","root","db_0808"(())?"":("链接错误" = "select * from student where is_delete='0'"?>

id

名字

性别

班级

生日

操作

选择

=->query( (=->

([2]==1[2]="男" ([2]==0[2]="女"[2]="保密" ""?>

新增用户

/**

* 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");

};

};