文档介绍:ECSHOP首页显示ecshop积分商城里的商品方法
ECSHOP教程网:hop-ercikaifa/
下面就以ECSHOP官方默认模板为基础,给大家提供一个完整的解决方案。
(本教程由ECSHOP120(,如要转载,请注明出处)
1)、
首先打开 文件
在最末尾增加下面函数,注意千万不要写到“?>”的外面去,要加在“?>”的前面。
/**
* 获得积分商城热门商品
*
* ***@param int $limit 列出条数
* ***@param int $ishot 是否只显示热销
* ***@return array
*/
function index_get_exchange($limit=3,$ishot=0)
{
/* 获得热门积分商品列表*/
$sql_ishot=$ishot ? " AND =1 " : "";
$sql = 'SELECT , , , , ' .
' ,, , , ' .
ECSHOP二次开发
' FROM ' . $GLOBALS['ecs']->table('exchange_goods') . ' AS eg LEFT JOIN ' . $GLOBALS['ecs']->table('goods') . ' AS g ON = ' .
' WHERE = 1 AND = 0 '. $sql_ishot .' limit '.$limit;
$res = $GLOBALS['db']->getAll($sql);
$arr = array();
foreach($res AS $idx => $row)
{
$arr[$idx]['name'] = $row['goods_name'];
$arr[$idx]['goods_brief'] = $row['goods_brief'];
$arr[$idx]['goods_style_name'] = add_style($row['goods_name'],$row['goods_name_style']);
$arr[$idx]['exchange_integral'] = $row['exchange_integral'];
$arr[$idx]['type'] = $row['goods_type'];
$arr[$idx]['goods_thumb'] = get_image_path($row['goods_id'], $row['goods_thumb'], true);
转载请注明:文章转载自ECSHOP教程网
$arr[$idx]['goods_img'] = get_image_path($row['goods_id'], $row['goods_img']);
$arr[$idx]['url']