<?php

include("inc/config.php");

if (isset($_POST['add_ser'])) {
    $ser_name = mysqli_real_escape_string($conn, $_POST['ser_name']);

 

    $query = "INSERT INTO sers (ser_name) VALUES ('$ser_name')";
    
    if (mysqli_query($conn, $query)) {
        echo "<script>
                alert('Service Added Successfully!');
                window.location.href = 'view-ser.php';
              </script>";
        exit();
    } else {
        echo "<script>
                alert('Error: " . mysqli_error($conn) . "');
                window.history.back();
              </script>";
    }
}




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

  

    // Update the project information in the database
    $query = "UPDATE sers 
              SET ser_name='$ser_name'
              WHERE id='$id'";

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

    if ($query_run) {
        $_SESSION['status'] = "Service Updated Successfully";
        header('Location: view-ser.php');
    } else {
        $_SESSION['status'] = "Service Not Updated Successfully";
        header('Location: view-ser.php');
    }
}



// delete

if (isset($_POST['delete_sers'])) {

    $id = $_POST['delete_id'];
    
    $query = "DELETE FROM `sers` WHERE id = '$id'";
    $query_run = mysqli_query($conn, $query);

    if ($query_run) {
        $_SESSION['status'] = "Deleted Successfully";
        header('Location: view-ser.php');
    } else {
        $_SESSION['status'] = "Not Deleted Successfully";
        header('Location: view-ser.php');
    }
}

?>