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


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

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


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

    if (isset($_FILES['image']['name'])) {
        $contact = $_POST['contact'];
        $url = $_POST['url'];
        $image = $_FILES['image']['name'];
        $path = 'uploads/slider/'.time().$image;
        
            $add = "INSERT INTO sliders(img,contact,url) VALUES('$path','$contact','$url')";

            if ($conn->query($add)) {
                move_uploaded_file($_FILES['image']['tmp_name'], '../cabzvendor_api/'.$path);
                echo "Success";
            }
            else {
                echo "Something Wrong";
            }
    }




    //Show Current Catagory in Edit Modal

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

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

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

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

    //Updating package Catagory in Modal
    if (isset($_POST['save_id'])) {
        $id = test_input($_POST['save_id']);
        $contact = $_POST['contact'];
        $url = $_POST['url'];
        $image = $_FILES['images']['name'];
        $path = 'uploads/slider/'.time().$image;
        $location = '../cabzvendor_api/'.$path;
        if (!empty($image)) {
            $sql = $conn->query("UPDATE sliders SET img = '$path' WHERE id = $id");
            move_uploaded_file($_FILES['images']['tmp_name'], $location);
        }

        $sql = $conn->query("UPDATE sliders SET contact='$contact',url='$url' WHERE id = $id");

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

    }

    //Delete package categories

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

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

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

    }
}

?>