Smarty+adodb分页示例
利用Smarty+adodb分页示例, 下面给出的是分页部份的[url=javascript:;]代码[/url]。有不懂可以在下面留言,站长会看到并回复的。 [url=javascript:;]转载[/url]请注明来源:[url=javascript:;]PHP[/url]开发资源网 字串7 分页文件:page.lbi 当前页 / &page=1">[ 首页 ] [ 首页 ] &page=">[ 上一页 ] 字串9 [ 上一页 ] &page=">[ 下一页 ] [ 下一页 ] &page=">[ 末页 ] [ 末页 ] 转到 字串6 ')"> 字串8 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; } 字串3 // 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 $arr, "page" => $this->page, "pages" => $pages, "count" => $count, 字串7 "size" => $size, "param" => $this->param ); $this->tpl->assign("navi_cM", $navi_cM); }
|