PHP怎麼实现分页显示功能 网络上下载了很多分页显示 有代码可以参考下不 谢谢 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 如果不理解分页是什么的话,下多少代码都没有意义分页就是将待输出的内容分为若干份,每次请求时输出其中一份因此,请求的 url 至少要传递一个变量,指示要显示的哪一份(页)仅此而已 总数据 $a每页显示数据 $b$c=$a/$b 总页数当前页 $d$e=$d*$b //计算当前页加之前页数的数据条数limit $e,$b基本思路,语法查手册,如果错了大神们帮忙指正一下,菜鸟一枚 <?php include_once '../init.php'; //var_dump($_GET); if(!empty($_GET)){ $name = $_GET['name']; //echo $name; $where = "where name like '%{$name}%'"; } //分页开始 //每页的条数 $num = 8; //统计该表总共的条目 $sql = "select count(id) total from ".PRE."user"; //echo $sql; $result = mysqli_query($link,$sql); //var_dump($result); if($result && mysqli_num_rows($result)>0){ $row = mysqli_fetch_assoc($result); } //var_dump($row); //总页数 $total = $row['total']; //echo $total; //判断总共有几页 $amount = ceil($total/$num); //echo $amount; //页码?? $page = empty($_GET['page'])?'1':(int)$_GET['page']; $page = max(1,$page); $page = min($page,$amount); //偏移量 $offset = ($page-1)*$num; $sql = "select id,name,role,`lock` from ".PRE."user {$where} limit {$offset},{$num}"; //echo $sql; $result = mysqli_query($link,$sql); //var_dump($result); if($result && mysqli_num_rows($result)>0){ $userlist = array(); while($row = mysqli_fetch_assoc($result)){ $userlist[]=$row; } } //var_dump($userlist); $prev = $page -1; $next = $page + 1; /* $sql = "SELECT id,name,role,`lock` FROM sy15_user"; //echo $sql; $result = mysqli_query($link,$sql); //var_dump($result); if($result && mysqli_num_rows($result)>0){ $userlist = array(); while($row = mysqli_fetch_assoc($result)){ $userlist[] = $row; } } */ //var_dump($userlist); $i=1;?><html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8" /><title>主要内容区main</title><link href="../css/css.css" type="text/css" rel="stylesheet" /><link href="../css/main.css" type="text/css" rel="stylesheet" /><link rel="shortcut icon" href="../images/main/favicon.ico" /><style>body{overflow-x:hidden; background:#f2f0f5; padding:15px 0px 10px 5px;}#searchmain{ font-size:12px;}#search{ font-size:12px; background:#548fc9; margin:10px 10px 0 0; display:inline; width:100%; color:#FFF; float:left}#search form span{height:40px; line-height:40px; padding:0 0px 0 10px; float:left;}#search form input.text-word{height:24px; line-height:24px; width:180px; margin:8px 0 6px 0; padding:0 0px 0 10px; float:left; border:1px solid #FFF;}#search form input.text-but{height:24px; line-height:24px; width:55px; background:url(images/main/list_input.jpg) no-repeat left top; border:none; cursor:pointer; font-family:"Microsoft YaHei","Tahoma","Arial",'宋体'; color:#666; float:left; margin:8px 0 0 6px; display:inline;}#search a.add{ background:url(images/main/add.jpg) no-repeat -3px 7px #548fc9; padding:0 10px 0 26px; height:40px; line-height:40px; font-size:14px; font-weight:bold; color:#FFF; float:right}#search a:hover.add{ text-decoration:underline; color:#d2e9ff;}#main-tab{ border:1px solid #eaeaea; background:#FFF; font-size:12px;}#main-tab th{ font-size:12px; background:url(images/main/list_bg.jpg) repeat-x; height:32px; line-height:32px;}#main-tab td{ font-size:12px; line-height:40px;}#main-tab td a{ font-size:12px; color:#548fc9;}#main-tab td a:hover{color:#565656; text-decoration:underline;}.bordertop{ border-top:1px solid #ebebeb}.borderright{ border-right:1px solid #ebebeb}.borderbottom{ border-bottom:1px solid #ebebeb}.borderleft{ border-left:1px solid #ebebeb}.gray{ color:#dbdbdb;}td.fenye{ padding:10px 0 0 0; text-align:right;}.bggray{ background:#f9f9f9}</style></head><body><!--main_top--><table width="99%" border="0" cellspacing="0" cellpadding="0" id="searchmain"> <tr> <td width="99%" align="left" valign="top">您的位置:用户管理</td> </tr> <tr> <td align="left" valign="top"> <table width="100%" border="0" cellspacing="0" cellpadding="0" id="search"> <tr> <td width="90%" align="left" valign="middle"> <form method="get" action="./index.php"> <span>管理员:</span> <input type="text" name="name" value="" class="text-word"> <input name="" type="submit" value="查询" class="text-but"> </form> </td> <td width="10%" align="center" valign="middle" style="text-align:right; width:150px;"><a href="add.html" target="mainFrame" onFocus="this.blur()" class="add">新增管理员</a></td> </tr> </table> </td> </tr> <tr> <td align="left" valign="top"> <table width="100%" border="0" cellspacing="0" cellpadding="0" id="main-tab"> <tr> <th align="center" valign="middle" class="borderright">编号</th> <th align="center" valign="middle" class="borderright">管理帐号</th> <th align="center" valign="middle" class="borderright">权限</th> <th align="center" valign="middle" class="borderright">锁定</th> <th align="center" valign="middle">操作</th> </tr> <?php foreach($userlist as $value){?> <tr onMouseOut="this.style.backgroundColor='#ffffff'" onMouseOver="this.style.backgroundColor='#edf5ff'"> <td align="center" valign="middle" class="borderright borderbottom"><?php echo $offset+$i++ ?></td> <td align="center" valign="middle" class="borderright borderbottom"><?php echo $value['name']?></td> <td align="center" valign="middle" class="borderright borderbottom"> <?php switch($value['role']){ case 0: echo "普通用户"; break; case 1: echo "管理员"; break; case 2: echo "超级管理员"; break; } ?></td> <td align="center" valign="middle" class="borderright borderbottom"><?php echo $value['lock']?'<a href="./action.php?a=lock&id='.$value['id'].'&lock=0">锁定</a>':'<a href="./action.php?a=lock&id='.$value['id'].'&lock=1">未锁定</a>'?></td> <td align="center" valign="middle" class="borderbottom"><a href="./edit.php?id=<?php echo $i-1;?>&name=<?php echo $value['name']?>&role=<?php echo $value['role'];?>" target="mainFrame" onFocus="this.blur()" class="add">编辑</a><span class="gray"> | </span><a href="action.php?a=del&name=<?php echo $value['name']?>" target="mainFrame" onFocus="this.blur()" class="add">删除</a></td> </tr> <?php }?> </table></td> </tr> <tr> <td align="left" valign="top" class="fenye"><?php echo $total?>条数据 <?php echo $page?>/<?php echo $amount?>页 <a href="index.php?page=1" target="mainFrame" onFocus="this.blur()">首页</a> <a href="index.php?page=<?php echo $prev?>" target="mainFrame" onFocus="this.blur()">上一页</a> <a href="index.php?page=<?php echo $next?>" target="mainFrame" onFocus="this.blur()">下一页</a> <a href="index.php?page=<?php echo $amount ?>" target="mainFrame" onFocus="this.blur()">尾页</a></td> </tr></table></body></html>这是我做的项目其中一个用户表遍历的分页 请求高手解决(怎么把这样的数组转换为JSON) 跪求 wso2-wsf/php解释不了https mysql 自增加分区 XAMPP安装出现错误 简单的正则问题,高分求解 请问php的web服务器怎么配置, httpd.conf 装了ZEND后怎么 PHP.INI中的上传大小修改不起作用 如何配置apache服务器 file_get_contents()函数读取文件内容不全是什么原因呢? PHP书籍 thinkphp 是关于分页问题的。 自动登录
分页就是将待输出的内容分为若干份,每次请求时输出其中一份
因此,请求的 url 至少要传递一个变量,指示要显示的哪一份(页)
仅此而已
每页显示数据 $b
$c=$a/$b 总页数
当前页 $d$e=$d*$b //计算当前页加之前页数的数据条数
limit $e,$b
基本思路,语法查手册,如果错了大神们帮忙指正一下,菜鸟一枚
include_once '../init.php';
//var_dump($_GET);
if(!empty($_GET)){
$name = $_GET['name'];
//echo $name;
$where = "where name like '%{$name}%'";
}
//分页开始
//每页的条数
$num = 8;
//统计该表总共的条目
$sql = "select count(id) total from ".PRE."user";
//echo $sql;
$result = mysqli_query($link,$sql);
//var_dump($result);
if($result && mysqli_num_rows($result)>0){
$row = mysqli_fetch_assoc($result);
}
//var_dump($row);
//总页数
$total = $row['total'];
//echo $total;
//判断总共有几页
$amount = ceil($total/$num);
//echo $amount;
//页码??
$page = empty($_GET['page'])?'1':(int)$_GET['page'];
$page = max(1,$page);
$page = min($page,$amount);
//偏移量
$offset = ($page-1)*$num;
$sql = "select id,name,role,`lock` from ".PRE."user {$where} limit {$offset},{$num}";
//echo $sql;
$result = mysqli_query($link,$sql);
//var_dump($result);
if($result && mysqli_num_rows($result)>0){
$userlist = array();
while($row = mysqli_fetch_assoc($result)){
$userlist[]=$row;
}
}
//var_dump($userlist);
$prev = $page -1;
$next = $page + 1;
/* $sql = "SELECT id,name,role,`lock` FROM sy15_user";
//echo $sql;
$result = mysqli_query($link,$sql);
//var_dump($result);
if($result && mysqli_num_rows($result)>0){
$userlist = array();
while($row = mysqli_fetch_assoc($result)){
$userlist[] = $row;
}
} */
//var_dump($userlist);
$i=1;
?><html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>主要内容区main</title>
<link href="../css/css.css" type="text/css" rel="stylesheet" />
<link href="../css/main.css" type="text/css" rel="stylesheet" />
<link rel="shortcut icon" href="../images/main/favicon.ico" />
<style>
body{overflow-x:hidden; background:#f2f0f5; padding:15px 0px 10px 5px;}
#searchmain{ font-size:12px;}
#search{ font-size:12px; background:#548fc9; margin:10px 10px 0 0; display:inline; width:100%; color:#FFF; float:left}
#search form span{height:40px; line-height:40px; padding:0 0px 0 10px; float:left;}
#search form input.text-word{height:24px; line-height:24px; width:180px; margin:8px 0 6px 0; padding:0 0px 0 10px; float:left; border:1px solid #FFF;}
#search form input.text-but{height:24px; line-height:24px; width:55px; background:url(images/main/list_input.jpg) no-repeat left top; border:none; cursor:pointer; font-family:"Microsoft YaHei","Tahoma","Arial",'宋体'; color:#666; float:left; margin:8px 0 0 6px; display:inline;}
#search a.add{ background:url(images/main/add.jpg) no-repeat -3px 7px #548fc9; padding:0 10px 0 26px; height:40px; line-height:40px; font-size:14px; font-weight:bold; color:#FFF; float:right}
#search a:hover.add{ text-decoration:underline; color:#d2e9ff;}
#main-tab{ border:1px solid #eaeaea; background:#FFF; font-size:12px;}
#main-tab th{ font-size:12px; background:url(images/main/list_bg.jpg) repeat-x; height:32px; line-height:32px;}
#main-tab td{ font-size:12px; line-height:40px;}
#main-tab td a{ font-size:12px; color:#548fc9;}
#main-tab td a:hover{color:#565656; text-decoration:underline;}
.bordertop{ border-top:1px solid #ebebeb}
.borderright{ border-right:1px solid #ebebeb}
.borderbottom{ border-bottom:1px solid #ebebeb}
.borderleft{ border-left:1px solid #ebebeb}
.gray{ color:#dbdbdb;}
td.fenye{ padding:10px 0 0 0; text-align:right;}
.bggray{ background:#f9f9f9}
</style>
</head>
<body>
<!--main_top-->
<table width="99%" border="0" cellspacing="0" cellpadding="0" id="searchmain">
<tr>
<td width="99%" align="left" valign="top">您的位置:用户管理</td>
</tr>
<tr>
<td align="left" valign="top">
<table width="100%" border="0" cellspacing="0" cellpadding="0" id="search">
<tr>
<td width="90%" align="left" valign="middle">
<form method="get" action="./index.php">
<span>管理员:</span>
<input type="text" name="name" value="" class="text-word">
<input name="" type="submit" value="查询" class="text-but">
</form>
</td>
<td width="10%" align="center" valign="middle" style="text-align:right; width:150px;"><a href="add.html" target="mainFrame" onFocus="this.blur()" class="add">新增管理员</a></td>
</tr>
</table>
</td>
</tr>
<tr>
<td align="left" valign="top">
<table width="100%" border="0" cellspacing="0" cellpadding="0" id="main-tab">
<tr>
<th align="center" valign="middle" class="borderright">编号</th>
<th align="center" valign="middle" class="borderright">管理帐号</th>
<th align="center" valign="middle" class="borderright">权限</th>
<th align="center" valign="middle" class="borderright">锁定</th>
<th align="center" valign="middle">操作</th>
</tr>
<?php foreach($userlist as $value){?>
<tr onMouseOut="this.style.backgroundColor='#ffffff'" onMouseOver="this.style.backgroundColor='#edf5ff'">
<td align="center" valign="middle" class="borderright borderbottom"><?php echo $offset+$i++ ?></td>
<td align="center" valign="middle" class="borderright borderbottom"><?php echo $value['name']?></td>
<td align="center" valign="middle" class="borderright borderbottom">
<?php
switch($value['role']){
case 0:
echo "普通用户";
break;
case 1:
echo "管理员";
break;
case 2:
echo "超级管理员";
break;
}
?></td>
<td align="center" valign="middle" class="borderright borderbottom"><?php echo $value['lock']?'<a href="./action.php?a=lock&id='.$value['id'].'&lock=0">锁定</a>':'<a href="./action.php?a=lock&id='.$value['id'].'&lock=1">未锁定</a>'?></td>
<td align="center" valign="middle" class="borderbottom"><a href="./edit.php?id=<?php echo $i-1;?>&name=<?php echo $value['name']?>&role=<?php echo $value['role'];?>" target="mainFrame" onFocus="this.blur()" class="add">编辑</a><span class="gray"> | </span><a href="action.php?a=del&name=<?php echo $value['name']?>" target="mainFrame" onFocus="this.blur()" class="add">删除</a></td>
</tr>
<?php }?>
</table></td>
</tr>
<tr>
<td align="left" valign="top" class="fenye"><?php echo $total?>条数据 <?php echo $page?>/<?php echo $amount?>页 <a href="index.php?page=1" target="mainFrame" onFocus="this.blur()">首页</a> <a href="index.php?page=<?php echo $prev?>" target="mainFrame" onFocus="this.blur()">上一页</a> <a href="index.php?page=<?php echo $next?>" target="mainFrame" onFocus="this.blur()">下一页</a> <a href="index.php?page=<?php echo $amount ?>" target="mainFrame" onFocus="this.blur()">尾页</a></td>
</tr>
</table>
</body>
</html>这是我做的项目其中一个用户表遍历的分页