tags标签列表页自动匹配标题相关的文章

帝国cms标签列表自动匹配相关文章

<?
  $tagname=RepPostVar($_GET['tagname']);
  $thistagid=$empire->fetch1("select tagid from {$dbtbpre}enewstags where tagname = '$tagname' limit 1");
  $thistagid=$thistagid['tagid'];
  $sql=$empire->query("select stb,id,titlepic,title,titleurl,newstime,classid from {$dbtbpre}ecms_news where title like '%$tagname%' order by id desc limit 10");
  while($bqr=$empire->fetch($sql)){
      $bqsr=sys_ReturnEcmsLoopStext($bqr);
      $bqno++;
      $fr=$empire->fetch1("select infotags from {$dbtbpre}ecms_news_data_{$bqr[stb]} where id='$bqr[id]'");
      $infotags=$fr['infotags'];
      $r_tag=explode(",",$infotags);
      for($i=0;$i<count($r_tag);$i++){
          if($r_tag[$i]){
              $tagslink=$public_r[newsurl]."tags-".$r_tag[$i]."-0.html";
              $tags.="<a href='$tagslink' target='_blank'>".$r_tag[$i]."</a> ";
          }
      }
  ?>
<?
$check=$empire->fetch1("select id from {$dbtbpre}enewstagsdata where id=$bqr[id] and tagid=$thistagid limit 1");
if(!$check){
?>
<li>
    <a href="<?=$bqr[titleurl]?>" target="_blank"><?=$bqr[title]?></a>
    <p><?=$bqr[smalltext]?>...</p>
    <div class="newsclass">
      <span class="thisclass"><a href="/<?=$class_r[$bqr[classid]][classpath]?>/" target="_blank"><?=$class_r[$bqr[classid]][classname]?></a></span>
      <span class="thistags"><?=$tags?></span>
    </div>
</li>
<?php
  }
  }
?>

附注