php批量删除操作(数据访问)

时间:2021-08-09 19:39:43

本文实例为大家分享了php批量删除操作的具体代码,供大家参考,具体内容如下

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
<?php
class 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");
}

以上就是本文的全部内容,希望对大家的学习有所帮助,也希望大家多多支持服务器之家。