php 分页、全选、反选、全不选、批量删除
<?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.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>
摘自 chaojie2009的专栏
PHP之友评论