$val){ if($val!=''){ $maincategory=mysqli_real_escape_string($GLOBALS['conn'],$val); $bArr=$obj->query("select * from $tbl_maincategory where maincategory='$maincategory' "); if($obj->numRows($bArr)==0){ $obj->query("insert into $tbl_maincategory set parent_id='$parent_id',is_bay_area_category='$bay_area_category',is_nationwide_category='$nationwide_category',short_description='$description',sort_order='1',maincategory='".ucfirst($maincategory)."',status=1 "); $maincategory_id=mysqli_insert_id($GLOBALS['conn'],); generateSlug($maincategory,$tbl_maincategory,$maincategory_id); } } } if($section==1) { $section='grocery'; $parameter='grocery-category'; clearlaravelcache($section,$parameter); } $_SESSION['sess_msg']='Category added sucessfully'; header("location:maincategory-list.php"); exit(); } } ?>

Admin: Add Category   Parent Category: None query("select * from tbl_maincategory where status=1 order by parent_id"); $catArr=$obj->query("select c1.id, CASE WHEN c1.parent_id = 0 OR c2.id IS NULL THEN c1.maincategory ELSE CONCAT(c2.maincategory, ' >> ', c1.maincategory) END maincategory_merged from tbl_maincategory c1 LEFT JOIN tbl_maincategory c2 on c1.parent_id = c2.id and c2.status = 1 where c1.status=1 order by maincategory_merged;"); while($resultP=$obj->fetchNextObject($catArr)){?> maincategory_merged //echo getCategoryTree($resultP->id,$array=''); ?> Category: Available for Bay Area: Available for Nationwide: Description: