Home  >  Article  >  php教程  >  PHP技巧:Smarty+adodb分页示例

PHP技巧:Smarty+adodb分页示例

WBOY
WBOYOriginal
2016-06-21 08:58:041569browse

利用Smarty+adodb分页示例, 下面给出的是分页部份的代码。

分页文件:page.lbi

以下为引用的内容:


 
   
    
   
   
当前页 /
      
       [ 首页 ]
      
       [ 首页 ]
      
      
       [ 上一页 ]
      
       [ 上一页 ]
      
      
       [ 下一页 ] 
      
       [ 下一页 ]
      
      
       [ 末页 ]   
      
       [ 末页 ]
      
       转到 字串6
      
   

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       $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);
   }



Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn