phpcms当前父级栏目名称

<?php
// 假设当前栏目 ID 为 $catid
$catid = 10; // 示例 ID

// 连接数据库
$db = new mysqli('localhost', 'username', 'password', 'phpcms');

// 查询父级栏目名称
$sql = "SELECT parentid, catname FROM v9_category WHERE catid = $catid";
$result = $db->query($sql);

if ($result->num_rows > 0) {
    $row = $result->fetch_assoc();
    $parentid = $row['parentid'];
    if ($parentid > 0) {
        $sql_parent = "SELECT catname FROM v9_category WHERE catid = $parentid";
        $result_parent = $db->query($sql_parent);
        if ($result_parent->num_rows > 0) {
            $row_parent = $result_parent->fetch_assoc();
            echo "父级栏目名称: " . $row_parent['catname'];
        } else {
            echo "当前栏目没有父级栏目";
        }
    } else {
        echo "当前栏目是顶级栏目";
    }
} else {
    echo "查询失败";
}

$db->close();
?>