PHP结合Ajax数字分页

fswdnr · 发表于 2017-3-22 09:13:12

很久都没碰程序了，在无聊中写了一个PHP与Ajax相结合仿百度的数字分页，已经足以在日常中的运用，这里只是一个简单例子的实现，在项目运用过程中需要做一些改动，至于其改动方式得看你自己了，多余的不说了。
演示地址:http://www.phpcq.com/demo/pager.php
分页代码：
<?php
//Author:www.phpcq.com
mysql_connect('localhost','root','') or die('Host error!');
mysql_select_db('test');
mysql_query('SET NAMES utf8');
$pageSize = 5;
$query = mysql_query("SELECT * FROM test ORDER BY id DESC LIMIT
$pageSize");
while($row = mysql_fetch_object($query)){
$results[] = clone $row;
}
$query = mysql_query('SELECT COUNT(*) AS count FROM test');
$count = mysql_fetch_object($query);
if('get' == $_GET['action']){
$offset = $_GET['offset'];
$size = ($offset - 1) * $pageSize;
$query = mysql_query("SELECT * FROM test ORDER BY id DESC
LIMIT $size,$pageSize");
while($row = mysql_fetch_object($query)){
      $row->count = $count->count;
      $result[] = clone $row;
}
echo json_encode($result);//数据记录
exit();
}
if('ajax' == $_GET['action']){
echo $count->count;//记录总数
exit();
}
?>
<html>
<head>
  <title> This is a digital pager's demo with PHP 、Mysql and Ajax!</title>
<script type="text/javascript" src="jquery.js"></script>
<script>
$(document).ready(function(){
$.get('pager.php',{action:'ajax'},function(data){
      var pagerString = '';
      var pageSize = 5;
      var countPage = Math.ceil(data / pageSize);
      for(i = 1;i <= countPage && 10 >= i;i++){
         if(1 == i){
            pagerString += '<a>'+i+'</a> '
         } else {
            pagerString += '<a href="javascript:void(0)" >'+i+'</a> '
         }
      }
      $('#pager').html(pagerString);
});
});
function paging(page){
$.getJSON('pager.php',{offset:page,action:'get'},function(data){
      var pagerString = '';
      var htmlContentString = ''
      var pageSize = 5;
      var countPage = Math.ceil(data[0].count / pageSize);
      $.each(data,function(i,n){
         htmlContentString += '<p>Test:'+n['test']+'</P>';
      });
      for(i = page - 9;i <= page + 9 && i <= countPage;i++){
         if(0 < i){
            if(i == page){
                  pagerString += '<a>'+i+'</a> '
            } else {
                  pagerString += '<a href="javascript:void(0)" >'+i+'</a> '
            }
         }
      }
      $('#pager').html(pagerString);
      $('#content').html(htmlContentString);
});
}
</script>
</head>
<body>
<div id="content">

   <?php foreach($results as $values):?>
      <p>Test:<?php echo $values->test;?></p>
   <?php endforeach;?>
  </div>
  <div id="pager">
  
  </div>
</body>
</html>

账号		自动登录	找回密码
密码			立即注册

c++ size_t 和 int 的区别

HERE 使用 AWS EF 和 JFrog Artifactory 打

C++ 指针大全：从基础到进阶，一篇快速上手

wirelessnetview好用的无线分析工具

Red Hat RHCE 8 (EX294) Cert Guide

亿图图示专家(EDraw Max) V7.9 中文破解版

zabbix3.4.1安装部署+微信推送信息+大屏显

[经验分享] PHP结合Ajax数字分页

浏览过的版块

扫码加入运维网微信交流群