帝国cms文章内容页相关文章按照关键字调用没有则随机显示
编辑:覃师宁来源:qinshining.com时间:2020-05-09 01:27:03阅读量:170
帝国cms内容页相关文章,一般我们都是以通栏目文章信息调用。但是为了增强文章阅读的相关性,我们也可以根据关键字调用相关文章,也就是说文章设置了关键字,则调用相同关键字的文章,如果没有设置关键字,则随机文章显示。
关键字设置
相关文章图
内容页相关文章按关键字调用代码:
<?phpif ($navinfor[keyboard]){$c_key=explode(,,$navinfor[keyboard]);$count=count($c_key);for($i=0;$i<$count;$i++){if($i==0){$or=;}else{$or= or ;}$repadd.=$or."keyboard like %".$c_key[$i]."%";}$r=$empire->fetch1("select * from {$dbtbpre}ecms_news where id<>".$navinfor[id]." and ".$repadd." order by newstime desc limit 1");if($r[title]){$mesql=$empire->query("select titleurl,title,newstime from {$dbtbpre}ecms_news where id<>".$navinfor[id]." and ".$repadd." order by newstime desc limit 10");while($or=$empire->fetch($mesql)){$newstime=date(Y-m-d,$or[newstime]);?><li><a href="<?=$or[titleurl]?>"><?=$or[title]?></a><span><?=$newstime?></span></li><?}}else{$mesql2=$empire->query("select * from {$dbtbpre}ecms_news where id<>".$navinfor[id]." order by rand() desc limit 10");while($r2=$empire->fetch($mesql2)){$newstime=date(Y-m-d,$o2[newstime]);?><li><a href="<?=$r2[titleurl]?>"><?=$r2[title]?></a><span><?=$newstime?></span></li><?}}}else{$mesql2=$empire->query("select titleurl,title,newstime from {$dbtbpre}ecms_news order by rand() desc limit 10");while($r2=$empire->fetch($mesql2)){$newstime=date(Y-m-d,$r2[newstime]);?><li><a href="<?=$r2[titleurl]?>"><?=$r2[title]?></a><span><?=$newstime?></span></li><?}}?>标签: