$response["error"] = false; $response["message"] = "Query Successful"; } else { // user credentials are wrong $response['error'] = true; $response['message'] = "The user vote could not be added to the database"; } echoResponse(200, $response); }); $app->get('/updatesfromlocation', function () use($app) { $response = array(); $sortType = $app->request()->get('sortType'); $locationId = $app->request()->get('locationId'); $db = new DbHandler(); // fetching all user tasks $result = $db->getUpdatesFromLocation($sortType, $locationId); if ($result) { $response["error"] = false; $response["updates"] = array(); // looping through result and preparing updates array while ($update = $result->fetch_assoc()) { $tmp = array(); $tmp["id"] = $update["id"]; $tmp["locationIdFrom"] = $update["locationIdFrom"]; $tmp["locationIdTo"] = $update["locationIdTo"]; $tmp["estTimeToCross"] = $update["estTimeToCross"]; $tmp["situation"] = $update["situation"]; $tmp["description"] = $update["description"]; $tmp["timeOfSituation"] = $update["timeOfSituation"]; $tmp["updaterId"] = $update["updaterId"]; $tmp["updaterName"] = $update["username"];