掌握帝国CMS内容页关键词调用技巧,轻松实现个性化推荐
帝国cms 内容页根据关键词来调用相关内容,如果没有相关内容则随机获得文章代码。
-
- <?php
- if ($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>;
- <?
- }
- }
- ?>;
复制代码
如修改文章条数的话,把limit后面的数字改一下就好了。
|