Exemple #1
0
    }
});
/* delete anggota */
$app->delete('/anggota/:key', function ($key) use($app, $db) {
    $query = $db->anggota->where("id", $key);
    if ($query->fetch()) {
        $result = $query->delete();
        echo json_encode(array("status" => true, "message" => "cek with id {$key} was deleted"));
    } else {
        echo json_encode(array("status" => false, "message" => "tes id {$key} does not exist"));
    }
});
/*--------------------------------------------------- table restoran ----------------------------------------------------------------*/
/* get restoran */
$app->get('/restoran', function () use($app, $db) {
    $query = $db->restoran()->order("created_at desc");
    foreach ($query as $value) {
        $result["status"] = true;
        $result["result"][] = array("restoran_id" => $value["restoran_id"], "restoran_name" => $value["restoran_name"], "restoran_logo" => $value["restoran_logo"], "restoran_address" => $value["restoran_address"], "created_at" => $value["created_at"], "updated_at" => $value["updated_at"]);
    }
    if ($query->count("*") > 0) {
        echo json_encode($result);
    } else {
        echo json_encode(array("status" => false, "message" => "nothing data yet"));
    }
});
/* seacrh restoran */
$app->get('/restoran/:key', function ($key) use($app, $db) {
    $query = $db->restoran()->where("restoran_name LIKE ?", "%{$key}%")->order("created_at desc");
    foreach ($query as $value) {
        $result["status"] = true;