帝国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调用随机信息，经过测试方法三的查询效率是最优的，更多相关内容请关注帝国模板之家其他文章。