| 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/globavet.com/webadmin/ |
Upload File : |
<?php
require 'check_login.php';
if ($logged_in <> 1) {
header('Location: login.php');
return;
}
else
{
require("configure.php");
$aboutusid = $_GET["aboutusid"];
$parentid = $_GET["parentid"];
$sort = $_GET["sort"];
//Find ID Category
function getAllCategoryID($pid){
$rtnString = "";
$sqlCmd = " SELECT aboutusid FROM aboutus 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{'aboutusid'} .",". getAllCategoryID($row{'aboutusid'});
}
}
return $rtnString;
}
//Delete Category
$sql = "DELETE FROM aboutus WHERE aboutusid in (".substr($aboutusid.','.getAllCategoryID($aboutusid),0, -1).")";
mysql_query($sql);
if( mysql_errno() > 0 ){
echo 'Delete About Us Error:<br />'. mysql_error() .'<br />SQL: '. $sql;
exit;
}
// Update Category Sort
mysql_query("UPDATE aboutus SET sort = sort-1 WHERE parentid=". $parentid ." AND sort >= ".$sort." ");
mysql_close($dbh);
header("Location: aboutus_index.php?pid=$parentid&msg=Delete Successful");
}
?>