<? require "../application_top.php";
require('protect-admin.php');
$catid = isset($_REQUEST['catid'])? decode($_REQUEST['catid']):'';
$subcatid = isset($_REQUEST['subcatid'])? decode($_REQUEST['subcatid']):'';
if(isset($_REQUEST['subcatname'])){
	$subcatname = $_REQUEST['subcatname'];
	$updatearr = array(
		'catid'=>$catid,
		'subcatname'=>$subcatname
	);
	$db->where('subcatid',$subcatid);
	$db->update('subcategories',$updatearr);
	$_SESSION['msg'] = "Subcategory updated successfully";
	header('location:subcategories.php');exit;
}

$sqlcat = "select * from categories order by catname";
$rowscat = $db->rawQuery($sqlcat);
$catArr = array();
if(count($rowscat)){
	foreach($rowscat as $rowcat){
		$catArr[$rowcat['catid']] = $rowcat['catname'];
	}
}

$pagename = "category"; require "header.php";?>
	<div class="w3-row">
		<div class="w3-col m12">
		<h1>Edit Sub Category</h1>
		<br/><br/>
		<?
		$sqlcat = "select * from subcategories where subcatid = ? limit 1";
		$paramcat[] = $subcatid;
		$rowscat = $db->rawQuery($sqlcat,$paramcat);
		if(count($rowscat)){
		?>
		<div style="margin:0 auto;max-width:400px;">
		<form action="<?=$_SERVER['PHP_SELF'];?>" method="post" id="propertyform">
		<select name="catid" class="w3-input" required>
			<option value="">Select Main Category</option>
			<?
			foreach($catArr as $key=>$val){
				?><option value="<?=encode($key);?>" <?=($key==$rowscat[0]['catid'])? "selected=selected":"";?>><?=$val;?></option><?
			}
			?>
		</select>
		<input type="text" name="subcatname" value="<?=$rowscat[0]['subcatname'];?>" class="w3-input" required/>
		<input type="hidden" name="subcatid" value="<?=encode($subcatid);?>"/>
		<input type="submit" name="sub" value="Edit" class="w3-btn w3-black"/> 
		<input type="button" class="w3-btn w3-blue" onclick="window.location='subcategories.php'" value="Back to SubCategory List"/>
		</form>
		</div>
		<? } ?>
		</div>
	</div>
<? require "footer.php";?>