<?php include 'lib/core.php';


//Show All data
if($_SERVER['REQUEST_METHOD'] == "GET") {
    if (isset($_GET['show'])) {
        $show = "SELECT * FROM amenities ORDER BY id DESC";
        $result = $conn->query($show);

        if ($result->num_rows > 0) {
            while ($row = $result->fetch_assoc()) {
                $showdata[] = $row;
            }
            echo json_encode($showdata);
        }
    }
}


if($_SERVER['REQUEST_METHOD'] == "POST") {
    // Adding available_vehicle

    if (isset($_POST['note'])) {
        $note = $_POST['note'];
        $price = $_POST['price'];
        $status = $_POST['status'];
        $add = $conn->query("INSERT INTO amenities(note,price,status) VALUES('$note','$price','$status')");

        if ($add) {
            echo "Success";
        }
        else {
            echo "Something Wrong";
        }
    }
}

if (isset($_POST['request_id'])) {
    $id = $_POST['request_id'];

    $query = "SELECT * FROM amenities WHERE id = " . $id;

    $result = $conn->query($query);

    if ($result->num_rows > 0) {
        $show = $result->fetch_assoc();
        echo json_encode($show);
    }
}

if (isset($_POST['save_id'])) {
    $id = $_POST['save_id'];
    $note = $_POST['edit_note'];
    $price = $_POST['price'];
    $status = $_POST['status'];
    $sql = "UPDATE amenities SET note='$note',price='$price',status='$status' WHERE id = $id";

    if ($conn->query($sql)) {
        echo "Success";
    } else {
        echo "Something Wrong";
    }
}


//Delete

if (isset($_POST['delete_id'])) {
    $id = $_POST['delete_id'];

    $query = "DELETE FROM amenities WHERE id = " . $id;

    if ($conn->query($query)) {
        echo "Success";
    } else {
        echo "Something Wrong";
    }

}

?>