php实现分页

最新推荐文章于 2021-03-29 16:16:25 发布

yys3155

最新推荐文章于 2021-03-29 16:16:25 发布

阅读量607

点赞数

本文链接：https://blog.csdn.net/yys3155/article/details/8674851

版权

<?php
class goodsController extends baseController{
public function showAction(){
$book=new goodsModel('localhost','news','root','123');
$rows=$book->show();
$this->smarty->assign('list',$rows);
$this->smarty->display('book.tpl');
}
public function showsomeAction(){
$num = $_COOKIE["num"];
$book=new goodsModel('localhost','news','root','123');
$pagesize=4;
$pages=ceil($_COOKIE["num"]/$pagesize);
$GLOBALS['page']=$_POST['page'];
$offset=$pagesize*($GLOBALS['page']-1);
$rows=$book->showsome($offset,$pagesize);
//file_put_contents("d:/b.txt",$rows,FILE_APPEND);

$first=1;
$priv=$GLOBALS['page']-1;
$next=$GLOBALS['page']+1;
$last=$pages;//file_put_contents('d:/v.txt',$last,FILE_APPEND);
$f= "<a οnclick='viewpage(".$first.")' href='#'>首页</a> ";
if($GLOBALS['page']>1) {
$p="<a οnclick='viewpage(".$priv.")' href='#'>上页</a>";}else{$p="";}
if($GLOBALS['page']<$last) {
$n= "<a οnclick='viewpage(".$next.")' href='#'>下页</a>";}else{$n="";}
$l= "<a οnclick='viewpage(".$last.")' href='#'>尾页</a></center>";

$str= "<center>总共".$num."记录"."目前是第".$GLOBALS['page']."页"."总共".$pages."页<br/>".$f.@$p.$n.$l;
$arr=array('str'=>$str,'rows'=>$rows);
$rows=json_encode($arr);
echo $rows;
}

}

public function show(){
$sql="select * from new";
$res=mysql_query($sql);
$va=mysql_num_rows($res);
setcookie("num",$va);
$rows=array();
while($row = mysql_fetch_assoc($res)){
$rows[]=$row;
}
return $rows;
}
public function showsome($offset,$pagesize){
$sql="select * from new limit $offset,$pagesize";
$res=mysql_query($sql);
$rows=array();
while($row = mysql_fetch_assoc($res)){
$rows[]=$row;
}
return $rows;
}

<head></head>
<body οnlοad="viewpage(1)">
<h3 align="center">数据分页显示</h3>
<table style="margin-bottom:20px;margin:auto;border:1px solid;border-spacing:1">
<tr>
<th>ID</th><th>姓名</th><th>内容</th><th>编号</th><th>日期</th>
</tr>
<{foreach from=$list item="value"}>
<tr>
<td style="padding-top:5px;"><{$value.id}></td>
<td style="padding-top:5px;"><{$value.name}></td>
<td style="padding-top:5px;"><{$value.content}></td>
<td style="padding-top:5px;"><{$value.c_id}></td>
<td style="padding-top:5px;"><{$value.dat}></td>
</tr>
<{/foreach}>
</table>
<table align="center" style="margin-top:15px">
<tr>
<td style="colspan:3;height:20">
<div id="display">
<tr>
<tr>
<td style="colspan:3;height:20">

</tr>
</div>
<p id="p1">
</p></td>
</tr>
</table>
<script>

function viewpage(page){
var xhr;
if(window.ActiveXObject){
xhr=new ActiveXObiect("Microsoft.XMLHTTP");
}else if(window.XMLHttpRequest){
xhr=new XMLHttpRequest();
}
var url="index.php?c=goods&a=showsome";
xhr.open('POST',url,true);
xhr.onreadystatechange=callback;
xhr.setRequestHeader("Content-Type","application/x-www-form-urlencoded");
xhr.send("page="+page);
function callback(){
if(xhr.readyState==4){
if(xhr.status==200){
var sre=eval('('+xhr.responseText+')');
var char=sre.str;
document.getElementById('p1').innerHTML=char;
var obj='';
for(var i=0;i<sre.rows.length;i++){
obj+=sre.rows[i].name;}

document.getElementById('display').innerHTML=obj;
}

}
}
}
</script>
</body>

yys3155

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
php实现分页

class goodsController extends baseController{public function showAction(){$book=new goodsModel('localhost','news','root','123');$rows=$book->show();$this->smarty->assign('list',$rows);$this-
复制链接

扫一扫