| Server IP : 210.245.233.93 / Your IP : 216.73.216.226 Web Server : Apache/2.2.15 (CentOS) System : Linux webserver2.onesolution.com.hk 2.6.32-754.35.1.el6.x86_64 #1 SMP Sat Nov 7 12:42:14 UTC 2020 x86_64 User : apache ( 48) PHP Version : 5.3.3 Disable Function : exec, shell_exec, system, passthru, popen, proc_open, pcntl_exec MySQL : ON | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /var/www/airchats.com.hk/webadmin/ |
Upload File : |
<?php
require("configure.php");
$catid = $_GET["catid"];
$parentid = $_GET["parentid"];
$catsort = $_GET["catsort"];
//Delete Category
function getAllCategoryID($pid){
$rtnString = "";
$sqlCmd = " SELECT catid FROM prodcategory WHERE parentid=". $pid ." ";
$result = mysql_query($sqlCmd);
if (mysql_num_rows( $result)>0 && mysql_num_rows($result) >0)
{
while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
$rtnString .= $row{'catid'} .",". getAllCategoryID($row{'catid'});
}
}
return $rtnString;
}
//Delete Category
$sql1 = "DELETE FROM prodcategory ";
$sql1 .= "where catid in (".substr($catid.','.getAllCategoryID($catid),0, -1).")";
//echo 'Category catid = '.$sql1.'<br />';
mysql_query($sql1);
if( mysql_errno() > 0 ){
echo 'Delete Product Category Error:<br />'. mysql_error() .'<br />SQL: '. $sql1;
exit;
}
// Update Category Sort
mysql_query("UPDATE prodcategory SET catsort = catsort-1 WHERE parentid=". $parentid ." AND catsort >= $catsort");
mysql_close($dbh);
header("Location: prodcat_index.php?pid=$parentid&msg=Delete Successful");
?>