Tiny File Manager

Back Back Up Advanced Editor

<?php
include('authentication.php');
include('middleware/superadminAuth.php');

if(isset($_POST['category_delete']))
{
   // $category_id = $_POST['category_delete'];
    $string = preg_replace('/[^A-Za-z0-9\-]/','-',$_POST['category_delete']);//remove all special characters
    $final_string = preg_replace('/-+/', '-', $string);
    $category_id = $final_string;

$query = "UPDATE categories SET status ='2' WHERE id = '$category_id' LIMIT 1";  //2 deleted
    $query_run = mysqli_query($con, $query);

if($query_run)
    {
        $_SESSION['message'] ="Category Deleted Successfully";
        header('Location: category-view.php');
        exit(0);
    }else{
        $_SESSION['message'] ="Something Went Wrong";
        header('Location: category-view.php');
        exit(0);
    } 
}

if(isset($_POST['service_detete_btn']))
{
 //   $service_id= $_POST['service_detete_btn'];
        $string = preg_replace('/[^A-Za-z0-9\-]/','-',$_POST['service_detete_btn']);//remove all special characters
        $final_string = preg_replace('/-+/', '-', $string);
        $service_id = $final_string;

$check_img_query = "SELECT * FROM services WHERE id ='$service_id' LIMIT 1";
    $img_res = mysqli_query($con, $check_img_query);
    $res_data = mysqli_fetch_array($img_res);
    $image = $res_data['image'];

$query = "DELETE from services WHERE id = '$service_id' LIMIT 1";
    $query_run = mysqli_query($con, $query);

if($query_run)
    {
         
        if(file_exists('../uploads/service/'.$image))
        {
            unlink('../uploads/service/'.$image);
        }
        
        $_SESSION['message'] = "Service Deleted Successfully";
        header('Location: service-view.php');
        exit(0);
    }else{
        $_SESSION['message'] = "Something Went Wrong";
        header('Location: service-view.php');
        exit(0);
    } 
}