示例#1
0
    }
});
/* delete anggota */
$app->delete('/restoran/:key', function ($key) use($app, $db) {
    $query = $db->restoran()->where("restoran_id", $key);
    if ($query->fetch()) {
        $result = $query->delete();
        echo json_encode(array("status" => true, "message" => " restoran with id {$key} was deleted"));
    } else {
        echo json_encode(array("status" => false, "message" => "restoran with id {$key} does not exist"));
    }
});
/*----------------------------------------------- table menu ------------------------------------------------------------------------*/
/* get menu */
$app->get('/menu', function () use($app, $db) {
    $query = $db->menu()->order("created_at desc");
    foreach ($query as $value) {
        $result["status"] = true;
        $result["result"][] = array("menu_id" => $value["menu_id"], "restoran_id" => $value["restoran_id"], "menu_name" => $value["menu_name"], "menu_price" => $value["menu_price"], "menu_kode" => $value["menu_kode"], "menu_description" => $value["menu_description"], "menu_image" => $value["menu_image"], "menu_sku" => $value["menu_sku"], "created_at" => $value["created_at"]);
    }
    if ($query->count("*") > 0) {
        echo json_encode($result);
    } else {
        echo json_encode(array("status" => false, "message" => "nothing data yet"));
    }
});
/* search menu */
$app->get('/menu/:key', function ($key) use($app, $db) {
    $query = $db->menu()->where("menu_name LIKE ?", "%{$key}%")->order("created_at desc");
    foreach ($query as $value) {
        $result["status"] = true;