<?php
session_start();

include("includes/config.php");

if(isset($_POST['add_service'])){
    $service_name = $_POST['service_name'];
 

    $query = "INSERT INTO services (service_name) VALUES ('$service_name')";
    $query_run = mysqli_query($conn, $query);

    if($query_run){
      

        $_SESSION['status'] = "Data Uploaded Successfully";
          echo "<script>window.location.href='view-service.php';</script>";
        // header('Location: view-service.php');
        exit;
    } else {
        $_SESSION['status'] = "Data Not Uploaded Successfully";
        header('Location: service.php');
        exit;
    }
}



// update 

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

    $query = "UPDATE services SET service_name='$service_name' WHERE id ='$id' ";

    $query_run = mysqli_query($conn, $query);

    if($query_run){
       
        $_SESSION['status'] = "Updated Successfully";
           echo "<script>window.location.href='view-service.php';</script>";
        // header('Location: view-category.php');
    } else {
        $_SESSION['status'] = "Category Not Updated Successfully";
          echo "<script>window.location.href='view-service.php';</script>";
        // header('Location: view-category.php');
    }
}



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

    $query = "DELETE FROM services WHERE id = '$id'";
    $query_run = mysqli_query($conn, $query);

    if($query_run){
        $_SESSION['status'] = "Deleted Successfully";
            echo "<script>window.location.href='view-service.php';</script>";
        // header('Location: view-service.php');
    } else {
        $_SESSION['status'] = "Not Deleted Successfully";
            echo "<script>window.location.href='view-service.php';</script>";
        // header('Location: view-service.php');
    }
}