query("select * from tbl_city where status=1"); $cityarr=array(); while($rescity=$obj->fetchNextObject($sqlcity)){ array_push($cityarr,$rescity->city); } } $cityarr=array_values(array_filter($cityarr)); $maincategory=mysqli_real_escape_string($GLOBALS['conn'],$_POST['maincategory']); $parent_id=mysqli_real_escape_string($GLOBALS['conn'],$_REQUEST['parent_id']); $h_onearr=$_REQUEST['h1']; $meta_titlearr=$_REQUEST['metatitle']; $meta_keyarr=$_REQUEST['metakeyword']; $meta_descriptionarr=$_REQUEST['metadescription']; $content=mysqli_real_escape_string($_REQUEST['content']); if($_REQUEST['submitForm']=='yes'){ $bay_area_category= (isset($_POST['bay_area_category'])) ? mysqli_real_escape_string($GLOBALS['conn'],$_POST['bay_area_category']) : 0; $nationwide_category= (isset($_POST['nationwide_category'])) ? mysqli_real_escape_string($GLOBALS['conn'],$_POST['nationwide_category']) : 0; $description=mysqli_real_escape_string($GLOBALS['conn'],$_POST['description']); //category update $obj->query("update $tbl_maincategory set is_bay_area_category='$bay_area_category',is_nationwide_category='$nationwide_category',short_description='$description' where id=".$_REQUEST['id']); //end for($x=0; $xquery("select id from tbl_meta where city='$cityarr[$x]' and catid='".$_REQUEST['id']."' and filename='subcategory.php' and storeid=0"); if($obj->numRows($sql_meta)){ $result_meta=$obj->fetchNextObject($sql_meta); $obj->query("update tbl_meta set meta_title='$meta_titlearr[$x]',meta_key='$meta_keyarr[$x]',meta_description='$meta_descriptionarr[$x]',h1='$h_onearr[$x]',content='$content[$x]' where id='$result_meta->id'"); }else{ $pagetitle="main category page for ".$cityarr[$x]; $obj->query("insert into tbl_meta set catid='".$_REQUEST['id']."',storeid=0,pagetitle='$pagetitle',filename='subcategory.php',city='$cityarr[$x]', meta_title='$meta_titlearr[$x]',meta_key='$meta_keyarr[$x]',meta_description='$meta_descriptionarr[$x]',h1='$h_onearr[$x]', content='$content[$x]', status=1, canonical='self'"); } $_SESSION['sess_msg']='Category updated sucessfully'; } $section=getSection($parent_id); if($section==1) { $section='grocery'; $parameter='grocery-category'; clearlaravelcache($section,$parameter); } header("location:maincategory-list.php"); exit(); } if($_REQUEST['id']!=''){ $sql=$obj->query("select * from $tbl_maincategory where id=".$_REQUEST['id']); $result=$obj->fetchNextObject($sql); } ?> <?php echo SITE_TITLE; ?>
Admin: Update Category
query("select h1 from tbl_meta where city='$cityarr[$x]' and catid='".$_REQUEST['id']."' and filename='subcategory.php' and storeid=0"); $result=$obj->fetchNextObject($sql_meta);?> query("select meta_title from tbl_meta where city='$cityarr[$x]' and catid='".$_REQUEST['id']."' and filename='subcategory.php' and storeid=0"); $result=$obj->fetchNextObject($sql_meta); ?> query("select meta_key from tbl_meta where city='$cityarr[$x]' and catid='".$_REQUEST['id']."' and filename='subcategory.php' and storeid=0"); $result=$obj->fetchNextObject($sql_meta); ?> query("select meta_description from tbl_meta where city='$cityarr[$x]' and catid='".$_REQUEST['id']."' and filename='subcategory.php' and storeid=0"); $result=$obj->fetchNextObject($sql_meta); ?> query("select content from tbl_meta where city='$cityarr[$x]' and catid='".$_REQUEST['id']."' and filename='subcategory.php' and storeid=0"); $result=$obj->fetchNextObject($sql_meta); ?>
 
Parent Category:
Category:
Available for Bay Area: is_bay_area_category == 1) ? 'checked' : ''; ?> />
Available for Nationwide: is_nationwide_category == 1) ? 'checked' : ''; ?> />
Description:
H1 Tag:

Meta Tags

  
Meta Title:
Meta Keywords:
Description:
Content: