dedecms tag标签生成器

// 添加标签到文章
function add_tags_to_article($aid, $tags) {
    global $dsql;
    $tagids = array();
    foreach ($tags as $tag) {
        $row = $dsql->GetOne("SELECT id FROM `dede_tagindex` WHERE tagname='$tag'");
        if ($row) {
            $tagids[] = $row['id'];
        } else {
            $dsql->ExecuteNoneQuery("INSERT INTO `dede_tagindex` (tagname) VALUES ('$tag')");
            $tagids[] = $dsql->GetLastID();
        }
    }
    $tagids_str = implode(',', $tagids);
    $dsql->ExecuteNoneQuery("UPDATE `dede_archives` SET tagid='$tagids_str' WHERE id='$aid'");
}

// 显示文章标签
function display_article_tags($aid) {
    global $dsql;
    $row = $dsql->GetOne("SELECT tagid FROM `dede_archives` WHERE id='$aid'");
    if ($row) {
        $tagids = explode(',', $row['tagid']);
        foreach ($tagids as $tagid) {
            $tag_row = $dsql->GetOne("SELECT tagname FROM `dede_tagindex` WHERE id='$tagid'");
            if ($tag_row) {
                echo "<a href='/tags.php?/".urlencode($tag_row['tagname'])."/'>{$tag_row['tagname']}</a> ";
            }
        }
    }
}