Viewing file:  portfolio_del.php (1.74 KB) -rwxr-xr-x
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php include 'index_IncludeAdmin.php'; ?>
<?php
if (isset($_GET[portfolio_id])){
$_SESSION[portfolio_id] = $_GET[portfolio_id];
}
$portfolio_id = $_SESSION[portfolio_id] ;
$portfolio_SL = " SELECT * FROM portfolio WHERE portfolio_id = '$portfolio_id'";
$portfolio_QR = mysqli_query($con,$portfolio_SL);
$portfolio = mysqli_fetch_array($portfolio_QR);
@unlink("../Files/portfolio_photo/".$portfolio['portfolio_photo']);
$portfolio_picture_SL = " SELECT * FROM portfolio_picture WHERE portfolio_id = '$portfolio_id'";
$portfolio_picture_QR = mysqli_query($con,$portfolio_picture_SL);
while ($portfolio_picture = mysqli_fetch_array($portfolio_picture_QR)) {
@unlink("../Files/portfolio_picture_photo/".$portfolio_picture['portfolio_picture_photo']);
}
$portfolio_picture_Del ="DELETE FROM `portfolio_picture` WHERE portfolio_id = '$portfolio_id' ";
$portfolio_picture_Qurey = mysqli_query($con,$portfolio_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]','portfolio_Del $portfolio[portfolio_name]','$_SESSION[AdminID]','$LoginData[AdminName]')";
$HistorylogQuery = mysqli_query($con,$Historylog);
$portfolio_Del ="DELETE FROM `portfolio` WHERE portfolio_id = '$portfolio_id' ";
$portfolio_Qurey = mysqli_query($con,$portfolio_Del);
if($portfolio_Qurey) {
echo"<script> window.location='portfolio.php?DELETE'; </script>";
}
else{
echo"<script>alert('เกิดข้อผิดพลาด'); window.history.back(); </script>";
}
?>
<html>
<head>
<?php include 'index_link.php'; ?>
</head>
<body>
</body>
</html>
|