php 分页、全选、反选、全不选、批量删除

小画家~

于 2015-08-04 10:10:50 发布

阅读量1k

点赞数

分类专栏： PHP 错误问题

PHP 错误问题专栏收录该内容

7 篇文章 0 订阅

订阅专栏

php 多选删除

SQL：$SQL="delete from `doing` where id in ('1,2,3,4')"; 
数据用逗号隔开。 
表单： 
<form action="?action=doing" method="post"> 
<input name="ID_Dele[]" type="checkbox" id="ID_Dele[]" value="1"/> 
<input name="ID_Dele[]" type="checkbox" id="ID_Dele[]" value="2"/> 
<input name="ID_Dele[]" type="checkbox" id="ID_Dele[]" value="3"/> 
<input name="ID_Dele[]" type="checkbox" id="ID_Dele[]" value="4"/> 
<input type="submit"/> 
</form> 
好$ID_Dele=$_POST['ID_Dele']将会是一个数组，虽然说<a target=_blank href="http://www.2cto.com/kf/web/php/" target="_blank" class="keylink">PHP</a>是弱类型的，但这里可没ASP弱。 
ASP可以直接： 
SQL="delete from [doing] where id in ('"&ID_Dele&"')"进行删除。但PHP不能把$ID_Dele直接放进去。因为$ID_Dele可不是'1,2,3,4'哦，因为$ID_Dele是一个数组，具有键和值。 
好，PHP中也不难，刚好有个函数：implode()，对了。同split()\explode()功能刚好相反的一个函数，后两者是用某字符（比如逗号）分割的，而前者则可以拼接为字符串。 
因此： 
$ID_Dele= implode(",",$_POST['ID_Dele']); 
$SQL="delete from `doing` where id in ($ID_Dele)";

<a target=_blank href="http://www.2cto.com/kf/201202/120451.html">http://www.2cto.com/kf/201202/120451.html</a>

<?php 
/**
 * 用户管理
 * 2011/8/22
 * kcj
 * 
 * */ 
