Example #1
0
    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");
});
Example #2
0
        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");
});