query("SELECT r.id, u.username AS sender_name, r.contents FROM reports r
JOIN users u ON u.id = r.sender_id
WHERE r.resolved_by IS NULL
ORDER BY r.sent_at DESC
");
$reports->execute();
$reports = $reports->fetchAll(PDO::FETCH_ASSOC);
$report = $reports[0] ?? null;
if (isset($_GET["id"])) {
$stmt = $db->prepare("SELECT r.id, u.id AS sender_id, u.username AS sender_name, r.contents, r.sent_at, resolved_by, response_message FROM reports r
JOIN users u ON u.id = r.sender_id
WHERE r.id = ?
");
$stmt->execute([$_GET["id"]]);
$report = $stmt->fetch(PDO::FETCH_ASSOC) ?? null;
}
?>
Report review - <?= CONFIG['instance']['name'] ?>