FabrikaHradekTour/res/forum/api/get_posts.php

<?php

include("../../global.php");
session_start();

if (!isset($_SESSION["username"])) goto fail;

$out = $database -> query("SELECT username FROM user WHERE BINARY username=\"" . $_SESSION["username"] . "\"");

if ($out -> num_rows != 1)
{
    fail:
    echo "nope";
    header("Location: ../../../index.php");
    return;
}

$out = $database -> query("SELECT title, description, photo_id, author FROM post WHERE archived=0 ORDER BY id DESC");

$output = array();

while (($res = $out -> fetch_assoc()))
{
    $buffer_array = array();

    foreach ($res as $key => $value)
    {
        $buffer_array[$key] = $value;
    }

    $author_buffer = $database -> query("SELECT username FROM user WHERE id=" . $value);
    if ($author_buffer -> num_rows == 1)
    {
        $buffer_array["username"] = ($author_buffer -> fetch_assoc())["username"];
    } else
    {
        $buffer_array["username"] = "[odstraněn]";
    }

    array_push($output, $buffer_array);
}

header('Content-type: application/json');
echo json_encode($output);