ecshop调用指定广告的写法实例

function getads($cat,$num)
{
$time = gmtime();
$sql = "SELECT * FROM " . $GLOBALS['ecs']->table('ad') . " where position_id=".$cat." and start_time <= '" . $time . "' AND end_time >= '" . $time . "' ORDER BY ad_id desc limit ".$num;
$res = $GLOBALS['db']->getAll($sql);
$arr = array();
foreach ($res AS $idx => $row)
{
$arr[$idx]['id'] = $row['ad_id'];
$arr[$idx]['title'] = $row['ad_name'];
$arr[$idx]['ad_link'] = $row['ad_link'];
$arr[$idx]['ad_code'] = "data/afficheimg/".$row['ad_code'];
}
return $arr;
}

$smarty->assign('promotion_goods', get_promote_goods()); // 特价商品

$smarty->assign("banner",getads(1,4));

<!--{foreach from=$banner name=ban item=banner}-->
<li><a href="{$banner.ad_link}"><img src="{$banner.ad_code}"></a></li>
<!--{/foreach}-->

{insert name='ads' id=2 num=1}