include "isLogin.php"; 
include "../conn/conn.php"; 
$sql="select * from user"; 
$rst=mysql_query($sql); 
$totalnum=mysql_num_rows($rst); 
$pagesize=5; 
$page=$_GET['page']; 
if($page==''){ 
    $page=1; 
} 
$begin=($page-1)*$pagesize; 
$pagecount=ceil($totalnum/$pagesize); 
?> 
 
 
<html> 
    <head> 
        <meta http-equiv="Content-Type" content="text/html; charset=gb2312" /> 
        <title>无标题文档</title> 
        <meta name="Author" content="kcj" /> 
        <meta name="Keywords" content="php,kcj" /> 
        <link rel="stylesheet" type="text/css" href="style/lampcms.css"> 
        <script src="javascript/common0.js"></script> 
        <script type="text/javascript"> 
          var checkall=document.getElementsByName("dell[]"); 
            function select(){                          //全选  
                for(var $i=0;$i<checkall.length;$i++){ 
                    checkall[$i].checked=true; 
                } 
            } 
            function fanselect(){                        //反选  
                for(var $i=0;$i<checkall.length;$i++){ 
                    if(checkall[$i].checked){ 
                        checkall[$i].checked=false; 
                    }else{ 
                        checkall[$i].checked=true; 
                    } 
                } 
            }          
            function noselect(){                          //全不选  
                for(var $i=0;$i<checkall.length;$i++){ 
                    checkall[$i].checked=false; 
                } 
            } 
         
        </script> 
         
         
    </head> 
    <body> 
        <div id="main"> 
            后台管理->管理用户 
            <form  method="post" action="" οnsubmit="return confirm('你确定要删除选中项吗?')"  > 
            <div class="msg-box"> 
                <ul class="viewmess"> 
                    <li class="dark-row"> 
                        <span class="list_width width_font">用户名</span> 
                        <span class="list_width width_font" style="width:200px">备注名</span> 
                        <span class="list_width width_font">注册时间</span> 
                        <span class="list_width width_font">操  作</span> 
                    </li> 
                         <?php 
                          
                         if(isset($_POST['dell'])){       //批量删除  
                            $ids=$_POST['dell']; 
                            $ids=implode(",", $ids);   //implode函数 把数组元素组合为一个字符串。  
                            $sql="delete from user where id in ($ids)"; 
                            mysql_query($sql); 
                         } 
                          
                         if(isset($_GET['del'])){ 
                            $id=$_GET['del']; 
                            $sql="delete from user where id=".$id; 
                            mysql_query($sql); 
                         } 
                          
                          
                         $sql="select * from user order by id limit $begin,$pagesize"; 
                         $rst=mysql_query($sql); 
                         while ($row=mysql_fetch_array($rst)){ 
                          
                         ?> 
                        <li class="light-row" style="padding-top:2px; padding-bottom:2px"> 
                             
                         
                    <span class="list_width" style="width:200px"><?php if($row['id']!=1){?><input type="checkbox" name="dell[]"  value="<?php echo $row['id']?>">   <?php }?> 
                            <?php echo $row['username']?></span> 
                            <span class="list_width"><?php echo $row['rname']?></span> 
                             <span class="list_width"><?php echo substr($row['ctime'],0,10)?></span> 
                            <span class="list_width" style="width:160px;"> 
                         
                            【<a href="editUser.php?edit=<?php echo $row['id']?>">修改</a>】 
                          <?php if($row['id']!=1){?> 
                            【<a οnclick="return confirm('确定要删除用户<?php echo $row['username']?>吗？')" href="listUser.php?del=<?php echo $row['id']?>">删除</a>】 
                            <?php 
                         } 
                            ?> 
                            </span> 
                        <?php  
                         } 
                        ?> 
                     
                         
                     
                    <li class="dark-row"> 
                        <span class="col_width" style="margin-left:15px;width:240px">  
                            <a href="javascript:select()">全选</a>/<a href="javascript:fanselect()">反选</a>/<a href="javascript:noselect()">全不选</a>  选中项:  
                             
                            <input  name="dels" type="image" title="删除" value="delete" src="images/delete.gif">   
                         </span> 
                        <span class="right"> 
                            共 <b><?php echo $totalnum?></b> 个用户,共<?php echo $pagecount;?>页 
                            <a href="<?php echo $_SERVER['PHP_SELF']."?page=1"?>">首页</a> 
       
                            <a href="<?php echo $_SERVER['PHP_SELF']?>?page=<?php if($page<1) echo $page-1;else echo $page=1;?>">上一页</a> 
                            <?php 
                            for($i=1;$i<=$pagecount;$i++){    //$i<=$pagecount(必须是<=)  
                                echo "<a href=".$_SERVER['PHP_SELF']."?page=$i".">[".$i."]</a>"; 
                            } 
                             
                            ?> 
                            <a href="<?php echo $_SERVER['PHP_SELF']?>?page=<?PHP if($page<$pagecount-1) echo $page+1; else echo $pagecount;?>">下一页</a> 
                            <a href="<?php echo $_SERVER['PHP_SELF']."?page={$pagecount}"?>">尾页</a> 
                        </span> 
                    </li> 
                </ul>  
            </div> 
                    </form> 
        </div> 
    </body> 
</html> 
<?php
/**
 * 用户管理
 * 2011/8/22
 * kcj
 *
 * */
include "isLogin.php";
include "../conn/conn.php";
$sql="select * from user";
$rst=mysql_query($sql);
$totalnum=mysql_num_rows($rst);
$pagesize=5;
$page=$_GET['page'];
if($page==''){
 $page=1;
}
$begin=($page-1)*$pagesize;
$pagecount=ceil($totalnum/$pagesize);
?>


