phpcms专题 子分类

// 数据库查询示例
$query = "SELECT * FROM `categories` WHERE `parent_id` = $parent_id";
$result = mysqli_query($conn, $query);

if (!$result) {
    die("Query failed: " . mysqli_error($conn));
}

while ($row = mysqli_fetch_assoc($result)) {
    echo "<a href='category.php?id={$row['id']}'>{$row['name']}</a><br>";
}

// 权限验证示例
$user_id = $_SESSION['user_id'];
$cat_id = $_GET['id'];

$query = "SELECT `access_level` FROM `category_permissions` WHERE `user_id` = $user_id AND `cat_id` = $cat_id";
$result = mysqli_query($conn, $query);

if (mysqli_num_rows($result) > 0) {
    $row = mysqli_fetch_assoc($result);
    if ($row['access_level'] >= $required_access_level) {
        // 用户有权限访问该子分类
    } else {
        echo "Access denied.";
    }
} else {
    echo "Access denied.";
}