ON t2.user_id = t1.creator_id
WHERE MONTH(date_id) = MONTH('$date_string')
ORDER BY t1.begin_datetime ASC";
$result = $mysqli->query($sql)
or die ($mysqli->error);
$dates = array();
while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
$row['creator'] = new ProfileUser($row);
if ($row['confirmed']) {
$badminton_date = new ConfirmedBadmintonDate($row);
}
else {
if ($row['bool_group']) {
$badminton_date = new GrouProposedDate($row);
}
else {
$badminton_date = new PublicProposedDate($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_exceptoin($e);
}
?>
