function getEmployees() { if (isset($_GET['name'])) { return getEmployeesByName($_GET['name']); } else { if (isset($_GET['modifiedSince'])) { return getModifiedEmployees($_GET['modifiedSince']); } } $sql = "select e.id, e.firstName, e.lastName, e.title, count(r.id) reportCount " . "from employee e left join employee r on r.managerId = e.id " . "group by e.id order by e.lastName, e.firstName"; try { $db = getConnection(); $stmt = $db->query($sql); $employees = $stmt->fetchAll(PDO::FETCH_OBJ); $db = null; // Include support for JSONP requests if (!isset($_GET['callback'])) { echo json_encode($employees); } else { echo $_GET['callback'] . '(' . json_encode($employees) . ');'; } } catch (PDOException $e) { echo '{"error":{"text":' . $e->getMessage() . '}}'; } echo "go"; }
function getEmployees() { if (isset($_GET['modifiedSince'])) { getModifiedEmployees($_GET['modifiedSince']); return; } $employees = $_SESSION['employees']; $result = array(); foreach ($employees as $employee) { if (!$employee->deleted) { $result[] = $employee; } } echo json_encode($result); }