调用友情链接:
[e:loop={‘select * from [!db.pre!]enewslink where checked=1 order by lid’,20,24,0}]
<a href=”<?=$bqr[lurl]?>”><?=$bqr[lname]?></a>
[/e:loop]
———————————————————————————————————
调用所有一级栏目：
[e:loop={‘select classid,classname,classpath,wburl from [!db.pre!]enewsclass where bclassid=0 and showclass=0 order by myorder’,0,24,0}]
<li><a href=”<?php
if(empty($bqr[wburl]))
{
echo $public_r[newsurl].$bqr[classpath];
} else {
echo $bqr[wburl];
}
?>” title=”<?=$bqr[classname]?>” target=”_self”><?=$bqr[classname]?></a></li>[/e:loop]
———————————————————————————————————
一级二级栏目循环：
<dl>
[e:loop={“select classid,classname,islast from {$dbtbpre}enewsclass where bclassid=’0′ order by myorder,classid ASC limit 11″,0,24,0}]
<?php
$classurl=sys_ReturnBqClassname($bqr,9);//取得栏目地址
$tbname=$class_r[$bqr[classid]][tbname]; //取得表名
?>
<dt><a href=”<?=$classurl?>” target=”_blank”><b><?=$bqr[classname]?></b></a></dt>
<dd>
<?php if(!$bqr[islast]){ ?>
<?php
//取得栏目下的子栏目
$newsclass=$empire->query(“select classid,classname from “.$dbtbpre.”enewsclass where bclassid=”.$bqr[classid].” order by myorder,classid desc limit 10″);
while($classr=$empire->fetch($newsclass)) {
$classrurl=sys_ReturnBqClassname($classr,9); //取得子栏目地址
?>
<a href=”<?=$classrurl?>”><?=$classr[classname]?></a>
<?php
}
?>
<?php
}else{
?>
<?php
//取得栏目下的信息
$newsinfo=$empire->query(“select * from “.$dbtbpre.”ecms_”.$tbname.” where classid=”.$bqr[classid].” order by newstime desc limit 10″);
while($infor=$empire->fetch($newsinfo)) {
$titleurl=sys_ReturnBqTitleLink($infor);
?>
<a href=”<?=$$titleurl?>”><?=$newsinfo[title]?></a>
<?php
}
?>
<?
}
?>
</li>
[/e:loop]
</dd>
</dl>
———————————————————————————————————
调用指定父栏目下的子栏目
[e:loop={“select classid,classname from {$dbtbpre}enewsclass where bclassid=IDorder by myorder,classid desc”,0,24,0}]
<?php
$classurl=sys_ReturnBqClassname($bqr,9);//取得栏目地址
?>
<a href=”<?=$classurl?>”><?=$bqr[classname]?></a>
[/e:loop]
———————————————————————————————————
帝国CMS顶级栏目调用所有顶级栏目的方法
[e:loop={“select * from phome_enewsclass where bclassid in (0) order by classid asc”,0,24,0}] <li><a href=”/<?=$bqr[classpath]?>”><?=$bqr[classname]?></a></li> [/e:loop]
———————————————————————————————————
列表页面调用 栏目名称+标题 [栏目] 标题
[<a href=”<?=$class_r[$bqr[classurl]]?> ” target=”_blank”><?=$class_r[$bqr[classid]][classname]?></a>] <a href=”<?=$bqsr[‘titleurl’]?>” target=”_blank”><?=$bqr[‘title’]?></a>
列表页面调用 栏目名称+标题 [栏目] 标题 时间
[<a href=”<?=$class_r[$bqr[classurl]]?> ” target=”_blank”><?=$class_r[$bqr[classid]][classname]?></a>] <a href=”<?=$bqsr[‘titleurl’]?>” target=”_blank”><?=$bqr[‘title’]?></a><span><?=date(‘Y-m-d’,$bqr[newstime])?></span>
——————————————————————————————————–
调用当前栏目父级栏目下的所以子栏目排除当下栏目
<?php $tl_thisclassid=$GLOBALS[navclassid];
$tl_bclassid=$class_r[$tl_thisclassid][bclassid];
$tl_class_sql=$empire->query(“select classid,classname from {$dbtbpre}enewsclass where bclassid=’”.$tl_bclassid.”‘ and showclass=0 order by myorder,classid desc”);while($tl_class_r=$empire->fetch($tl_class_sql)){ if($tl_class_r[classid]==$tl_thisclassid){continue;}?>
<li><a href=”<?=sys_ReturnBqClassname($tl_class_r,9)?>”><?=$tl_class_r[classname]?></a></li><?}?>
—————————————————————-
调用父级栏目下子栏目
<?
$bclassid = $class_r[$GLOBALS[navclassid]][bclassid]; //获取当前父栏目ID
?>
[e:loop={“select classid,classname,classpath from [!db.pre!]enewsclass where bclassid =’$bclassid’ order by classid”,0,24,0}]<!-取得父栏目下的子栏目->
<ul><li><a href=”<?=$public_r[newsurl].$bqr[classpath]?>/”><?=$bqr[classname]?></a></li></ul>
[/e:loop]
———————————————————————————————–
调用当前栏目下的子栏目
[e:loop={“select classid,classname,classpath from [!db.pre!]enewsclass where bclassid =’$GLOBALS[navclassid]’ order by classid”,0,24,0}]<!-取得父栏目下的子栏目->
<ul><li><a href=”<?=$public_r[newsurl].$bqr[classpath]?>/”><?=$bqr[classname]?></a></li></ul>
[/e:loop]