Ecshop分页规则，分以下几个步骤

1.点击类别，获取第一页获取默认分类列表数据

2.点击“下一页”，采用ajax调取分页内容

 

实例分析（比如订单列表分页admin/order.php）

1.先写一个function order_list() 模块，里面要包括可以进行排序，分页，查询等功能

2.在order.php里面写一个elseif ($_REQUEST['act'] == 'list') ，这里是显示默认分页数据

3.在order.php写一个query（listtable.js默认的是先读取$_REQUEST['act'] == 'query'）排序、分页、查询都在query里面完成

4.html页面（默认order_list.html完整代码）

 

实战 ”微仓功能“

1.我先写一个function depot_log_list,可以进行排序、分类、查询。这个function里面很有讲究的

重点代码

function depot_list(){   //*f.获取上一次保存的查询条件（如果上一次有进行查询过，则直接从f开始）   $result = get_filter();    if ($result === false) {　　　　// a.查询条件　　　　$filter['goods_id'] = empty($_REQUEST['goods_id']) ? '' : trim($_REQUEST['goods_id']);        //b.记录总条数        $filter['record_count'] = $GLOBALS['db']->getOne("SELECT COUNT(*) FROM " . $GLOBALS['ecs']->table('depot_log') . $ex_where);        //c.分页大小　　　　　　　　$filter = page_and_size($filter);　　　　//d.查询的sql        $sql = "SELECT * FROM " . $GLOBALS['ecs']->table('depot_log') . $ex_where .                " order by createtime desc LIMIT " . $filter['start'] . ',' . $filter['page_size'];　　　　//e.保存查询条件（cookie保存）        set_filter($filter, $sql);    }    else    {　　　//*f.获取上一次保存的查询条件（如果没有进行查询过，则从a查询。）　　　　sql=" role="presentation" style="position: relative;">sql=sql=sql = result['sql'];        　　　　filter=" role="presentation" style="position: relative;">filter=filter=filter = result['filter'];    }    $depot_list = $GLOBALS['db']->getAll($sql);　　//g.组合成系统默认查询条件    $arr = array('depot_list' => $depot_list, 'filter' => $filter,        'page_count' => $filter['page_count'], 'record_count' => $filter['record_count']);    return $arr;}

e.f这两步骤非常的重要，还有if($result===false){}也非常重要

实例代码

function depot_list(){    $result = get_filter();        if ($result === false)    {        $filter['user_id'] = empty($_REQUEST['user_id']) ? '' : trim($_REQUEST['user_id']);        $filter['goods_stock'] = empty($_REQUEST['goods_stock']) ? '' : intval($_REQUEST['goods_stock']);                $filter['sort_by']    = empty($_REQUEST['sort_by'])    ? 'goods_stock' : trim($_REQUEST['sort_by']);  // js的listTable.sort排序功能，也可以user_id        $filter['sort_order'] = empty($_REQUEST['sort_order']) ? 'DESC'     : trim($_REQUEST['sort_order']);                $ex_where = ' WHERE 1 ';        $ex_where .=" AND user_id = '$filter[user_id]' ";                        $filter['record_count'] = $GLOBALS['db']->getOne("SELECT COUNT(*) FROM " . $GLOBALS['ecs']->table('depot') . $ex_where);        /* 分页大小 */        $filter = page_and_size($filter);        $sql = "SELECT * FROM " . $GLOBALS['ecs']->table('depot') . $ex_where .                 " ORDER by " . $filter['sort_by'] . ' ' . $filter['sort_order'] .                " LIMIT " . $filter['start'] . ',' . $filter['page_size'];       // $filter['keywords'] = stripslashes($filter['keywords']);        set_filter($filter, $sql);    }    else    {        $sql    = $result['sql'];        $filter = $result['filter'];    }    $depot_list = $GLOBALS['db']->getAll($sql);    foreach($depot_list as $k=>$v){        $sql = "SELECT goods_name,goods_thumb from ".$GLOBALS['ecs']->table('goods')." where goods_id = ".$v['goods_id'];        $re = $GLOBALS['db']->getRow($sql);        $depot_list[$k]['name'] = $re['goods_name'];        $depot_list[$k]['goods_thumb'] = $re['goods_thumb'];                }    $arr = array('depot_list' => $depot_list, 'filter' => $filter,        'page_count' => $filter['page_count'], 'record_count' => $filter['record_count']);    return $arr;}

2.写一个列表

实例代码

elseif($_REQUEST['act'] == 'depot_log'){    $smarty->assign('ur_here',      '个人微仓操作记录');       $depot = depot_log_list();        //print_r($depot);    $smarty->assign('depot_log',    $depot['depot_list']);    $smarty->assign('filter',       $depot['filter']);    $smarty->assign('record_count', $depot['record_count']);    $smarty->assign('page_count',   $depot['page_count']);    $smarty->assign('full_page',    1);    assign_query_info();    $smarty->display('depot_log_list.htm');    }

3.写一个列表查询（这里的depot_log_query ，还可以承接html页面的<a href="javascript:listTable.sort('goods_stock', 'DESC'); ">）

/*会员微仓 ajax 翻页调用*/elseif ($_REQUEST['act'] == 'depot_list_query'){        $depot = depot_list();    //$depot = user_list();    $smarty->assign('depot',    $depot['depot_list']);    $smarty->assign('filter',       $depot['filter']);    $smarty->assign('record_count', $depot['record_count']);    $smarty->assign('page_count',   $depot['page_count']);        $sort_flag  = sort_flag($depot['filter']);    $smarty->assign($sort_flag['tag'], $sort_flag['img']);    make_json_result($smarty->fetch('depot_list.htm'), '', array('filter' => $depot['filter'], 'page_count' => $depot['page_count']));  // 注意此处的结构，缺少mke_json_result不行     }

4.html页面html代码

     
          {
    foreach from=$depot item=vo}  
  {foreachelse}  
  {
    /foreach}  
        
       
            
            {
    $lang.record_id}{
   $sort_user_id}    
            
缩略图
            
商品名称
            
库存
            
{
   $lang.handler}
         
       
       
       
            
{
   $vo.id}
            
            
{ $vo.goods_name}
            
{
   $vo.goods_stock}
            
                     
         
       
        
{
   $lang.no_records}
       
       
              
            
              
      {
    include file="page.htm"}      
         
      
     

js代码

{
   if $full_page}
     {
    /literal}{
    include file="pagefooter.htm"}{
    /if}

如果改变了，默认的query查询；则a,b两处都不可以少

 

分页实例化结构代码

Array(    [depot_list] => Array        (            [0] => Array                (                    [id] => 1                    [user_id] => 1                    [goods_id] => 2                    [goods_stock] => 2                    [goods_name] => 荷兰Nutrilon牛栏奶粉                 )            [1] => Array                (                    [id] => 7                    [user_id] => 1                    [goods_id] => 6                    [goods_stock] => 4                    [goods_name] => 1111                )        )    [filter] => Array        (            [user_id] => 1            [record_count] => 2            [page_size] => 4            [page] => 1            [page_count] => 1            [start] => 0        )    [page_count] => 1    [record_count] => 2)

 

 

 

 

转: https://www.cnblogs.com/wesky/p/5424685.html