百度分页函数的实现

Posted on 2015-05-27 00:28  小蕊同学  阅读(320)  评论(0)    收藏  举报
$recordcount=$rs[0];//共14条记录
$pagesize=1;//每页2条记录
$pagecount=ceil($recordcount/$pagesize);//总共有几页
$currpage=isset($_GET['p']) ? $_GET['p']:1;//显示当前页

调用函数
  1. <?php include 'inc/db_mysqli.php';?>
  2. <!doctype html>
  3. <html>
  4. <head>
  5. <meta charset="utf-8">
  6. <title>webrx-php</title>
  7. <?php css1();?>  //引用样式
  8. </head>
  10. <body>
  11. <?php
  12. $p = isset($_GET['p']) ? $_GET['p'] : 1;
  13. //(表明，2表示一页显示几行内容，mname字段名，$p表示当前页)
  14. $rs = pager('member',$p,'mname,maccount',2);
  15. $m->close();
  16. echo $rs[1];
  17. foreach($rs[0] as $v){
  18.     echo $v[0].'<br>';	
  19. }
  20. echo $rs[1];
  21. ?>
  22. </body>
  23. </html>

实现分页的函数
  1. <?php
  2. $host = 'localhost';
  3. $user = 'root';
  4. $pass = '';
  5. $dbname = 'db';
  6. $charset = 'utf8';
  7. $m = new mysqli($host,$user,$pass,$dbname);
  8. $m->set_charset($charset);
  10. function pager($tn,$currpage=1,$f='*',$pagesize=3,$w='1=1'){
  11. 	global $m;
  12. 	$stmt = $m->prepare("select count(*) from $tn where $w");
  13. 	$stmt->execute();
  14. 	$stmt->bind_result($recordcount);
  15. 	$stmt->fetch();
  16. 	$stmt->free_result();
  17. 	$stmt->close();
  18. 	
  19. 	$stmt = $m->prepare("select $f from $tn where $w limit ?,?");
  20. 	$pagecount = ceil($recordcount/$pagesize);
  21. 	$start = $currpage*$pagesize - $pagesize;
  22. 	$stmt->bind_param('ii',$start,$pagesize);
  23. 	$stmt->execute();
  24. 	$result = $stmt->get_result();
  25. 	$row = array();
  26. 	$row[] = $result->fetch_all( MYSQLI_NUM);
  27. 	$stmt->free_result();
  28. 	$stmt->close();
  30. 	$first = 1;
  31. 	$end = 10;
  32. 	$pages = '<div class="page">';
  33. 	if($currpage>=7){
  34.     	$first = $currpage-5;
  35. 		$end = $first+$end-1;
  36. 	}
  37. 	if($currpage>1){
  38. 		$prev = $currpage-1;
  39. 		if($first>1){
  40. 			$pages.="<a href=?p=1>首页</a><a href=?p=$prev>上一页</a>";
  41. 		}else{
  42. 			$pages.="<a href=?p=$prev>上一页</a>";			
  43. 		}
  44. 	}
  45. 	for($i=$first;$i<=$end;$i++){
  46. 		if($i>$pagecount){
  47. 	    	break;	
  48. 		}
  49. 		if($i==$currpage){
  50. 	    	$pages.='<a class="checked">'.$i.'</a>';
  51. 			continue;	
  52. 		}
  53.         $pages.="<a href=?p=$i>$i</a>";
  54. 	}
  55. 	if($currpage<$pagecount){
  56. 		$next = $currpage+1;
  57. 		$pages.="<a href=?p=$next>下一页</a>";		
  58. 	}
  59. 	if($end<$pagecount){
  60. 		$pages.="<a href=?p=$pagecount>尾页</a>";
  61. 	}
  62. 	$row[] = $pages.'</div>';
  63. 	$row[] = $pagesize;
  64. 	$row[] = $pagecount;
  65. 	$row[] = $recordcount;
  66. 	$row[] = $currpage;
  67. 	return $row;
  68. }
  70. function css1(){
  71.     $css = <<<css
  72. 	<style>
  73. 	.page{font-size:12px;height:30px;padding:15px 0;clear:both;overflow:hidden;text-align:center;}
  74. 	.page a{text-decoration:none;line-height:25px;padding:0px 10px;display:inline-block;margin-right:5px;border:solid 1px #c8c7c7;}
  75. 	.page a:hover,.page a.checked{text-decoration:none;border:solid 1px #0086d6;background:#0091e3;color:#fff;}
  76. 	.page a:visited,.page a:link{color:#333;}
  77. 	.page a:active{color:#3B3B3B;}
  78. 	</style>
  79. css;
  80.     echo $css;		
  81. }





博客园  ©  2004-2025
浙公网安备 33010602011771号 浙ICP备2021040463号-3