Edit file File name : product-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') { $imageArr=$obj->query("select photo from $tbl_product where id in ($str_rest_refs) "); while($resultImage=$obj->fetchNextObject($imageArr)){ @unlink("../upload_images/product/".$resultImage->photo); @unlink("../upload_images/product/tiny/".$resultImage->photo); @unlink("../upload_images/product/thumb/".$resultImage->photo); } $imageArr=$obj->query("select pphoto,barcode from $tbl_productprice where product_id in ($str_rest_refs) "); while($resultImage=$obj->fetchNextObject($imageArr)){ @unlink("../upload_images/product/".$resultImage->pphoto); @unlink("../upload_images/product/tiny/".$resultImage->pphoto); @unlink("../upload_images/product/thumb/".$resultImage->pphoto); @unlink("../upload_images/product/barcode/".$resultImage->barcode); } $sql="delete from $tbl_specialcatproduct where prod_id in ($str_rest_refs)"; $obj->query($sql); $sql="delete from $tbl_productprice where product_id in ($str_rest_refs)"; $obj->query($sql); $sql="delete from $tbl_features where product_id in ($str_rest_refs)"; $obj->query($sql); $sql="delete from $tbl_product where id in ($str_rest_refs)"; $obj->query($sql); $sess_msg='Selected record(s) deleted successfully'; $_SESSION['sess_msg']=$sess_msg; } elseif($Submit=='Make Latest') { $sql="update $tbl_product set latest=1 where id in ($str_rest_refs)"; $obj->query($sql); $sess_msg='Selected record(s) activated successfully'; $_SESSION['sess_msg']=$sess_msg; } elseif($Submit=='Remove Latest') { $sql="update $tbl_product set latest=0 where id in ($str_rest_refs)"; $obj->query($sql); $sess_msg='Selected record(s) activated successfully'; $_SESSION['sess_msg']=$sess_msg; } elseif($Submit=='Activate') { $check=$obj->query("select cat_id from $tbl_product where id in ($str_rest_refs)"); while($result=$obj->fetchNextObject($check)) { $section=getSection($result->cat_id); if($section==1) { $section='grocery'; $parameter='grocery-store-product'; clearlaravelcache($section,$parameter); } } $sql="update $tbl_product 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') { $check=$obj->query("select cat_id from $tbl_product where id in ($str_rest_refs)"); while($result=$obj->fetchNextObject($check)) { $section=getSection($result->cat_id); if($section==1) { $section='grocery'; $parameter='grocery-store-product'; clearlaravelcache($section,$parameter); } } $sql="update $tbl_product 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: product-list.php"); exit(); ?> Save