帝国cms教程栏目,提供精品建站,仿站,二次开发,安装,标签使用等图文教程,帮助建设和管理好你的帝国cms站点。
帝国cms如何实现随机调用信息?下面帝国模板之家给大家分享6种方式来实现基于(灵动标签)。
方法一:
[e:loop={"SELECT * FROM `{$dbtbpre}ecms_news` ORDER BY RAND() LIMIT 10",10,24,0}]
<li><span class="pull-right hui"><?=date("m-d",$bqr['newstime'])?></span><a href="<?=$bqr['titleurl']?>" title="<?=$bqr['title']?>"><i class="fa fa-caret-right hui"></i><?=$bqr['title']?></a></li>
[/e:loop]
方法二:
[e:loop={"SELECT * FROM `{$dbtbpre}ecms_news` WHERE id >= (SELECT FLOOR( MAX(id) * RAND()) FROM `{$dbtbpre}ecms_news` ) ORDER BY id LIMIT 10",10,24,0}]
<li><span class="pull-right hui"><?=date("m-d",$bqr['newstime'])?></span><a href="<?=$bqr['titleurl']?>" title="<?=$bqr['title']?>"><i class="fa fa-caret-right hui"></i><?=$bqr['title']?></a></li>
[/e:loop]
方法三:
[e:loop={"SELECT * FROM `{$dbtbpre}ecms_news` AS t1 JOIN (SELECT ROUND(RAND() * (SELECT MAX(id) FROM `{$dbtbpre}ecms_news`)) AS id) AS t2 WHERE t1.id >= t2.id ORDER BY t1.id ASC LIMIT 10",10,24,0}]
<li><span class="pull-right hui"><?=date("m-d",$bqr['newstime'])?></span><a href="<?=$bqr['titleurl']?>" title="<?=$bqr['title']?>"><i class="fa fa-caret-right hui"></i><?=$bqr['title']?></a></li>
[/e:loop]
方法四:
[e:loop={"SELECT * FROM `{$dbtbpre}ecms_news` WHERE id >= (SELECT floor(RAND() * (SELECT MAX(id) FROM `{$dbtbpre}ecms_news`))) ORDER BY id LIMIT 10",10,24,0}]
<li><span class="pull-right hui"><?=date("m-d",$bqr['newstime'])?></span><a href="<?=$bqr['titleurl']?>" title="<?=$bqr['title']?>"><i class="fa fa-caret-right hui"></i><?=$bqr['title']?></a></li>
[/e:loop]
方法五:
[e:loop={"SELECT * FROM `{$dbtbpre}ecms_news` WHERE id >= (SELECT floor( RAND() * ((SELECT MAX(id) FROM `{$dbtbpre}ecms_news`)-(SELECT MIN(id) FROM `{$dbtbpre}ecms_news`)) + (SELECT MIN(id) FROM `{$dbtbpre}ecms_news`))) ORDER BY id LIMIT 10",10,24,0}]
<li><span class="pull-right hui"><?=date("m-d",$bqr['newstime'])?></span><a href="<?=$bqr['titleurl']?>" title="<?=$bqr['title']?>"><i class="fa fa-caret-right hui"></i><?=$bqr['title']?></a></li>
[/e:loop]
方法六:
[e:loop={"SELECT * FROM `{$dbtbpre}ecms_news` AS t1 JOIN (SELECT ROUND(RAND() * ((SELECT MAX(id) FROM `{$dbtbpre}ecms_news`)-(SELECT MIN(id) FROM `{$dbtbpre}ecms_news`))+(SELECT MIN(id) FROM `{$dbtbpre}ecms_news`)) AS id) AS t2 WHERE t1.id >= t2.id ORDER BY t1.id LIMIT 10",10,24,0}]
<li><span class="pull-right hui"><?=date("m-d",$bqr['newstime'])?></span><a href="<?=$bqr['titleurl']?>" title="<?=$bqr['title']?>"><i class="fa fa-caret-right hui"></i><?=$bqr['title']?></a></li>
[/e:loop]
以上六中方式都能实现帝国cms调用随机信息,经过测试方法三的查询效率是最优的,更多相关内容请关注帝国模板之家其他文章。
转载请注明来源:帝国cms灵动标签随机文章调用
本文永久链接地址:https://www.moyouyouw.cn/code/334.html
郑重声明:本站所有主题/文章除标明原创外,均来自网络转载,版权归原作者所有,如果有侵犯到您的权益,请联系本站删除,谢谢!我们不承担任何技术及版权问题,且不对任何资源负法律责任。
上一篇
下一篇
售价: 399 76 ℃ 0 评论
售价: 399 95 ℃ 0 评论
售价: 399 62 ℃ 0 评论
已有 位小伙伴发表了看法
欢迎 你 发表评论