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
|
<?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_det_cat WHERE pdid = '".$pdid."' ORDER BY psort ASC ";
$result3 = mysql_query($sql3);
while ($row3 = mysql_fetch_array($result3,MYSQL_ASSOC)) {
// Delete 产品项目 Category
$sql4 = "DELETE FROM product_det_cat WHERE pdid='". $row3{'pdid'} ."' AND pdcatid='". $row3{'pdcatid'} ."' ";
mysql_query($sql4);
if( mysql_errno() > 0 ){
echo 'Delete 产品项目 Category Error:<br />'. mysql_error() .'<br />SQL: '. $sql4;
exit;
}
// Update Category Sort
$sql5 = "UPDATE product_det_cat SET psort = psort-1 WHERE psort >=".$row3{'psort'}." AND pdcatid= ". $row3{'pdcatid'} ." ";
mysql_query($sql5);
if( mysql_errno() > 0 ){
echo 'Delete 产品项目 Category Sort Error:<br />'. mysql_error() .'<br />SQL: '. $sql5;
exit;
}
}
//Delete Product Image
$sql2 = "SELECT * FROM product_img WHERE pdid=". $pdid ." ";
$result2=mysql_query($sql2);
while ($row2 = mysql_fetch_array($result2,MYSQL_ASSOC))
{
unlink("../products/large/".$row2{'pimgfile'});
unlink("../products/thumb/".$row2{'pimgfile'});
}
$sql = "DELETE FROM product_img WHERE pdid='". $pdid ."' ";
mysql_query($sql);
if( mysql_errno() > 0 ){
echo 'Delete 产品项目(Images) Error:<br />'. mysql_error() .'<br />SQL: '. $sql;
exit;
}
//Delete 产品项目
//$sql = "update product_det set prodadmindelete='1', modifyday='$nowdate', cmsloginid='".$_SESSION['cmsloginid']."' ";
//$sql .= " where pdid = '".$pdid."' ";
$sql = "DELETE FROM product_det WHERE pdid='". $pdid ."' ";
mysql_query($sql);
if( mysql_errno() > 0 ){
echo 'Delete 产品项目 Error:<br />'. mysql_error() .'<br />SQL: '. $sql;
exit;
}
mysql_close($dbh);
header("Location: productdet_index.php?msg=删除成功");
?>
|