<?php

// session_start();
include("includes/config.php");




if(isset($_POST['add_service'])){
    // $category = $_POST['category'];
    $title = $_POST['music_type'];

    $photo = $_FILES['photo']['name'];

    $allowed_extension = array('gif','png','jpg','jpeg','webp','WEBP');
    $filename = $_FILES['photo']['name'];
    $file_extension = pathinfo($filename, PATHINFO_EXTENSION);

    if(!in_array($file_extension, $allowed_extension)){
        $_SESSION['id'] = "This File is Not An Image";
        header('Location: services.php');
    } else {
        $query = "INSERT INTO services (music_type, photo) VALUES ('$title','$photo')";
        $query_run = mysqli_query($conn, $query);

        if($query_run){
            move_uploaded_file($_FILES["photo"]["tmp_name"], "ServicesImage/".$_FILES["photo"]["name"]);
            $_SESSION['id'] = "Data Uploaded Successfully";
            header('Location: view-service.php');
        } else {
            $_SESSION['id'] = "Data Not Uploaded Successfully";
            header('Location: services.php');
        }
    }
}



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

    $old_photo = $_POST['image_old'];
    $update_filename = $_FILES["photo"]["name"] ? $_FILES["photo"]["name"] : $old_photo;

    $query = "UPDATE services SET music_type ='$title', photo='$update_filename' WHERE id ='$id' ";
    $query_run = mysqli_query($conn ,$query);

    if($query_run){
        if($_FILES["photo"]["name"] !=''){
            move_uploaded_file($_FILES["photo"]["tmp_name"], "ServicesImage/".$_FILES["photo"]["name"]);
            unlink("ServicesImage/". $old_photo);    
            echo $query_run;
        }

        $_SESSION['id'] = "Updated Successfully";
        header('Location: view-service.php');
    } else {
        $_SESSION['id'] = "Not Updated Successfully";
        header('Location: view-service.php');
    }
}

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


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

    if($query_run){

    unlink("ServicesImage/".$photo);


        $_SESSION['id'] = "Deleted successfully";
        header("Location: view-service.php");
        exit(0);
    }
    else{
        $_SESSION['id'] = "Data Not Deleted";
        header("Location: view-service.php");
    }
}


?>