1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
|
<?php
include 'config.php';
// Check if the user is logged in
if ((!isSet($_SESSION['loginname'])) || ($loggin <> '1'))
{
header("Location: login.php");
exit;
}
require("configure.php");
$pdid = $_GET["pdid"];
$sql3 = "SELECT * FROM product_cat_item WHERE pdid = '".$pdid."' ORDER BY psort ASC ";
$result3 = mysql_query($sql3);
while ($row3 = mysql_fetch_array($result3,MYSQL_ASSOC)) {
// Delete Product Detail Category
$sql4 = "DELETE FROM product_cat_item WHERE pdid='". $row3{'pdid'} ."' AND pdcatid='". $row3{'pdcatid'} ."' ";
mysql_query($sql4);
if( mysql_errno() > 0 ){
echo 'Delete Product Detail Category Error:<br />'. mysql_error() .'<br />SQL: '. $sql4;
exit;
}
// Update Category Sort
$sql5 = "UPDATE product_cat_item SET psort = psort-1 WHERE psort >=".$row3{'psort'}." AND pdcatid= ". $row3{'pdcatid'} ." ";
mysql_query($sql5);
if( mysql_errno() > 0 ){
echo 'Delete Product Detail Category Sort Error:<br />'. mysql_error() .'<br />SQL: '. $sql5;
exit;
}
}
//Delete Product Image
$sql2 = "SELECT * FROM product_image WHERE pdid=". $pdid ." ";
$result2=mysql_query($sql2);
while ($row2 = mysql_fetch_array($result2,MYSQL_ASSOC))
{
unlink("../images/product/large/".$row2{'pimgfile'});
unlink("../images/product/mid/".$row2{'pimgfile'});
unlink("../images/product/thumb/".$row2{'pimgfile'});
}
$sql6 = "DELETE FROM product_image WHERE pdid='". $pdid ."' ";
mysql_query($sql6);
//Delete Product Detail
$sql4 = "SELECT * FROM product_detail WHERE pdid=". $pdid ." ";
$result4=mysql_query($sql4);
while ($row4 = mysql_fetch_array($result4,MYSQL_ASSOC))
{
unlink("../product/catalogue/".$row4{'pdcatalogueen'});
}
//delete material logo
$sql5 = "SELECT * FROM product_material_logo WHERE pdid = '".$pdid."' ";
$result5 = mysql_query($sql5);
while ($row5 = mysql_fetch_array($result5,MYSQL_ASSOC)) {
// Delete Product Detail Category
$sql4 = "DELETE FROM product_material_logo WHERE pdid='". $row5{'pdid'} ."' ";
mysql_query($sql5);
if( mysql_errno() > 0 ){
echo 'Delete Product Materail Logo Error:<br />'. mysql_error() .'<br />SQL: '. $sql5;
exit;
}
}
$sql = "DELETE FROM product_detail WHERE pdid='". $pdid ."' ";
mysql_query($sql);
if( mysql_errno() > 0 ){
echo 'Delete Product Detail Error:<br />'. mysql_error() .'<br />SQL: '. $sql;
exit;
}
mysql_close($dbh);
header("Location: product_detail_index.php?msg=Delete Successful");
?>
|