phpcms调用多个栏目内容

<?php
// 假设我们有一个函数 get_category_content 用于获取栏目内容
function get_category_content($category_id) {
    // 连接数据库
    $db = new PDO('mysql:host=localhost;dbname=phpcms', 'username', 'password');
    
    // 查询指定栏目的内容
    $stmt = $db->prepare("SELECT * FROM content WHERE category_id = :category_id");
    $stmt->bindParam(':category_id', $category_id, PDO::PARAM_INT);
    $stmt->execute();
    
    return $stmt->fetchAll(PDO::FETCH_ASSOC);
}

// 获取多个栏目的内容
$categories = [1, 2, 3]; // 假设我们要获取栏目ID为1, 2, 3的内容
$contents = [];

foreach ($categories as $category_id) {
    $contents[$category_id] = get_category_content($category_id);
}

// 在前端展示内容
foreach ($contents as $category_id => $items) {
    echo "<h2>栏目ID: $category_id</h2>";
    foreach ($items as $item) {
        echo "<h3>{$item['title']}</h3>";
        echo "<p>{$item['content']}</p>";
    }
}
?>