<html>
 <head>
  <meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
  <title>无标题文档</title>
  <meta name="Author" content="kcj" />
  <meta name="Keywords" content="php,kcj" />
  <link rel="stylesheet" type="text/css" href="style/lampcms.css">
  <script src="javascript/common0.js"></script>
  <script type="text/javascript">
    var checkall=document.getElementsByName("dell[]");
      function select(){                          //全选
       for(var $i=0;$i<checkall.length;$i++){
        checkall[$i].checked=true;
       }
      }
      function fanselect(){                        //反选
       for(var $i=0;$i<checkall.length;$i++){
        if(checkall[$i].checked){
         checkall[$i].checked=false;
        }else{
         checkall[$i].checked=true;
        }
       }
      }        
      function noselect(){                          //全不选
       for(var $i=0;$i<checkall.length;$i++){
        checkall[$i].checked=false;
       }
      }
  
  </script>
  
  
 </head>
 <body>
  <div id="main">
      后台管理->管理用户
      <form  method="post" action="" οnsubmit="return confirm('你确定要删除选中项吗?')"  >
   <div class="msg-box">
    <ul class="viewmess">
     <li class="dark-row">
      <span class="list_width width_font">用户名</span>
      <span class="list_width width_font" style="width:200px">备注名</span>
      <span class="list_width width_font">注册时间</span>
      <span class="list_width width_font">操  作</span>
     </li>
             <?php
            
             if(isset($_POST['dell'])){       //批量删除
                $ids=$_POST['dell'];
              $ids=implode(",", $ids);   //implode函数 把数组元素组合为一个字符串。
              $sql="delete from user where id in ($ids)";
              mysql_query($sql);
             }
            
             if(isset($_GET['del'])){
              $id=$_GET['del'];
              $sql="delete from user where id=".$id;
              mysql_query($sql);
             }
            
            
             $sql="select * from user order by id limit $begin,$pagesize";
             $rst=mysql_query($sql);
             while ($row=mysql_fetch_array($rst)){
            
             ?>
      <li class="light-row" style="padding-top:2px; padding-bottom:2px">
       
      
     <span class="list_width" style="width:200px"><?php if($row['id']!=1){?><input type="checkbox" name="dell[]"  value="<?php echo $row['id']?>"> <?php }?>
       <?php echo $row['username']?></span>
       <span class="list_width"><?php echo $row['rname']?></span>
                 <span class="list_width"><?php echo substr($row['ctime'],0,10)?></span>
       <span class="list_width" style="width:160px;">
      
       【<a href="editUser.php?edit=<?php echo $row['id']?>">修改</a>】
        <?php if($row['id']!=1){?>
       【<a οnclick="return confirm('确定要删除用户<?php echo $row['username']?>吗？')" href="listUser.php?del=<?php echo $row['id']?>">删除</a>】
       <?php
             }
       ?>
       </span>
      <?php
             }
      ?>
     
      
     
     <li class="dark-row">
      <span class="col_width" style="margin-left:15px;width:240px">
       <a href="javascript:select()">全选</a>/<a href="javascript:fanselect()">反选</a>/<a href="javascript:noselect()">全不选</a>  选中项:
       
       <input  name="dels" type="image" title="删除" value="delete" src="images/delete.gif"> 
       </span>
      <span class="right">
       共 <b><?php echo $totalnum?></b> 个用户,共<?php echo $pagecount;?>页
       <a href="<?php echo $_SERVER['PHP_SELF']."?page=1"?>">首页</a>
  
       <a href="<?php echo $_SERVER['PHP_SELF']?>?page=<?php if($page<1) echo $page-1;else echo $page=1;?>">上一页</a>
       <?php
       for($i=1;$i<=$pagecount;$i++){    //$i<=$pagecount(必须是<=)
        echo "<a href=".$_SERVER['PHP_SELF']."?page=$i".">[".$i."]</a>";
       }
       
       ?>
       <a href="<?php echo $_SERVER['PHP_SELF']?>?page=<?PHP if($page<$pagecount-1) echo $page+1; else echo $pagecount;?>">www.2cto.com 下一页</a>
       <a href="<?php echo $_SERVER['PHP_SELF']."?page={$pagecount}"?>">尾页</a>
      </span>
     </li>
    </ul> 
   </div>
                    </form>
  </div>
 </body>
</html>[php] //<strong><span style="font-size:18px;">如果大家有什么不明白，可以留下你的疑问，我将尽快给予回复！</span></strong>

小画家~

关注

0
点赞
踩
2

收藏

觉得还不错? 一键收藏
0
评论
php 分页、全选、反选、全不选、批量删除

php 多选删除SQL：$SQL="delete from `doing` where id in ('1,2,3,4')"; 数据用逗号隔开。表单：好$ID_Dele=$_POST['ID_Dele']将会是一个数组，虽然说PHP是弱类型的，但这里可没ASP弱。 ASP可以直接： SQL="delete from [doi
复制链接

扫一扫

专栏目录