phpcms子栏目代码

<?php
// 假设我们已经获取到了子栏目的数据
$sub_categories = [
    ['id' => 1, 'name' => '子栏目1', 'url' => '/sub1/'],
    ['id' => 2, 'name' => '子栏目2', 'url' => '/sub2/'],
    ['id' => 3, 'name' => '子栏目3', 'url' => '/sub3/'],
];

?>
<ul>
    <?php foreach ($sub_categories as $sub_category): ?>
        <li><a href="<?php echo $sub_category['url']; ?>"><?php echo $sub_category['name']; ?></a></li>
    <?php endforeach; ?>
</ul>

// 检查数据库连接
$mysqli = new mysqli("localhost", "username", "password", "database");
if ($mysqli->connect_errno) {
    echo "Failed to connect to MySQL: " . $mysqli->connect_error;
    exit();
}

// 查询子栏目数据
$sql = "SELECT * FROM sub_categories WHERE parent_id = ?";
$stmt = $mysqli->prepare($sql);
$stmt->bind_param("i", $parent_id);
$stmt->execute();
$result = $stmt->get_result();
$sub_categories = $result->fetch_all(MYSQLI_ASSOC);

// 假设我们已经获取到了子栏目的数据
$sub_categories = [
    ['id' => 1, 'name' => '子栏目1', 'url' => '/sub1/'],
    ['id' => 2, 'name' => '子栏目2', 'url' => '/sub2/'],
    ['id' => 3, 'name' => '子栏目3', 'url' => '/sub3/'],
];

// 确保 URL 正确
foreach ($sub_categories as &$sub_category) {
    $sub_category['url'] = ensure_url($sub_category['url']);
}

function ensure_url($url) {
    if (substr($url, 0, 1) != '/') {
        $url = '/' . $url;
    }
    return $url;
}