<?php include_once "../include/transporter.php"; //only for testing //$_GET['userId'] = "2"; //$_GET['startDate'] = "2010-01-01 00:00:00"; //$_GET['endDate'] = "2020-01-01 00:00:00"; if (!isset($_GET["userId"]) || !isset($_GET["startDate"]) || !isset($_GET["endDate"])) { return; } $userId = $_GET["userId"]; $startDate = $_GET['startDate']; $endDate = $_GET['endDate']; $transporter = new Transporter(); $conn = $transporter->getConnection(); if ($userId == "all") { $sql = "SELECT user_id, scheduled_clock_in, scheduled_clock_out\r\n FROM user_schedule\r\n WHERE scheduled_clock_in > '{$startDate}'\r\n AND scheduled_clock_out < '{$endDate}'"; } else { $sql = "SELECT user_id, scheduled_clock_in, scheduled_clock_out\r\n FROM user_schedule\r\n WHERE scheduled_clock_in > '{$startDate}'\r\n AND scheduled_clock_out < '{$endDate}'\r\n AND user_id = '{$userId}'"; } $result = $conn->query($sql); //var_dump($result); $schedule = array(); $counter = 0; while ($row = $result->fetch_assoc()) { $counter++; $scheduleObject = array(); $id = $row['user_id']; $sql2 = "SELECT first_name, last_name FROM user WHERE id = '{$id}'"; $result2 = $conn->query($sql2); while ($row2 = $result2->fetch_assoc()) {