織夢(mèng)采用關(guān)鍵字欄目調(diào)用相關(guān)文章方法

來(lái)源：本站原創(chuàng)|時(shí)間：2021-08-05|欄目：dedecms|點(diǎn)擊：次

調(diào)用相關(guān)文章，如果是內(nèi)容頁(yè)調(diào)用則不包含當(dāng)前這一篇文章

把下面代碼放到模板你想顯示的位置

{dede:field.keywords runphp=yes}

global $dsql,$id,$aid;

$aid = isset($id) ? $id : $aid;

$keyword = '';

if(!empty(@me))

{

$keywords = explode(',' , trim(@me));

$keyword = '';

$n = 1;

foreach($keywords as $k)

{

if($n > 3) break;

if(trim($k)=='') continue;

else $k = addslashes($k);

$keyword .= ($keyword=='' ? " CONCAT(arc.keywords,' ',arc.title) LIKE '%$k%' " : " OR CONCAT(arc.keywords,' ',arc.title) LIKE '%$k%' ");

$n++;

}

if($keyword != '')

{

$sql = "SELECT arc.*,tp.typedir,tp.typename,tp.corank,tp.isdefault,tp.defaultname,tp.namerule,tp.namerule2,tp.ispart,tp.moresite,tp.siteurl,tp.sitepath FROM `archives` arc LEFT JOIN `arctype` tp ON arc.typeid=tp.id where arc.arcrank>-1 AND ($keyword) AND arc.id<>'$aid' ORDER BY arc.id desc limit 0, 10";

}

$dsql->SetQuery($sql);

$dsql->Execute('t');

$result = '';

while($row = $dsql->GetArray('t'))

{

$arcrow = GetOneArchive($row['id']);

$row['arcurl'] = $arcrow['arcurl'];

$row['pubdate'] = MyDate('Y-m-d',$row['pubdate']);

$row['litpic'] = $row['litpic'] = $row['litpic']=='' ? '/images/defaultpic.gif' : $row['litpic'];

$result .= "<li><a href=\"{$row['arcurl']}\"><img src=\"{$row['litpic']}\">{$row['title']}</a></li>";

}