关于在ECSHOP全部品牌页实现分页换页功能
2016-09-11 20:39 来源:www.chinab4c.com 作者:ecshop专家
最近看到有朋友在论坛问到过此类问题,所以抽空写了下文。
“在全部品牌页实现分页换页功能”,对商品品牌较多的朋友也许会有帮助。
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 -->
比较合适。
最近更新
常用插件
- ecshop没登陆情况下订单查
ecshop没登陆情况下订单查询插件,主要是针对ecshop在没有登陆的情况下...
- ecshop最小购买数量控制插
ecshop最小购买数量控制插件,这个插件主要是为我们提供一个十分方便...
- ecshop2.7.2生成虚拟订单2.
以前我们开发过ecshop下的虚拟订单,就是客户在访问的时候,会自动生...
- ecshop二次开发商品购买增
图片1香...
- ecshop2.7.1邮件发送插件
ecshop2.7.1邮件发送插件:该插件主要的开发思想是源于ecshop短信发送系统...
ecshop热门问答
ecshop热门资料
ecshop472
ecshop区加
ecshop图片分离
ecshop成都
ecshopqihom
ecshop新模板
ecshop会员注册送红包
ecshop回传
ecshop加入
ecshop商品相簿
ecshopVPS主机
ecshop淘客网站
ecshop代收货款
ecshopshop
ecshop淘宝商家
ecshop器用
ecshop新手
ecshop银卡
ecshop1146
ecshop517
ecshop问题解决
ecshop专区
ecshop开源程序
ecshopcontent
ecshop文档
ecshoplujiangwang
ecshop皮肤
ecshop饮水机
电子商务原创
ecshopHAS