在文章比较少往往调用相关链接少或完全调用不出。下面介绍一种根据关键字自定义调用,若没有关键字将调用最新的发布新闻
<?php
$kwd=$navinfor['keyboard'];
$id=$navinfor['id'];
if($kwd!=''){
$like=strtolike($kwd,'title');
$sql="select id,classid,title,titlepic from {$dbtbpre}ecms_news where $like and id!=$id order by id desc limit 8";
}else{
$sql="select id,classid,title,titlepic from {$dbtbpre}ecms_news where classid={$navinfor['classid']} and id!=$id order by id desc limit 8";
}
?>
[e:loop={"{$sql}",8,24,0}]
<li style="position:relative;">
<a class="thumbnail" href="<?=$bqsr['titleurl']?>"><img src="[!--news.url--]skin/nvshen/images/vico.png" data-src="<?=$bqr['titlepic']?>" class="thumb"><span style="display:block;"><?=$bqr['title']?></span>
<div class="zoomOverlays"></div>
</a>
</li>
[/e:loop]
其中的[backcolor=rgb(247, 247, 247)]strtolike函数在e/class/[/backcolor]userfun.php自定义函数,具体代码如下:
//关键字组合成查询条件
function strtolike($kwd,$field){
$akwd=explode(',',$kwd);
$link='';
foreach ($akwd as $v){
$link.=$field.' LIKE "%'.$v.'%" OR ';
}
return trim(trim($link),'OR');
}