<?php  
$id=0;
if(isset($_GET['id']))
{
	$page_title = 'Edit Menu With Tab';
	include 'header.php';
	$id = $_GET['id'];
	$sel=mysqli_query($con,"select * from menu_with_tab where id=$id");
	while($row_documents=mysqli_fetch_array($sel))
	{
		?>
		<div class="content-wrapper">
			<section class="content mt-4">
				<div class="container-fluid">
					<div class="row">
						<div class="col-md-12">
							<?php include('alert-msg.php'); ?>
							<div class="card card-primary">
								<div class="card-header">
									<h3 class="card-title"><?php echo $page_title; ?></h3>
								</div>
								<form action="" method="POST" enctype="multipart/form-data">
									<div class="card-body">
										<div class="row">
											<div class="col-md-12">
												<div class="row">
													<div class="col-md-4">
														<div class="form-group">
															<label>Menu</label>
															<input type="text" class="form-control" autocomplete="off" name="menu" list="menu" required value="<?php echo $row_documents['menu']; ?>" />
															<datalist id="menu">
																<?php 
																$sql_cat=mysqli_query($con,"select DISTINCT menu from menu_with_tab where menu !='' order by id desc");
																while($row_cat=mysqli_fetch_array($sql_cat))
																{
																	?>
																	<option value="<?php echo $row_cat['menu']; ?>">
																		<?php
																	}
																	?>
																</datalist>
															</div>
														</div>
														<div class="col-md-4">
														<div class="form-group">
															<label>Menu</label>
															<input type="text" class="form-control" autocomplete="off" name="sub_menu" list="sub_menu" required value="<?php echo $row_documents['sub_menu']; ?>" />
															<datalist id="sub_menu">
																<?php 
																$sql_cat=mysqli_query($con,"select DISTINCT sub_menu from menu_with_tab where sub_menu !='' order by id desc");
																while($row_cat=mysqli_fetch_array($sql_cat))
																{
																	?>
																	<option value="<?php echo $row_cat['sub_menu']; ?>">
																		<?php
																	}
																	?>
																</datalist>
															</div>
														</div>
														<div class="col-md-4">
															<div class="form-group">
																<label>Tab Name</label>
																<input type="text" class="form-control" name="tab_name" value="<?php echo $row_documents['tab_name']; ?>" />
															</div>
														</div>
														<div class="col-md-4">
															<div class="form-group">
																<label>Sub Menu Order Number</label>
																<input type="text" class="form-control" name="order_number" value="<?php echo $row_documents['order_number']; ?>" />
															</div>
														</div>
														<div class="col-md-4">
															<div class="form-group">
																<label>Tab Order Number</label>
																<input type="text" class="form-control" name="tab_order_number" value="<?php echo $row_documents['order_number']; ?>" />
															</div>
														</div>
													</div>
													<div class="row">
														<div class="col-md-12">
															<div class="form-group">
																<label>Page Content</label>
																<textarea class="text_editor" name="description">
																	<?php echo $row_documents['content']; ?>
																</textarea>
															</div>
														</div>
													</div>
												</div>
											</div>
											<button type="submit" class="btn btn-primary" name="btnSubmit">Submit</button>
										</div>
									</form>
								</div>
							</div>
						</div>
					</div>
				</section>
			</div>
			<?php
		}
		?>
		<?php include 'footer.php'; ?>
		<?php
	}
	else
	{
		session_start();
		$_SESSION['error_msg'] = 'Something wrong...';
		echo"<script>window.location='menu-list-with-tab.php';</script>";
	}
	?>


	<?php
	if(isset($_POST['btnSubmit']))
	{
		$menu = mysqli_real_escape_string($con,$_POST['menu']);
		$sub_menu = mysqli_real_escape_string($con,$_POST['sub_menu']);
		$tab_name = mysqli_real_escape_string($con,$_POST['tab_name']);
		$order_number = $_POST['order_number'];
		$tab_order_number = $_POST['tab_order_number'];
		$description = mysqli_real_escape_string($con,$_POST['description']);

		$upd = mysqli_query($con,"UPDATE `menu_with_tab`  SET menu='$menu', sub_menu='$sub_menu', tab_name='$tab_name', order_number='$order_number', tab_order_number='$tab_order_number', content='$description' WHERE id=$id");
		if($upd)
		{
			$_SESSION['success_msg'] = 'Menu has been updated...';
			echo"<script>window.location='menu-list-with-tab.php';</script>";
		}
		else
		{
			$_SESSION['error_msg'] = 'Unable to update Menu...';
			echo"<script>window.location='menu-list-with-tab.php';</script>";
		}
	}
?>