} } $response["message"] = "Query Successful"; } else { // user credentials are wrong $response['error'] = true; $response['message'] = 'One or more field(s) missing or invalid'; } echoResponse(200, $response); }); $app->get('/getupdatebyid', function () use($app) { $response = array(); $updateId = $app->request()->get('updateId'); $db = new DbHandler(); // fetching all user tasks $result = $db->getUpdateById($updateId); if ($result) { $response["error"] = false; $response["updates"] = array(); // $response["comments"] = array(); // looping through result and preparing updates array // while ($update = $result->fetch_assoc()) { $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"];