Smarty+adodb分页示例
来源:互联网 作者: 发布时间:2008-12-16
利用Smarty+adodb分页示例, 下面给出的是分页部份的代码。 分页
利用Smarty+adodb分页示例, 下面给出的是分页部份的代码。
分页文件:page.lbi
以下为引用的内容:
<table width="100%" border="0" cellpadding="0" cellspacing="0" > <form name="jump" method="post" action=""> <tr> <td height="28" align="center" valign="bottom">当前页 <!--{$navi_cM.page}-->/<!--{$navi_cM.pages}--> <!--{if $navi_cM.pages gt 1 && $navi_cM.page ne 1}--> <a href="?<!--{$navi_cM.param}-->&page=1">[ 首页 ]</a> <!--{else}--> [ 首页 ] <!--{/if}--> <!--{if $navi_cM.pages gt 1 && $navi_cM.page ne 1}--> <a href="?<!--{$navi_cM.param}-->&page=<!--{$navi_cM.page-1}-->">[ 上一页 ]</a> <!--{else}--> [ 上一页 ] <!--{/if}--> <!--{if $navi_cM.pages gt 1 && $navi_cM.page ne $navi_cM.pages}--> <a href="?<!--{$navi_cM.param}-->&page=<!--{$navi_cM.page+1}-->">[ 下一页 ]</a> <!--{else}--> [ 下一页 ] <!--{/if}--> <!--{if $navi_cM.pages gt 1 && $navi_cM.page ne $navi_cM.pages}--> <a href="?<!--{$navi_cM.param}-->&page=<!--{$navi_cM.pages}-->">[ 末页 ]</a> <!--{else}--> [ 末页 ] <!--{/if}--> 转到 字串6 <select name="changepage" onchange="re_jump('<!--{$navi_cM.param}-->')"> <!--{html_options options=$navi_cM.option selected=$navi_cM.page}--> </select> </td> </tr> </form> </table>
|
php部份....
以下为引用的内容:
// level E member's product commend list public function product_comm($size = 5){ $pre = $size <> 5 && !empty($_REQUEST['lb']) ? " AND prolb LIKE '%".$_REQUEST['lb']."%' " : ""; $this->where = " judge_flag = 0 AND pubname = '".$_REQUEST['user']."' $pre "; $sql = " SELECT id, pingpai, img, huohao FROM user_proinfo WHERE ".$this->where. " ORDER BY pubtime DESC "; $res = $this->selectRs->SelectLimit($sql, $size, ($this->page - 1) * $size ); $this->NaviPage_cM("`user_proinfo`", $size, $this->where); return $res; } // embed in all must be used cat page function private function NaviPage_cM($table, $size, $where){ $count = $this->selectRs->GetOne("SELECT COUNT(*) FROM $table WHERE $where "); $pages = @ceil($count/$size); for ($i = 0; $i <= $pages; $i++) $arr[] = $i; $navi_cM = array( "option" => $arr, "page" => $this->page, "pages" => $pages, "count" => $count, 字串7 "size" => $size, "param" => $this->param ); $this->tpl->assign("navi_cM", $navi_cM); }
|