SMARTY 分页的问题。帮忙看看里出问题了
共8条记录,第一页显示所有,第2页显示后5条,第3页也就是最后一页显示2条。高手帮忙看看哪里出错了。
<?php
include("conn/conn.php");
include("smarty_inc.php");
/*取数据***************************************************************************************/
$rs=array();
$query=mysql_query("select * from tb_leaguerinfo ");
while($arr=mysql_fetch_array($query))
{
array_push($rs,$arr);
}
/*分页*****************************************************************************************/
$recordNum = mysql_num_rows($query); //记录总数
$pageSize = 3; //每页显示的记录数
/* 得到总页数*/
if($recordNum)
{
$pageCount = ($recordNum < $pageSize)?1:(ceil($recordNum/$pageSize));
}
/* 得到当前的页码*/
if(!empty($_GET['pageID']))
{
$pageID = intval($_GET['pageID']);
}
else
{
$pageID = 1;
}
if($_GET['pageID'] > $pageCount)
{
echo "<script>alert('此页不存在!');</script> ";
echo "<script>window.location.href('index.php');</script> ";
}
$prePage = $pageID -1;
$nextPage = $pageID +1;
/**每页起始记录值*/
$pageStartNum = ($pageID == 1)?(0):(($pageID -1) * $pageSize);
/**每页结束记录值*/
$pageEndNum = $pageStartNum + $pageSize;
/** 得到分页字符串链接 */
if($pageID == 1)
{
$pageLinks = '首页 | 上一页 | ';
}
else
{
$pageLinks .= "<a href=".$_SERVER['PHPSELF']."?pageID=1>首页</a> | <a href=".$_SERVER['PHPSELF']."?pageID=".$prePage.">上一页</a> ";
}
if(($pageID == $pageCount) || ($pageCount ==0))
{
$pageLinks .= ' 下一页 | 尾页 ';
}
else
{
$pageLinks .= '<a href='.$_SERVER["PHPSELF"].'?pageID='.$nextPage.'>下一页</a> <a href="'.$_SERVER["PHPSELF"].'?pageID='.$pageCount.'">尾页</a>';
}
$smarty->assign("db",$rs);
$smarty->assign('pageSize',$pageSize);
$smarty->assign('recordNum',$recordNum);
$smarty->assign('pageStartNum',$pageStartNum);
$smarty->assign('pageEndNum',$pageEndNum);
$smarty->assign('pageLinks',$pageLinks);
$smarty->display("main.htm");
?>
这是摸板的代码
<table border="1">
{# section name=item loop=$Users max=$recordNum start=0 step=1 #}
{# if ($smarty.section.item.index >= $pageStartNum )&& ($smarty.section.item.index <= $pageEndNum ) #}
<tr>
<td>{# $db[item][0] #}</td><td>{# $db[item][1] #}</td><td>{# $db[item][2] #}</td>
<td>{# $db[item][3] #}</td><td>{# $db[item][4] #}<td>{# $db[item][5] #}</td></td>
</tr>
{# /if #}
{# /section #}