dedecms 获取上级栏目名称

<?php
// 连接数据库
$cfg_dbhost = 'localhost';
$cfg_dbname = 'dedecms';
$cfg_dbuser = 'root';
$cfg_dbpwd = 'password';
$cfg_dbprefix = 'dede_';

$conn = mysqli_connect($cfg_dbhost, $cfg_dbuser, $cfg_dbpwd, $cfg_dbname);
if (!$conn) {
    die('连接失败: ' . mysqli_connect_error());
}

// 当前栏目ID
$catid = 10; // 假设当前栏目ID为10

// 查询当前栏目的父栏目ID
$sql = "SELECT reid FROM dede_arctype WHERE id = $catid";
$result = mysqli_query($conn, $sql);
$row = mysqli_fetch_assoc($result);
$parentid = $row['reid'];

// 如果存在父栏目，查询父栏目的名称
if ($parentid != 0) {
    $sql_parent = "SELECT typename FROM dede_arctype WHERE id = $parentid";
    $result_parent = mysqli_query($conn, $sql_parent);
    $row_parent = mysqli_fetch_assoc($result_parent);
    $parenttypename = $row_parent['typename'];
} else {
    $parenttypename = '顶级栏目';
}

echo "上级栏目名称: " . $parenttypename;

// 关闭数据库连接
mysqli_close($conn);
?>