1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
|
<?php
require_once ("check_login.php");
$productid = (int)$_GET["productid"];
$proimgid = (int)$_GET["proimgid"];
$sort = (int)$_GET["sort"];
$nowdate = date("Y-m-d H:i:s");
$sql = "update pro_image set deleted = ? WHERE proimgid=?";
$parameters = array("1", $proimgid);
bind_pdo($sql, $parameters);
$sql = "UPDATE pro_image SET sort = sort-1 WHERE sort != ? and sort >= ? AND productid = ? ";
$parameters = array("1", $sort, $productid);
bind_pdo($sql, $parameters);
$dbh = null;
header("Location: product_image_index.php?productid=$productid&msg=刪除成功");
|