ecshop首页怎么调用积分商城里面的商品

一、调用热门积分商品的函数

/**
* 获得积分商城热门商品
*
* @param int $maxtop 列出条数
* @return array
*/
function exchange_gets_goods($maxtop)
{
/* 获得热门积分商品列表 */
$sql = 'SELECT g.goods_id, g.goods_name, g.goods_name_style, eg.exchange_integral, '
.' g.goods_type,g.goods_brief, g.goods_thumb, g.goods_img, eg.is_hot '
.' FROM `ecshop`.`ecshop_exchange_goods` AS eg LEFT JOIN `ecshop`.`ecshop_goods` AS g ON g.goods_id = eg.goods_id LEFT JOIN `ecshop`.`ecshop_brand` AS b ON b.brand_id = g.brand_id '
.' WHERE eg.is_exchange = 1 AND g.is_delete = 0 AND eg.is_hot = 1 ORDER BY g.sort_order, g.last_update DESC limit ';
$sql.=$maxtop;
$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);
$arr[$idx]['goods_img'] = get_image_path($row['goods_id'], $row['goods_img']);
$arr[$idx]['url'] = build_uri('exchange_goods', array('gid'=>$row['goods_id']), $row['goods_name']);
}
return $arr;
}
->

二、 //调用积分商城的商品，在index.php中加入

$smarty -> assign('goods_exchange_list',exchange_gets_goods(6));

三、显示模板，在index.dwt中加入

<!--积分商城列表-->
<div class="modTitle clearfix">
<span class="left"></span><span class="right"></span>
<div class="f_l">积分兑换</div>
<div class="more">
<a href="/exchange.php" target="_blank"><img src="../images/bnt_more_1.gif" class="more" alt="更多"></a></div>
</div>
<div class="modBox clearfix">
<!--{foreach name=goods_exchange_list from=$goods_exchange_list item=exchange_goods}-->
<div class="goodsMod">
<a href="{$exchange_goods.url}" target="_blank"><img src="{$exchange_goods.goods_thumb}" alt="{$exchange_goods.goods_name}" /></a><br />
<p><a href="{$exchange_goods.url}" target="_blank">
<!-- {if $exchange_goods.goods_style_name} -->
<font class="f3">{$exchange_goods.goods_style_name}</font><br />
<!-- {else} -->
<font class="f3">{$exchange_goods.goods_name}</font><br />
<!-- {/if} -->
</a>
<!-- {if $exchange_goods.goods_brief} -->
{$lang.goods_brief}{$exchange_goods.goods_brief}<br />
<!-- {/if} --></p>
{$lang.exchange_integral}<font class="price">{$exchange_goods.exchange_integral}</font>
</div>
<!--{/foreach}-->
</div>

本文标签：

声明：本文由代码号注册/游客用户【雷友水】供稿发布，本站不对用户发布的ecshop首页怎么调用积分商城里面的商品信息内容原创度和真实性等负责。如内容侵犯您的版权或其他权益，请留言并加以说明。站长审查之后若情况属实会及时为您删除。同时遵循 CC 4.0 BY-SA 版权协议，尊重和保护作者的劳动成果，转载请标明出处链接和本声明内容。本文作者：雷友水» https://www.ebingou.cn/dmh/13647.html

很赞哦！ ()