dedecms 调用相关文章

<?php
// 获取当前文章的ID
$aid = $_GET['aid'];

// 查询当前文章的标签
$sql = "SELECT tag FROM dede_taglist WHERE aid = $aid";
$result = mysqli_query($conn, $sql);
$row = mysqli_fetch_assoc($result);
$tags = explode(',', $row['tag']);

// 查询与当前文章标签相关的文章
$related_articles = [];
foreach ($tags as $tag) {
    $sql = "SELECT aid, title FROM dede_archives WHERE tag LIKE '%$tag%' AND aid != $aid LIMIT 5";
    $result = mysqli_query($conn, $sql);
    while ($row = mysqli_fetch_assoc($result)) {
        $related_articles[] = $row;
    }
}

// 输出相关文章
foreach ($related_articles as $article) {
    echo '<a href="/plus/view.php?aid=' . $article['aid'] . '">' . $article['title'] . '</a><br>';
}
?>