本文实例为大家分享了php批量删除操作的具体代码，供大家参考，具体内容如下
1.批量删除页面 piliangcaozuo.php
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
|
<body><form action="shanchu.php" method="post"><table width="100%" border="1" cellpadding="0" cellspacing="0"> <tr> <td><input type="checkbox" name="qx" onclick="quanxuan(this)"/>代号</td> <td>名称</td> </tr> <?php require"dbda.class1.php"; $db = new dbda(); $sql = "select * from nation"; $arr = $db->query($sql); foreach($arr as $v) { echo "<tr> <td><input type='checkbox' name='ck[]' class='ck' value='{$v[0]}'/>{$v[0]}</td> <td>{$v[1]}</td> </tr>"; } ?> </table><input type="submit" value="批量删除" /></form></body><script type="text/javascript">function quanxuan(qx){ var ck=document.getelementsbyclassname("ck"); if(qx.checked) { for(var i=0;i<ck.length;i++) { ck[i].setattribute("checked","checked"); } } else { for(var i=0;i<ck.length;i++) { ck[i].removeattribute("checked"); } }}</script></html> |
引用的封装类 dbda.class1.php
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
|
<?phpclass dbda{ public $host = "localhost"; public $uid = "root"; public $pwd = "123"; public $dbname = "test_123"; //执行sql语句返回相应的结果 //$sql 要执行的sql语句 //$type 代表sql语句的类型，0代表增删改，1代表查询 function query($sql,$type=1) { $db = new mysqli($this->host,$this->uid,$this->pwd,$this->dbname); $result = $db->query($sql); if($type) { //如果是查询，显示数据 return $result->fetch_all(); } else { //如果是增删改，返回true或者false return $result; } }} |
2.删除处理界面 sanchu.php
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
|
<?php$arr = $_post["ck"];require"dbda.class.php";$db = new dbda();//delete from nation where code in('n001','n002','n003')$str = implode("','",$arr); $sql = "delete from nation where code in('{$str}')";/*echo $sql;*/if($db->query($sql,0)){ header("location:piliangcaozuo.php");} |
以上就是本文的全部内容，希望对大家的学习有所帮助，也希望大家多多支持服务器之家。
