冒险村物语
英雄无敌3塔防
驾考家园手游

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

2014-09-05

<?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="" onsubmit="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 onclick="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="" onsubmit="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 onclick="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.zhishiwu.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>