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

最新推荐文章于 2021-03-27 14:31:42 发布

chaojie2009

最新推荐文章于 2021-03-27 14:31:42 发布

阅读量8.7k

点赞数 1

分类专栏： php代码分享文章标签： php class javascript list mysql sql

本文链接：https://blog.csdn.net/chaojie2009/article/details/6708335

版权

php代码分享专栏收录该内容

70 篇文章 0 订阅

订阅专栏

<?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>

//如果大家有什么不明白，可以留下你的疑问，我将尽快给予回复！

chaojie2009

关注

1
点赞
踩
2

收藏

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

<?php/** * 用户管理 * 2011/8/22 * kcj * * */include "isLogin.php";include "../conn/conn.php";$sql="select * from user";$rst=mysql_que
复制链接

扫一扫