dedecms自动给已经发布过的文章中的关键词加超链

乐清SEO_开发应用_dedecms_ 乐清SEO2021-01-19 转载自:

代码如下:

foreach($kws as $k)
{
$k = trim($k);
if($k!=”")
{
if($i > $maxkey)
{
break;
}
$myrow = $this->dsql->GetOne(“select * from dede_keywords where keyword=’$k’ And rpurl<>” “);
if(is_array($myrow))
{
$karr[] = $k;
$GLOBALS['replaced'][$k] = 0;
$kaarr[] = “<a href=’{$myrow['rpurl']}’><u>$k</u></a>”;
}
$i++;
}
}

把它替换成：

复制代码

代码如下:

global $dsql;
$query=”SELECT * FROM dede_keywords WHERE rpurl<>” ORDER BY rank DESC”;
$dsql->SetQuery($query);
$dsql->Execute();
while($row = $dsql->GetArray())
{
$key = trim($row['keyword']);
$key_url=trim($row['rpurl']);
$karr[] = $key;
$kaarr[] = “<a href=’$key_url’ target=’_blank’><u>$key</u></a>”;
}