php数据访问-批量删除（批量操作）
1.批量删除页面 piliangcaozuo.php
1 <body> 2 <form action="shanchu.php" method="post"> 3 <table width="100%" border="1" cellpadding="0" cellspacing="0"> 4 <tr> 5 <td><input type="checkbox" name="qx" onclick="quanxuan(this)"/>代号</td> 6 <td>名称</td> 7 </tr> 8 <?php 9 require"DBDA.class1.php"; 10 $db = new DBDA(); 11 $sql = "select * from nation"; 12 $arr = $db->query($sql); 13 foreach($arr as $v) 14 { 15 echo "<tr> 16 <td><input type='checkbox' name='ck[]' class='ck' value='{$v[0]}'/>{$v[0]}</td> 17 <td>{$v[1]}</td> 18 </tr>"; 19 } 20 ?> 21 </table> 22 <input type="submit" value="批量删除" /> 23 </form> 24 </body> 25 <script type="text/javascript"> 26 function quanxuan(qx) 27 { 28 var ck=document.getElementsByClassName("ck"); 29 if(qx.checked) 30 { 31 for(var i=0;i<ck.length;i++) 32 { 33 ck[i].setAttribute("checked","checked"); 34 } 35 } 36 else 37 { 38 for(var i=0;i<ck.length;i++) 39 { 40 ck[i].removeAttribute("checked"); 41 } 42 } 43 } 44 </script> 45 </html>
引用的封装类 DBDA.class1.php
1 <?php 2 class DBDA 3 { 4 public $host = "localhost"; 5 public $uid = "root"; 6 public $pwd = "123"; 7 public $dbname = "test_123"; 8 //执行SQL语句返回相应的结果 9 //$sql 要执行的SQL语句 10 //$type 代表SQL语句的类型，0代表增删改，1代表查询 11 function query($sql,$type=1) 12 { 13 $db = new MySQLi($this->host,$this->uid,$this->pwd,$this->dbname); 14 15 $result = $db->query($sql); 16 17 if($type) 18 { 19 //如果是查询，显示数据 20 return $result->fetch_all(); 21 } 22 else 23 { 24 //如果是增删改，返回true或者false 25 return $result; 26 } 27 } 28 }
2.删除处理界面 sanchu.php
1 <?php 2 $arr = $_POST["ck"]; 3 4 require"DBDA.class.php"; 5 $db = new DBDA(); 6 //delete from nation where code in('n001','n002','n003') 7 8 $str = implode("','",$arr); 9 $sql = "delete from nation where code in('{$str}')"; 10 /*echo $sql;*/ 11 if($db->query($sql,0)) 12 { 13 header("location:piliangcaozuo.php"); 14 }
