<?php
include("includes/db_config.php");

if(isset($_GET['id']))
{ $id = $_GET['id'];
	$sql_qrry="select sub_category.sub_category_name,category.cat_name,sub_sub_category.sub_sub_cat_name,product.* from product join category on product.category_id=category.id join sub_category on product.sub_category_id=sub_category.id join sub_sub_category on product.sub_sub_cat_id=sub_sub_category.id where product.id='$id' ";
    $resultss = mysqli_query($conn, $sql_qrry);
	$res= mysqli_fetch_array($resultss);
	 $name = strtolower(str_replace(" ", "-", $res['cat_name']));
	 $sub_name = strtolower(str_replace(" ", "-", $res['sub_category_name']));
 $prod_name = $res['prod_name']; 
if(file_exists("../".strtolower(str_replace(" ", "-", $res["cat_name"]))."/".strtolower(str_replace(" ", "-", $res["sub_category_name"]))."/".strtolower(str_replace(" ", "-", $res["sub_sub_cat_name"]))."/".strtolower(str_replace(" ", "-", $res["prod_name"])).".php")) {
	unlink("../".strtolower(str_replace(" ", "-", $res["cat_name"]))."/".strtolower(str_replace(" ", "-", $res["sub_category_name"]))."/".strtolower(str_replace(" ", "-", $res["sub_sub_cat_name"]))."/".strtolower(str_replace(" ", "-", $res["prod_name"])).".php");
 $id = $_GET['id']; 
$sql="
DELETE FROM product
WHERE id={$_GET['id']}";
$res=mysqli_query($conn,$sql) or die(mysqli_error());

$sql1="
DELETE FROM product_detail
WHERE prod_id={$_GET['id']}";
$res1=mysqli_query($conn,$sql1) or die(mysqli_error());

}
echo "<script>window.location.href='products.php'</script>";
}
?>