php实现标签效果

PHP实现标签效果的方法

数据库设计

创建标签表tags和关联表post_tags，结构如下：

CREATE TABLE `tags` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
);

CREATE TABLE `post_tags` (
  `post_id` int(11) NOT NULL,
  `tag_id` int(11) NOT NULL,
  PRIMARY KEY (`post_id`,`tag_id`)
);

添加标签功能

// 处理表单提交
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $postId = $_POST['post_id'];
    $tagNames = explode(',', $_POST['tags']);

    foreach ($tagNames as $tagName) {
        $tagName = trim($tagName);
        if (!empty($tagName)) {
            // 检查标签是否存在
            $stmt = $pdo->prepare("SELECT id FROM tags WHERE name = ?");
            $stmt->execute([$tagName]);
            $tag = $stmt->fetch();

            if (!$tag) {
                // 创建新标签
                $stmt = $pdo->prepare("INSERT INTO tags (name) VALUES (?)");
                $stmt->execute([$tagName]);
                $tagId = $pdo->lastInsertId();
            } else {
                $tagId = $tag['id'];
            }

            // 关联文章和标签
            $stmt = $pdo->prepare("INSERT IGNORE INTO post_tags (post_id, tag_id) VALUES (?, ?)");
            $stmt->execute([$postId, $tagId]);
        }
    }
}

显示标签功能

// 获取文章的标签
function getPostTags($postId) {
    global $pdo;
    $stmt = $pdo->prepare("
        SELECT t.id, t.name 
        FROM tags t
        JOIN post_tags pt ON t.id = pt.tag_id
        WHERE pt.post_id = ?
    ");
    $stmt->execute([$postId]);
    return $stmt->fetchAll(PDO::FETCH_ASSOC);
}

// 显示标签
$tags = getPostTags($postId);
foreach ($tags as $tag) {
    echo '<a href="/tag/'.$tag['id'].'" class="tag">'.$tag['name'].'</a>';
}

标签云实现

// 获取热门标签
function getPopularTags($limit = 20) {
    global $pdo;
    $stmt = $pdo->prepare("
        SELECT t.id, t.name, COUNT(pt.post_id) as count
        FROM tags t
        JOIN post_tags pt ON t.id = pt.tag_id
        GROUP BY t.id
        ORDER BY count DESC
        LIMIT ?
    ");
    $stmt->execute([$limit]);
    return $stmt->fetchAll(PDO::FETCH_ASSOC);
}

// 显示标签云
$tags = getPopularTags();
foreach ($tags as $tag) {
    $size = min(24, 10 + $tag['count'] * 2);
    echo '<a href="/tag/'.$tag['id'].'" style="font-size:'.$size.'px">'.$tag['name'].'</a>';
}

标签搜索功能

// 根据标签筛选文章
function getPostsByTag($tagId) {
    global $pdo;
    $stmt = $pdo->prepare("
        SELECT p.* 
        FROM posts p
        JOIN post_tags pt ON p.id = pt.post_id
        WHERE pt.tag_id = ?
        ORDER BY p.created_at DESC
    ");
    $stmt->execute([$tagId]);
    return $stmt->fetchAll(PDO::FETCH_ASSOC);
}

CSS样式示例

.tag {
    display: inline-block;
    background-color: #f0f0f0;
    color: #333;
    padding: 2px 8px;
    margin: 2px;
    border-radius: 3px;
    text-decoration: none;
    font-size: 14px;
}

.tag:hover {
    background-color: #e0e0e0;
}

这些方法提供了完整的标签系统实现方案，包括数据库设计、标签管理、显示样式和搜索功能。可以根据具体需求调整代码和样式。