<?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);
}
?>