if ($ret) { $id = mysqli_insert_id($link); } Response::Created($url . "/{$id}"); }); $app->delete($url, function () use($link) { $query = "DELETE FROM accounts"; $ret = mysqli_query($link, $query); if ($ret) { Response::Ok("Accounts are all successfully deleted."); } }); $app->delete($url . "/:accountID", function ($accountID) use($link) { $query = "DELETE FROM accounts WHERE accountID={$accountID}"; $ret = mysqli_query($link, $query); if ($ret) { Response::Ok("Account with ID {$accountID} was successfully deleted."); } }); $app->put($url, function () { Response::NotFound("Can't update all accounts simultaneously."); }); $app->put($url . "/:id", function ($accountID) use($link) { $query = "UPDATE accounts SET firstName='{$_POST["firstName"]}', lastName='{$_POST["lastName"]}' WHERE accountID={$accountID}"; $ret = mysqli_query($link, $query); $num_rows = mysqli_num_rows($ret); if ($num_rows <= 0) { Response::NotFound("Account with ID {$accountID} does not exists."); } echo $app->request->put("account"); });
Response::NotFound("Message with ID {$messageID} does not exists."); } $return = ["messageID" => $result["messageID"], "senderID" => $result["senderID"], "receiverID" => $result["receiverID"], "message" => $result["message"], "dateTime" => $result["dateTime"]]; Response::Ok($return, JSON_PRETTY_PRINT); }); $app->delete($url, function () use($link) { $query = "DELETE FROM messages"; $ret = mysqli_query($link, $query); if ($ret) { Response::Ok("Messages were successfully deleted."); } }); $app->delete($url . "/:id", function ($messageID) use($link) { $query = "DELETE FROM messages WHERE messageID={$messageID}"; $ret = mysqli_query($link, $query); if (mysqli_num_rows($ret) <= 0) { Response::NotFound("Message with ID {$messageID} does not exists."); } Response::Ok("Message was successfully deleted."); }); $app->put($url, function () { Response::NotFound("Can't update all messages simultaneously."); }); $app->put($url . "/:id", function ($messageID) use($app, $link) { $query = "UPDATE messages SET message='{$_POST["message"]}' WHERE messageID={$messageID}"; $ret = mysqli_query($link, $query); if (mysqli_num_rows($ret) <= 0) { Response::NotFound("Message with ID {$messageID} does not exists."); } echo $app->request->put("message"); });