dedecms tags标签

<?php
// 添加标签
function addTag($title, $keywords) {
    global $dsql;
    $tagid = $dsql->GetOne("SELECT id FROM `dede_tagindex` WHERE keyword='$keywords'");
    if (!$tagid) {
        $dsql->ExecuteNoneQuery("INSERT INTO `dede_tagindex` (keyword, title) VALUES ('$keywords', '$title')");
        $tagid = $dsql->GetLastID();
    }
    $dsql->ExecuteNoneQuery("INSERT INTO `dede_taglist` (aid, typeid, tagid) VALUES ('$aid', '$typeid', '$tagid')");
}

// 显示标签
function showTags($aid) {
    global $dsql;
    $tags = array();
    $row = $dsql->GetOne("SELECT tagid FROM `dede_taglist` WHERE aid='$aid'");
    if ($row) {
        $tagids = explode(',', $row['tagid']);
        foreach ($tagids as $tagid) {
            $row = $dsql->GetOne("SELECT keyword, title FROM `dede_tagindex` WHERE id='$tagid'");
            if ($row) {
                $tags[] = '<a href="/tags.php?/keyword/'.$row['keyword'].'/">'.$row['title'].'</a>';
            }
        }
    }
    return implode(', ', $tags);
}
?>