PHPCMS 根據(jù)關(guān)鍵字獲取相關(guān)文章的方法

實(shí)現(xiàn)根據(jù)文章的關(guān)鍵字獲取當(dāng)前文章的相關(guān)文章的方法，在文章模板中需要顯示相關(guān)信息的地方插入:

<?php
if(!is_numeric($contentid)) $contentid=0;
$a = "";
$b = "";
$aa = "";
$bb = "";
if ($r[keywords]){
$keywords1 = get_sql_in($r[keywords]);
$a = $db -> select ("SELECT DISTINCT c.contentid,c.title,c.style,c.url FROM `phpcms_content` c,`phpcms_content_tag` t WHERE c.contentid=t.contentid and c.`status`=99 AND t.`tag` IN(".$keywords1.") and c.contentid!=".$contentid." ORDER BY c.listorder DESC,c.inputtime DESC,c.contentid desc limit 0,5");
if ($a){
foreach($a as $r){
$aa .= "<dd><a href="".$r[url]."" target="_blank">".$r[title]."</a></dd>";
}
?>
<dl class="xiangguan">
<dt>相關(guān)閱讀：</dt>
<?php echo $aa;?>
</dl>
<?php
}
}
$b = $db -> select ("SELECT DISTINCT b.specialid,b.url,b.title FROM `phpcms_special_content` a,`phpcms_special` b WHERE a.contentid=".$contentid." and b.specialid=a.specialid ORDER BY b.listorder DESC,b.createtime desc limit 0,5");
if ($b){
foreach($b as $r){
$bb .= "<dd><a href="".$r[url]."" target="_blank">".$r[title]."</a></dd>";
}
?>
<dl class="xiangguan">
<dt>相關(guān)專題：</dt>
<?php echo $bb;?>
</dl>
<?php
}
?>

生活不易，碼農(nóng)辛苦
如果您覺(jué)得本網(wǎng)站對(duì)您的學(xué)習(xí)有所幫助,可以手機(jī)掃描二維碼進(jìn)行捐贈(zèng)