网络营销电子商务研究中心 - 帝国灵动标签调用外部数据

帝国CMS的标签的SQL查询调用支持调用mysql数据库的所有数据，本节通过用灵动标签的SQL语句查询来讲解调用方法。

用DiscuzX的最新贴子

Code:

<table width="100%" border="0" cellspacing="1" cellpadding="3">

[e:loop={"select tid,subject,dateline from discuzdb.pre_forum_thread order by tid desc limit 10",10,24,0}]

<tr><td>

<a href="/bbs/forum.php?mod=viewthread&tid=<?=$bqr[tid]?>" target="_blank"><?=$bqr[subject]?></a> (<?=date('Y-m-d',$bqr[dateline])?>) 

</td></tr>

[/e:loop]

</table>

discuzdb.pre_forum_thread为DiscuzX的贴子表名，其中“discuzdb”为DiscuzX的数据库名称。
limit 10为显示贴子数量。
如果用伪静态地址可以用：/bbs/thread-<?=$bqr[tid]?>-1-1.html
如果指定单个版块的贴子，SQL用：select tid,subject,dateline from discuzdb.pre_forum_thread where fid=版块ID order by tid desc limit 10
如果指定多个版块的贴子，SQL用：select tid,subject,dateline from discuzdb.pre_forum_thread where fid in (1,2,3) order by tid desc limit 10
================================================

<table width="100%" border="0" cellspacing="0" cellpadding="0" class="box no_doc">
<tr>
<td><ul>
[e:loop={"select tid,subject,dateline from net01208633.pre_forum_thread order by tid desc limit 10",10,24,0}]
<li><a href="/bbs/thread-<?=$bqr[tid]?>-1-1.html" target="_blank"><?=$bqr[subject]?></a> (<?=date('Y-m-d',$bqr[dateline])?>)</li>
[/e:loop]
</ul></td></tr>
</table>

<table width="100%" border="0" cellspacing="0" cellpadding="0" class="box no_doc">
<tr>
<td><ul>
[e:loop={"select tid,subject,dateline from net01208633.pre_forum_thread家where fid in (1,2,3) order by tid desc limit 10",10,24,0}]
<li><a href="/bbs/thread-<?=$bqr[tid]?>-1-1.html" target="_blank"><?=$bqr[subject]?></a> (<?=date('Y-m-d',$bqr[dateline])?>)</li>
[/e:loop]
</ul></td></tr>
</table>