0){ foreach($_REQUEST['subcategory'] as $key=>$val){ if($val!=''){ $subcat=mysqli_real_escape_string($GLOBALS['conn'],$val); $subArr=$obj->query("select * from $tbl_subcategory where cat_id='".$_REQUEST['cat_id']."' and subcategory='$subcat' "); if($obj->numRows($subArr)==0){ // echo "insert into $tbl_subcategory set cat_id='$cat_id',subcategory='$val',status=1"; $obj->query("insert into $tbl_subcategory set cat_id='".$_REQUEST['cat_id']."',subcategory='".ucfirst($subcat)."',status=1"); $subcat_id=mysqli_insert_id($GLOBALS['conn']); generateSlug($subcat,$tbl_subcategory,$subcat_id); } } } $_SESSION['sess_msg']='Subcategory added successfully'; } header("location:subcat-list.php"); exit(); } } ?>

Admin: Add Subcategory   Category: -Select Category- query("select * from $tbl_category where status=1 order by category"); while($resultCategory=$obj->fetchNextObject($catArr)){?> id==$result->cat_id){ ?>selected>category); ?> Subcategory: