帝国CMS灵动标签循环子栏目同时调用点击排行及最新信息
帝国CMS灵动标签循环子栏目同时调用点击排行及最新信息
如上图所示,左边调用点击排行,右边调用最新信息。
代码如下:
<div class="intabbk" id="shtree1">
<h3></h3><span class="more"><a href="[!---news.url--]list-1-0.html" target="_blank">更多>></a></span>
<div id="tab-hd" class="deep-hd">[showclasstemp]1,13,0,0[/showclasstemp]</div>
<div id="tab-bd" class="deep-bd">
[e:loop={"select classid, classname, classpath from `[!db.pre!]enewsclass` where bclassid='1' order by myorder asc ",7,24,0}]
<div class="dcon">
<div class="topl">
<div class="top10">
<b>销售排行</b>TOP10
</div>
<?php
//这里是取得该分类下的有图片的最新数据
$newbook1=$empire->query("select title,titlepic,titleurl,keyboard,newstime,groupid,tprice,price,classid,newspath,filename,id from phome_ecms_shop where classid =".$bqr[classid]." order by onclick desc limit 6");
while($r=$empire->fetch($newbook1)) {
$commbookurl=sys_ReturnBqTitlelink($commbook1);
?>
<dl>
<dt><a href="<?=sys_ReturnBqTitlelink($r)?>" target="_blank"><img src="data:image/svg+xml,%3Csvg%20xmlns='http://www.w3.org/2000/svg'%20viewBox='0%200%20480%20640'%3E%3C/svg%3E" loading='lazy' data-lazy-src="http://1.com/skin/default/image/nopic.gif" width="60" height="60" /></a></dt>
<dd><a href="<?=sys_ReturnBqTitlelink($r)?>" target="_blank"><?=$r[title]?></a></dd>
<dd><span class="price">市价:<?=$r[tprice]?></span></dd>
<dd><span class="priceb">售价:<?=$r[price]?></span></dd>
</dl>
<?php
}
?>
<div class="go"><a href="[!---news.url--]list-1-0.html" target="_blank">进入进口食品>></a></div>
</div>
<div class="goodsbk">
<ul class="goods_list">
<?php
$newbook=$empire->query("select title,titlepic,titleurl,keyboard,newstime,groupid,tprice,price,classid,newspath,filename,id from phome_ecms_shop where classid =".$bqr[classid]." order by newstime desc limit 8");
while($r=$empire->fetch($newbook)) {
?>
<li>
<div class="pic_wrap"><a href="<?=sys_ReturnBqTitlelink($r)?>" target="_blank"><img alt="<?=$r[title]?>" src="data:image/svg+xml,%3Csvg%20xmlns='http://www.w3.org/2000/svg'%20viewBox='0%200%20480%20640'%3E%3C/svg%3E" loading='lazy' data-lazy-src="http://1.com/skin/default/image/nopic.gif"></a></div>
<div class="price_wrap"><p class="price"><span>¥</span><?=$r[price]?></p></div>
<div class="title_wrap"><a title="<?=$r[title]?>" href="<?=sys_ReturnBqTitlelink($r)?>" target="_blank"><?=$r[title]?></a></div>
</li>
<?php
}
?>
</ul></div>
</div>
[/e:loop]
</div>