php+ajax实现无刷新分页

前端之家收集整理的这篇文章主要介绍了php+ajax实现无刷新分页前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。

本文实例讲述了PHP+ajax实现无刷新分页实现方法分享给大家供大家参考。具体如下:

limit 偏移量,长度; limit 0,7; 第一页 limit 7,7; 第二页 limit 14,7; 第三页 每页信息条数:7 信息总条数:select count(*) from table 信息总页数:ceil向上取整(总条数/每页条数)

1、分页类具体使用

<div class="jb51code">
<pre class="brush:PHP;">
<?php

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;

/*

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);



if (isset($parse["query"])) {
  parse_str($parse['query'],$params);
  unset($params["page"]);
  $url = $parse['path'] . '?' . http_build_query($params);
}

return $url;

}

//魔术方法
public function __get($args) {
if ($args == "limit")
return $this->limit;
else
return null;
}

//页面开始的条数
private function start() {
if ($this->total == 0)
return 0;
else
return ($this->page - 1) * $this->listRows + 1;
}

//页面结束的条数
private function end() {
return min($this->page * $this->listRows,$this->total);
}

/设置首页/
private function first() {
$html = "";
if ($this->page == 1)
$html.=''.$this->config["first"].'';
else
$html.="{$this->config["first"]}";
//$html.="{$this->config["first"]}";

return $html;

}

/设置上一页/
private function prev() {
$html = "";
if ($this->page == 1)
$html.=''.$this->config["prev"].'';
else
$html.="{$this->config["prev"]}";
//$html.="{$this->config["prev"]}";

return $html;

}

//页码列表【首页】【2】【3】…………【尾页】
private function pageList() {
$linkPage = "";

$inum = floor($this->listNum / 2);

for ($i = $inum; $i >= 1; $i--) {
  $page = $this->page - $i;

  if ($page < 1)
    continue;

  $linkPage.="<a href='javascript:void(0)' onclick='showPage(\"{$this->uri}&page={$page}\")'>{$page}</a>";
}

$linkPage.="{$this->page}";


for ($i = 1; $i <= $inum; $i++) {
  $page = $this->page + $i;
  if ($page <= $this->pageNum)
    $linkPage.="<a href='javascript:void(0)' onclick='showPage(\"{$this->uri}&page={$page}\")'>{$page}</a>";
  else
    break;
}

return $linkPage;

}

/设置下一页/
private function next() {
$html = "";
if ($this->page == $this->pageNum)
$html.=''.$this->config["next"].'';
else
$html.="{$this->config["next"]}";
//$html.="{$this->config["next"]}";

return $html;

}

/设置尾页/
private function last() {
$html = "";
if ($this->page == $this->pageNum)
$html.=''.$this->config["last"].'';
else
$html.="{$this->config["last"]}";
//$html.="{$this->config["last"]}";

return $html;

}

/设置页面跳转/
private function goPage() {

return 
'<input type="text" onkeydown="javascript:if(event.keyCode==13){var page=(this.value>' . $this->pageNum . ')?' . $this->pageNum . ':this.value;showPage(\'' . $this->uri . '&page=\'+page+\'\')}" value="' . $this->page . '" style="width:25px"&gt;
<input type="button" value="GO" onclick="javascript:var page=(this.previousSibling.value>' . $this->pageNum . ')?' . $this->pageNum . ':this.prev<a href="/tag/IoU/" target="_blank" class="keywords">IoU</a>sSibling.value;showPage(\'' . $this->uri . '&page=\'+page+\'\')"&gt;';

}

//页面列表配置选项
function fpage($display = array(0,1,2,3,4,5,6,7,8)) {
$html[0] = "共有{$this->total}{$this->config["header"]}";
$html[1] = "每页显示" . ($this->end() - $this->start() + 1) . "条,本页{$this->start()}-{$this->end()}条";
$html[2] = "{$this->page}/{$this->pageNum}页";

$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 数据显示

PHP;"> PHP

//链接数据库

//获得具体信息

//分页显示
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; }

eof; 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,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>".$pagelist."</td></tr>";
echo "</table>";

3 ajax无刷新分页实现

open(‘get','http://网址/index.PHP?page=2')

<div class="jb51code">
<pre class="brush:xhtml;">
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"&gt;

新建网页
<script type="text/javascript"&gt;

//获得分页信息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");
}

<style type="text/css"&gt;
</style>

ajax无刷新分页效果

希望本文所述对大家的PHP程序设计有所帮助。

猜你在找的PHP相关文章