| 用灵动标签调用外部数据： |
| 例一：调用Discuz的最新贴子 |
<table
width="100%" border="0" cellspacing="1"
cellpadding="3">
[e:loop={"select tid,subject,dateline
from discuzdb.cdb_threads order by tid desc limit 10",10,24,0}]
<tr><td>
<a href="/bbs/viewthread.php?tid=<?=$bqr[tid]?>"
target="_blank"><?=$bqr[subject]?></a>
(<?=date('Y-m-d',$bqr[dateline])?>)
</td></tr>
[/e:loop]
</table> |
|
discuzdb.cdb_threads为Discuz的贴子表名，其中“discuzdb”为Discuz的数据库名称。
limit 10为显示贴子数量。
如果用伪静态地址可以用：/bbs/thread-<?=$bqr[tid]?>-1-1.html
如果指定单个版块的贴子，SQL用：select
tid,subject,dateline from discuzdb.cdb_threads where
fid=版块ID order by tid desc limit 10
如果指定多个版块的贴子，SQL用：select tid,subject,dateline from
discuzdb.cdb_threads where fid in (1,2,3) order
by tid desc limit 10 |
| 例二：调用Discuz的最新贴子（含调用论坛版块名） |
<table
width="100%" border="0" cellspacing="1"
cellpadding="3">
[e:loop={"select tid,subject,dateline,fid
from discuzdb.cdb_threads order by tid desc limit 10",10,24,0}]
<?php
$fr=$empire->fetch1("select name from discuzdb.cdb_forums
where fid='$bqr[fid]'");
?>
<tr><td>
[<?=$fr[name]?>] <a href="/bbs/viewthread.php?tid=<?=$bqr[tid]?>"
target="_blank"><?=$bqr[subject]?></a>
(<?=date('Y-m-d',$bqr[dateline])?>)
</td></tr>
[/e:loop]
</table> |
|
| discuzdb.cdb_forums为Discuz的版块表名，其中“discuzdb”为Discuz的数据库名称。 |
| 例三：调用DiscuzX的最新贴子 |
<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 |
| 例四：调用DiscuzX的最新贴子（含调用论坛版块名） |
<table
width="100%" border="0" cellspacing="1"
cellpadding="3">
[e:loop={"select tid,subject,dateline,fid
from discuzdb.pre_forum_thread order by tid desc limit 10",10,24,0}]
<?php
$fr=$empire->fetch1("select name from discuzdb.pre_forum_forum
where fid='$bqr[fid]'");
?>
<tr><td>
[<?=$fr[name]?>] <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_forum为DiscuzX的版块表名，其中“discuzdb”为DiscuzX的数据库名称。 |
| 例五：调用PHPwind的最新贴子 |
<table
width="100%" border="0" cellspacing="1"
cellpadding="3">
[e:loop={"select tid,subject,postdate
from phpwinddb.pw_threads order by tid desc limit 10",10,24,0}]
<tr><td>
<a href="/bbs/read.php?tid=<?=$bqr[tid]?>" target="_blank"><?=$bqr[subject]?></a>
(<?=date('Y-m-d',$bqr[postdate])?>)
</td></tr>
[/e:loop]
</table> |
|
phpwinddb.pw_threads为phpwind的贴子表名，其中“phpwinddb”为phpwind的数据库名称。
limit 10为显示贴子数量。
如果用伪静态地址可以用：/bbs/read-htm-tid-<?=$bqr[tid]?>.html
如果指定单个版块的贴子，SQL用：select
tid,subject,postdate from phpwinddb.pw_threads where
fid=版块ID order by tid desc limit 10
如果指定多个版块的贴子，SQL用：select tid,subject,postdate from
phpwinddb.pw_threads where fid in (1,2,3) order
by tid desc limit 10 |
| 例六：调用PHPwind的最新贴子（含调用论坛版块名） |
<table
width="100%" border="0" cellspacing="1"
cellpadding="3">
[e:loop={"select tid,subject,postdate,fid
from phpwinddb.pw_threads order by tid desc limit 10",10,24,0}]
<?php
$fr=$empire->fetch1("select name from phpwinddb.pw_forums
where fid='$bqr[fid]'");
?>
<tr><td>
[<?=$fr[name]?>] <a href="/bbs/read.php?tid=<?=$bqr[tid]?>"
target="_blank"><?=$bqr[subject]?></a>
(<?=date('Y-m-d',$bqr[postdate])?>)
</td></tr>
[/e:loop]
</table> |
|
| phpwinddb.pw_forums为phpwind的版块表名，其中“phpwinddb”为phpwind的数据库名称。 |
灵动标签调用外部数据