Viewing file:  service_del.php (1.66 KB) -rwxr-xr-x
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php include 'index_IncludeAdmin.php'; ?>
<?php
if (isset($_GET[service_id])){
$_SESSION[service_id] = $_GET[service_id];
}
$service_id = $_SESSION[service_id] ;
$service_SL = " SELECT * FROM service WHERE service_id = '$service_id'";
$service_QR = mysqli_query($con,$service_SL);
$service = mysqli_fetch_array($service_QR);
@unlink("../Files/service_photo/".$service['service_photo']);
$service_picture_SL = " SELECT * FROM service_picture WHERE service_id = '$service_id'";
$service_picture_QR = mysqli_query($con,$service_picture_SL);
while ($service_picture = mysqli_fetch_array($service_picture_QR)) {
@unlink("../Files/service_picture_photo/".$service_picture['service_picture_photo']);
}
$service_picture_Del ="DELETE FROM `service_picture` WHERE service_id = '$service_id' ";
$service_picture_Qurey = mysqli_query($con,$service_picture_Del);
$Historylog = " INSERT INTO `Historylog` ( HistorylogDate, HistorylogTime , HistorylogIP, HistorylogAgent, Historyloglanguage, HistorylogActivities, AdminID, AdminName ) VALUES (NOW(), NOW(),'$_SERVER[REMOTE_ADDR]','$_SERVER[HTTP_USER_AGENT]','$_SERVER[HTTP_ACCEPT_LANGUAGE]','service_Del $service[service_name]','$_SESSION[AdminID]','$LoginData[AdminName]')";
$HistorylogQuery = mysqli_query($con,$Historylog);
$service_Del ="DELETE FROM `service` WHERE service_id = '$service_id' ";
$service_Qurey = mysqli_query($con,$service_Del);
if($service_Qurey) {
echo"<script> window.location='service.php?DELETE'; </script>";
}
else{
echo"<script>alert('เกิดข้อผิดพลาด'); window.history.back(); </script>";
}
?>
<html>
<head>
<?php include 'index_link.php'; ?>
</head>
<body>
</body>
</html>
|