首页 > PHP资讯 > PHP培训技术 > Smarty+adodb分页示例

Smarty+adodb分页示例

PHP培训技术

利用Smarty+adodb分页示例, 下面给出的是分页部份的代码。有不懂可以在下面留言,站长会看到并回复的。
转载请注明来源:PHP开发资源网字串7

分页文件:page.lbi
字串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 <= $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);
   }
<完>

PHP培训技术

本文由欣才IT学院整理发布,未经许可,禁止转载。
支持36不支持0