php+ajax实现无刷新分页

2020-03-22 16:31:29

字体：大中小

来源：转载

供稿：网友

本文实例讲述了php+ajax实现无刷新分页实现方法。分享给大家供大家参考。具体如下： limit 偏移量，长度;
limit 0,7; 第一页
limit 7,7; 第二页
limit 14,7; 第三页
每页信息条数：7
信息总条数：select count(*) from table
信息总页数：ceil向上取整(总条数/每页条数)
1、分页类具体使用
html' target='_blank'>class Pagination { private $total; //数据表中总记录数 private $listRows; //每页显示行数 private $limit; //mysql 数据库的limit private $uri; //分页信息前面的uri地址 private $pageNum; //页数 private $config = array('header' = "个记录", "prev" = "【上一页】", "next" = "【下一页】", "first" = "【首页】", "last" = "【尾页】"); private $listNum = 8; * $total 当前信息总条数 * $listRows 每页显示的条数 * $pa 下面的page http://网址/index.php page=5 public function __construct($total, $listRows = 10, $pa = "") { $this- total = $total; $this- listRows = $listRows; $this- uri = $this- getUri($pa); $this- page = !empty($_GET["page"]) $_GET["page"] : 1;//不传入page，则默认显示首页 $this- pageNum = ceil($this- total / $this- listRows); $this- limit = $this- setLimit(); //设置每页显示的条数 private function setLimit() { return "Limit " . ($this- page - 1) * $this- listRows . ", {$this- listRows}"; //获得URL地址 private function getUri($pa) { $url = $_SERVER["REQUEST_URI"] . (strpos($_SERVER["REQUEST_URI"], ' ') '' : " ") . $pa; $parse = parse_url($url);
$html.=" a href='javascript:void(0)' {$this- config["first"]} /a "; //$html.=" a href='{$this- uri}&page=1' {$this- config["first"]} /a "; return $html; /*设置上一页*/ private function prev() { $html = ""; if ($this- page == 1) $html.=''.$this- config["prev"].''; else $html.=" a href='javascript:void(0)' {$this- config["prev"]} /a "; //$html.=" a href='{$this- uri}&page=".($this- page-1)."' {$this- config["prev"]} /a "; return $html; //页码列表【首页】【2】【3】…………【尾页】 private function pageList() { $linkPage = ""; $inum = floor($this- listNum / 2); for ($i = $inum; $i $i--) { $page = $this- page - $i; if ($page 1) continue; $linkPage.=" a href='javascript:void(0)' {$page} /a "; $linkPage.="{$this- page}";
if ($page = $this- pageNum) $linkPage.=" a href='javascript:void(0)' {$page} /a "; else break; return $linkPage; /*设置下一页*/ private function next() { $html = ""; if ($this- page == $this- pageNum) $html.=''.$this- config["next"].''; else $html.=" a href='javascript:void(0)' {$this- config["next"]} /a "; //$html.=" a href='{$this- uri}&page=".($this- page + 1)."' {$this- config["next"]} /a "; return $html; /*设置尾页*/ private function last() { $html = ""; if ($this- page == $this- pageNum) $html.=''.$this- config["last"].''; else $html.=" a href='javascript:void(0)' {$this- config["last"]} /a "; //$html.=" a href='{$this- uri}&page=.(this- pageNum).' {$this- config["last"]} /a "; return $html; /*设置页面跳转*/ private function goPage() { return ' input type="text" value="' . $this- page . '" input type="button" value="GO" '; //页面列表配置选项 function fpage($display = array(0, 1, 2, 3, 4, 5, 6, 7, 8)) { $html[0] = "共有 b {$this- total} /b {$this- config["header"]}"; $html[1] = "每页显示 b " . ($this- end() - $this- start() + 1) . " /b 条，本页 b {$this- start()}-{$this- end()} /b 条"; $html[2] = " b {$this- page}/{$this- pageNum} /b 页"; $html[3] = $this- first(); $html[4] = $this- prev(); $html[5] = $this- pageList(); $html[6] = $this- next(); $html[7] = $this- last(); $html[8] = $this- goPage(); $fpage = ''; foreach ($display as $index) { $fpage.=$html[$index]; return $fpage;2 数据显示//链接数据库//获得具体信息//分页显示header("content-type:text/html;charset=utf-8");$link = mysql_connect('localhost','root','111111');mysql_select_db('shop', $link);mysql_query("set names utf8");$css = eof style type="text/css" table {border:1px solid black; width:700px; margin:auto; border-collapse:collapse;} td {border:1px solid black; } /style echo $css;echo " table tr td 序号 /td td 名称 /td td 数量 /td td 价格 /td td 时间 /td /tr //1 引入分页类include "./Pagination.php";//2. 获得信息总条数$sql = "select * from sw_goods";$qry = mysql_query($sql);$total = mysql_num_rows($qry);$per = 7;//3. 实例化分页类对象$page_obj = new Pagination($total,$per);//4. 拼装sql语句，获得每页信息//利用page_obj实现limit的灵活设置//$page_obj - limit;$sqla = "select * from sw_goods ".$page_obj- limit;$qrya = mysql_query($sqla);//5. 获得页面列表$pagelist = $page_obj - fpage(array(3,4,5,6,7,8));$i=1;while($rsta = mysql_fetch_assoc($qrya)){ echo " tr echo " td ".$i++." /td echo " td ".$rsta['goods_name']." /td echo " td ".$rsta['goods_number']." /td echo " td ".$rsta['goods_price']." /td echo " td ".date("Y-m-d H:i:s",$rsta['goods_create_time'])." /td echo " /tr echo " tr td colspan=5 ".$pagelist." /td /tr echo " /table 3 ajax无刷新分页实现open(‘get','http://网址/index.php page=2')
!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd" html head title 新建网页 /title meta http-equiv="Content-Type" content="text/html; charset=utf-8" / meta name="description" content="" / meta name="keywords" content="" / script type="text/javascript" //获得分页信息ajax函数function showPage(myurl){ var xhr = new XMLHttpRequest(); xhr.onreadystatechange = function(){ if(xhr.readyState==4){ var rst = document.getElementById("result"); rst.innerHTML = xhr.responseText; xhr.open("get",myurl); xhr.send(null);window.onload = function(){ showPage("./data1.php"); //获得分页信息 //showPage("./data.php page=2"); /script style type="text/css" /style /headPHP教程

郑重声明：本文版权归原作者所有，转载文章仅为传播更多信息之目的，如作者信息标记有误，请第一时间联系我们修改或删除，多谢。

上一篇：关于php的打包解包 Phar

下一篇：关于PHP的Yii框架中登陆功能的实现