$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}";
