<?php header("Content-Type: application/json"); //Set header for outputing the JSON information require_once $_SERVER['DOCUMENT_ROOT'] . '/includes/autoload.php'; try { $mysqli = Database::connection(); $user = User::get_current_user(); //To check if the user has joined in on this date $sql = "SELECT t1.date_id, t1.datename, t1.begin_datetime, t1.end_datetime, t1.confirmed, t1.bool_group, t2.username, t2.email, t2.reputation, t2.avatar, t3.status, t1.creator_id as `user_id` FROM `badminton_dates` as t1 LEFT JOIN users as t2 ON t2.user_id = t1.creator_id LEFT JOIN `joins` as t3 ON t3.date_id = t1.date_id WHERE t1.confirmed = '" . BadmintonDate::CONFIRMED . "'"; $result = $mysqli->query($sql) or die ($mysqli->error); $dates = array(); while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { $row['creator'] = new ProfileUser($row); $badminton_date = new ConfirmedBadmintonDate($row); $badminton_date->get_attendees(); array_push($dates, $badminton_date); } http_response_code(200); echo json_encode($dates, JSON_PRETTY_PRINT); } catch (Exception $e) { http_response_code(400); Database::print_exception($e); } ?>