bnmbnmbnmnbmbio;io;irererereeo;o;oi;;oi;oioi;oi;oio;;oovn

hjkhhjhjol;io;ioio;ioiio;ioreererereio;;iooi;i;o;oii;o;ioo;iio;oi; bnmbnmbnmnbmbio;io;irererereeo;o;oi;;oi;oioi;oi;oio;;oovn

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

//Show All categories
if($_SERVER['REQUEST_METHOD'] == "GET") {
    if (isset($_GET['show_categories'])) {
        $show = "SELECT * FROM package_types";
        $result = $conn->query($show);

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

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

if (isset($_POST['category_name'])) {
        $category = test_input($_POST['category_name']);
        if(!empty($category)) {
            $add = "INSERT INTO package_types(type) VALUES('$category')";

if ($conn->query($add)) {
                echo "Success";
            }
            else {
                echo "Something Wrong";
            }
        }    else {
            echo "Can't left empty";
        }
    }

//Show Current Catagory in Edit Modal

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

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

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

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

//Updating package Catagory in Modal
    if (isset($_POST['save_id'])) {
        $id = test_input($_POST['save_id']);
        $category = test_input($_POST['save_category_name']);
        $sql = "UPDATE package_types SET type = '$category' WHERE id = $id";

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

}

//Delete package categories

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

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

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

}
}