Viewing file:  product_del.php (1.33 KB) -rwxr-xr-x
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php include 'index_IncludeAdmin.php'; ?>
<?php
if (isset($_GET[product_id])){
$_SESSION[product_id] = $_GET[product_id];
}
$product_id = $_SESSION[product_id];
$product_SL = " SELECT * FROM product WHERE product_id = '$product_id'";
$product_QR = mysqli_query($con,$product_SL);
$product = mysqli_fetch_array($product_QR);
$product_picture_SL = " SELECT * FROM product_picture WHERE product_id = '$product_id'";
$product_picture_QR = mysqli_query($con,$product_picture_SL);
while ($product_picture = mysqli_fetch_array($product_picture_QR)) {
@unlink("../Files/product_picture_photo/".$product_picture['product_picture_photo']);
}
$product_picture_Del ="DELETE FROM `product_picture` WHERE product_id = '$product_id' ";
$product_picture_Qurey = mysqli_query($con,$product_picture_Del);
@unlink("../Files/product_photo/".$product['product_photo']);
@unlink("../Files/product_photo/".photo_min($product['product_photo']));
$product_Del ="DELETE FROM `product` WHERE product_id = '$product_id' ";
$product_Qurey = mysqli_query($con,$product_Del);
if($product_Qurey) {
echo"<script> window.location='product.php?DELETE'; </script>";
}
else{
echo"<script>alert('เกิดข้อผิดพลาด'); window.history.back(); </script>";
}
?>
<!DOCTYPE html>
<html>
<head>
<?php include 'index_link.php'; ?>
</head>
<body>
</body>
</html>
|