织梦模板栏目根据关键字调用相关文章

{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 `dede_archives` arc LEFT JOIN `dede_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>”;

}

@me = $result;

{/dede:field.keywords}