指定关键词调用
数据库查询方法,
select * from [!db.pre!]ecms_news where classid <434 and title like '%球阀%' order by id desc
[e:loop={15,8,0,0,"字段名 like '%淡季%'",''}]
比如调用标题带有淡季这个单词的文章
[e:loop={'news',10,18,0,"title like '%淡季%'",''}]
如果是自定也列表的话,调用关键词,用这个方法,
或者用下面的方法获取,现获取关键词,在调用,classid >434 and是要显示的id
<?php
$pageid=str_replace("list","",$classid);
$cr2=$empire->fetch1("select pagekeywords from phome_enewsuserlist where listid= '".$GLOBALS[navclassid]." limit 1'");
$dcm=$cr2['pagekeywords'];
$ecms_bq_sql=sys_ReturnEcmsLoopBq("select * from phome_ecms_news where classid >434 and title like '%".$dcm."%' order by newstime limit 10",14,24,0);
while($bqr=$empire->fetch($ecms_bq_sql))
{
?>
<div class="proclass_nav"><a href="<?=$bqr['titleurl']?>" title="<?=$bqr['title']?>"><?=$bqr['title']?></a></div>
<?php
}
?>
当前目录:帝国CMS教程
帝国cms指定关键词调用 数据库查询方法
帝国CMS教程 2025-04-03 15:51:32
上一篇:帝国cms按照内容id调用数据