$num_rows = mysqli_num_rows($ret); if ($num_rows > 0) { $return = ["id" => $result["accountID"], "firstName" => $result["firstName"], "lastName" => $result["lastName"]]; Response::Ok($return); } else { Response::NotFound("Account with ID {$accountID} does not exists."); } } }); $app->post($url, function () use($link, $url) { $query = "INSERT INTO accounts(`firstName`, `lastName`) VALUES('{$_POST["firstName"]}', '{$_POST["lastName"]}')"; $ret = mysqli_query($link, $query); 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."); } });
return false; } return true; } $app->post($url, function () use($url, $link) { if (!doesAccountExists($_POST["senderID"])) { Response::NotFound("Sender does not exists."); } if (!doesAccountExists($_POST["receiverID"])) { Response::NotFound("Receiver does not exists."); } $query = "INSERT INTO messages(`senderID`, `receiverID`, `message`, `dateTime`) VALUES({$_POST["senderID"]}, {$_POST["receiverID"]}, '{$_POST["message"]}', NOW())"; $ret = mysqli_query($link, $query); if ($ret) { $messageID = mysqli_insert_id($link); Response::Created($url . "/{$messageID}"); } }); $app->get($url, function () use($link) { $query = "SELECT * FROM messages"; $ret = mysqli_query($link, $query); $results = array(); if ($ret) { while ($row = mysqli_fetch_assoc($ret)) { $results[] = $row; } Response::Ok($results, JSON_PRETTY_PRINT); } }); $app->get($url . "/:id", function ($messageID) use($link) { $query = "SELECT * FROM messages WHERE messageID={$messageID}";