51可用代码模板网站

咨询热线:

181-1164-6936
  • 1
ECSHOP商城
当前位置:首页>实用代码>ECSHOP商城>

ECSHOP全部品牌页实现分页换页功能

时间:2017-08-10 15:16点击:
“在全部品牌页实现分页换页功能”,对商品品牌较多的朋友也许会有帮助。

1、打开brand.PHP

找到


if (empty($brand_id))
{
再找到



exit();
}
将这两者之间的代码全部替换为下面代码



    assign_template();  
            $position = assign_ur_here('', $_LANG['all_brand']);  
            $smarty->assign('page_title',      $position['title']);    // 页面标题  
            $smarty->assign('ur_here',         $position['ur_here']);  // 当前位置  
            $smarty->assign('categories',      get_categories_tree()); // 分类树  
            $smarty->assign('helps',           get_shop_help());       // 网店帮助  
            $smarty->assign('top_goods',       get_top10());           // 销售排行  
        
      $sql = "SELECT count(*) as brand_count from ( select b.brand_id ".  
                "FROM " . $GLOBALS['ecs']->table('brand') . "AS b, ".  
                $GLOBALS['ecs']->table('goods') . " AS g ".  
                "WHERE g.brand_id = b.brand_id AND is_show = 1 " .  
                " AND g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0 ".  
                "GROUP BY b.brand_id ) AS gb";  
      $brand_count=$GLOBALS['db']->getOne($sql);  //品牌(含有商品的)数量   
       $page       = !empty($_REQUEST['page'])  && intval($_REQUEST['page'])  > 0 ? intval($_REQUEST['page'])  : 1;  
       $size       = 3;  
       $max_page = ($brand_count> 0) ? ceil($brand_count / $size) : 1;  
       if ($page > $max_page)  {$page = $max_page;}  
       $start=($page - 1) * $size;     
      $sql = "SELECT b.brand_id, b.brand_name, b.brand_logo, b.brand_desc, COUNT(*) AS goods_num, IF(b.brand_logo > '', '1', '0') AS tag ".  
                "FROM " . $GLOBALS['ecs']->table('brand') . "AS b, ".  
                    $GLOBALS['ecs']->table('goods') . " AS g ".  
                "WHERE g.brand_id = b.brand_id AND is_show = 1 " .  
                " AND g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0 ".  
                "GROUP BY b.brand_id HAVING goods_num > 0 ORDER BY tag DESC, b.sort_order ASC limit $start,$size";  
        
      $row = $GLOBALS['db']->getAll($sql);  
      foreach ($row AS $key => $val)  
      {  
       $row[$key]['url'] = build_uri('brand', array('cid' => $cat, 'bid' => $val['brand_id']), $val['brand_name']);  
       $row[$key]['brand_desc'] = htmlspecialchars($val['brand_desc'],ENT_QUOTES);  
      }  
      $pager['search'] = array( );  
      $pager = get_pager('brand.php', $pager['search'], $brand_count, $page, $size);  
      $pager['display'] = $display;  
      $smarty->assign('pager', $pager);  
            $smarty->assign('brand_list', $row);    
        $smarty->display('brand_list.dwt');  
2、打开 模板文件 brand_list.dwt
    在你想要显示换页信息的地方加入下面代码


 <!-- #BeginLibraryItem "/library/pages.lbi"--><!-- #EndLibraryItem -->
  如果你使用的是官方默认模板,那么在

<div class="dashed"></div>

这行代码下面加

<!-- #BeginLibraryItem "/library/pages.lbi"--><!-- #EndLibraryItem -->
比较合适。


51可用模板(代码)网站专为广大站长朋友提供精品模板与代码,同时免费提供网站收录。
本站域名: WWW.51KYDM.COM    联系方式:QQ:182468923    手机:18111646936
本站关键词:网站链接收录网址收录入口网站免费提交收录网站收录提交入口    网站地图
51可用模板
展开