ecshop ajax分页代码,ECSHOP全部品牌分页功能实现

易站通带你来熟悉电商ecshop程序，让你更快的把自已的电商网站建立起来。

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

在你想要显示换页信息的地方加入下面代码

如果你使用的是默认模板，那么在

这行代码下面加

比较合适。

本文由易站通网络收集整理，如有版权问题请和我们联系我们会在第一时间内做出处理