select_post.php

<?php
include("./connection.php");
$return_data = array(
    "post_data" =>  [],
);
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $class = $_POST['class'];
}
if ($_SERVER['REQUEST_METHOD'] === 'GET') {
}
$select_sql = "SELECT
post.id,
post.title,
post.author,
post.content,
post.class,
post.create_time,
post.user_id,
`user`.image
FROM
post
INNER JOIN `user` ON post.user_id = `user`.id
WHERE
post.class = $class
";
$query = mysqli_query($connection, $select_sql);
while ($item = mysqli_fetch_assoc($query)) {
    $items[] = $item;
}
for ($i = 0; $i < count($items); $i++) {
    $data = array(
        "post_id" => $items[$i]['id'],
        "post_author" => $items[$i]['author'],
        "post_class" => $items[$i]['class'],
        "post_title" => $items[$i]['title'],
        "post_content" => $items[$i]['content'],
        "post_create_time" => $items[$i]['create_time'],
        "post_author_image" => $items[$i]['image']
    );
    array_push($return_data["post_data"], $data);
}

echo json_encode($return_data);
//回傳所有文章的資料
// $comment_sql = "INSERT INTO comment VALUES(null,$user,$content)";