phpcms 获取文章的栏目

<?php
// 假设你已经连接到数据库
$article_id = 1; // 需要获取栏目的文章ID

// SQL 查询语句
$sql = "SELECT catid FROM v9_news WHERE id = :id";
$stmt = pc_base::load_model('content_model')->db->prepare($sql);
$stmt->bindParam(':id', $article_id, PDO::PARAM_INT);
$stmt->execute();

// 获取查询结果
$result = $stmt->fetch(PDO::FETCH_ASSOC);

if ($result) {
    $catid = $result['catid'];
    echo "文章的栏目ID是: " . $catid;

    // 获取栏目名称
    $category_sql = "SELECT catname FROM v9_category WHERE catid = :catid";
    $category_stmt = pc_base::load_model('category_model')->db->prepare($category_sql);
    $category_stmt->bindParam(':catid', $catid, PDO::PARAM_INT);
    $category_stmt->execute();

    $category_result = $category_stmt->fetch(PDO::FETCH_ASSOC);
    if ($category_result) {
        echo "文章的栏目名称是: " . $category_result['catname'];
    }
} else {
    echo "未找到文章的栏目信息";
}
?>