phpcms调用所有子栏目

<?php
// 假设数据库连接信息
$host = 'localhost';
$dbname = 'phpcms';
$user = 'username';
$pass = 'password';

// 创建 PDO 连接
try {
    $pdo = new PDO("mysql:host=$host;dbname=$dbname;charset=utf8", $user, $pass);
} catch (PDOException $e) {
    die("数据库连接失败: " . $e->getMessage());
}

// 查询所有子栏目
try {
    $stmt = $pdo->query("SELECT * FROM v9_category WHERE parentid > 0");
    $subcategories = $stmt->fetchAll(PDO::FETCH_ASSOC);
} catch (PDOException $e) {
    die("查询失败: " . $e->getMessage());
}

// 输出子栏目
foreach ($subcategories as $subcategory) {
    echo "ID: " . $subcategory['catid'] . ", 名称: " . $subcategory['catname'] . "<br>";
}
?>