帝国CMS首页调用评论表信息内容 分别使用PHP以及灵动标签方式

1、帝国CMS模板php调用评论时间+评论内容+文章地址

<?php
$sql=$empire->query("select * from {$dbtbpre}enewspl_1 order by saytime limit 10"); 
while($r=$empire->fetch($sql))   //循环获取查询记录
{
echo "<li><span class='time'>".date('m-d',$r[saytime])."</span><a target=_blank href='/e/action/ShowInfo.php?classid=".$r['classid']."&id=".$r['id']."'>".$r['saytext']."</a></li>";
}
?>

2、帝国CMS模板灵动标签调用评论时间+评论内容+文章地址

[e:loop={"select * from {$dbtbpre}enewspl_1 order by saytime limit 10",0,24,0}]
<li><span><?=date('Y-m-d',$bqr[saytime])?></span><a href="<?=$public_r[newsurl]?>e/action/ShowInfo.php?classid=<?=$bqr['classid']?>&id=<?=$bqr['id']?>" target="_blank"><?=$bqr['saytext']?></a> </li>
[/e:loop]

3、帝国CMS模板灵动标签调用评论时间+评论内容+评论地址

[e:loop={"select * from {$dbtbpre}enewspl_1 order by saytime limit 10",0,24,0}]
<li><span><?=date('Y-m-d',$bqr[saytime])?></span><a href="<?=$public_r[newsurl]?>e/pl/?classid=<?=$bqr['classid']?>&id=<?=$bqr['id']?>" target="_blank"><?=$bqr['saytext']?></a> </li>
[/e:loop]