phpcms 获取顶级栏目

<?php
// 假设你已经加载了phpcms的框架和数据库连接
$catid = intval($_GET['catid']); // 获取当前栏目ID
$siteid = 1; // 假设站点ID为1

// 获取顶级栏目
$sql = "SELECT * FROM v9_category WHERE parentid = 0 AND siteid = $siteid";
$result = pc_base::load_model('category_model')->query($sql);

while ($row = $result->fetch_assoc()) {
    echo "ID: " . $row['catid'] . ", Name: " . $row['catname'] . "<br>";
}
?>

<?php
// 假设你已经加载了phpcms的框架和数据库连接
$catid = intval($_GET['catid']); // 获取当前栏目ID
$siteid = 1; // 假设站点ID为1

// 检查缓存
$cache_key = 'top_category_' . $siteid;
$top_categories = pc_base::load_app_class('cache', '', 'cache')->get($cache_key);

if (!$top_categories) {
    // 获取顶级栏目
    $sql = "SELECT * FROM v9_category WHERE parentid = 0 AND siteid = $siteid";
    $result = pc_base::load_model('category_model')->query($sql);

    $top_categories = [];
    while ($row = $result->fetch_assoc()) {
        $top_categories[] = $row;
    }

    // 设置缓存
    pc_base::load_app_class('cache', '', 'cache')->set($cache_key, $top_categories, 3600); // 缓存1小时
}

foreach ($top_categories as $row) {
    echo "ID: " . $row['catid'] . ", Name: " . $row['catname'] . "<br>";
}
?>