51可用代码模板网站

咨询热线:

181-1164-6936
  • 1
PHP代码
当前位置:首页>实用代码>PHP代码>

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

时间:2017-08-14 11:49点击:
    <?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>  

51可用模板(代码)网站专为广大站长朋友提供精品模板与代码,同时免费提供网站收录。
本站域名: WWW.51KYDM.COM    联系方式:QQ:182468923    手机:18111646936
本站关键词:网站链接收录网址收录入口网站免费提交收录网站收录提交入口    网站地图
51可用模板
展开