Edit file File name : category-del.php Content :<?php session_start(); include("../include/config.php"); include("../include/functions.php"); validate_admin(); $arr =$_POST['ids']; //print_r($_REQUEST); $Submit =$_POST['what']; if(count($arr)>0){ $str_rest_refs=implode(",",$arr); if($Submit=='Delete') { $sql="delete from $tbl_gchildsubcat where cat_id in ($str_rest_refs)"; $obj->query($sql); $sql="delete from $tbl_childsubcategory where cat_id in ($str_rest_refs)"; $obj->query($sql); $sql="delete from $tbl_subcategory where cat_id in ($str_rest_refs)"; $obj->query($sql); $imageArr=$obj->query("select photo,icon from $tbl_category where id in ($str_rest_refs) "); while($resultImage=$obj->fetchNextObject($imageArr)){ @unlink("../upload_images/category/".$resultImage->photo); @unlink("../upload_images/category/tiny/".$resultImage->photo); @unlink("../upload_images/category/thumb/".$resultImage->photo); @unlink("../upload_images/category/icon/".$resultImage->photo); } $sql="delete from $tbl_category where id in ($str_rest_refs)"; $obj->query($sql); $sess_msg='Selected record(s) deleted successfully'; $_SESSION['sess_msg']=$sess_msg; } elseif($Submit=='Activate') { $sql="update $tbl_category set status=1 where id in ($str_rest_refs)"; $obj->query($sql); $sess_msg='Selected record(s) activated successfully'; $_SESSION['sess_msg']=$sess_msg; } elseif($Submit=='Deactivate') { $sql="update $tbl_category set status=0 where id in ($str_rest_refs)"; $obj->query($sql); $sess_msg='Selected record(s) deactivated successfully'; $_SESSION['sess_msg']=$sess_msg; } } else{ $sess_msg="Please select check box"; $_SESSION['sess_msg']=$sess_msg; header("location: ".$_SERVER['HTTP_REFERER']); exit(); } header("location: category-list.php"); exit(); ?> Save