<?php  
$id=0;
if(isset($_GET['id']))
{
	$page_title = 'Edit Committee';
	include 'header.php';
	$id = $_GET['id'];
	$sel=mysqli_query($con,"select * from committee where id=$id");
	while($row_committee=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-4">
												<div class="form-group">
													<label>Committee</label>
													<input type="text" class="form-control" name="committee" value="<?php echo $row_committee['committee']; ?>" required />
												</div>
											</div>
											<div class="col-md-4">
												<div class="form-group">
													<label>Name</label>
													<input type="text" class="form-control" name="name" value="<?php echo $row_committee['name']; ?>" required />
												</div>
											</div>
											<div class="col-md-4">
												<div class="form-group">
													<label>Designation</label>
													<input type="text" class="form-control" name="designation" value="<?php echo $row_committee['designation']; ?>" required />
												</div>
											</div>
										</div>
										<div class="row">
											<div class="col-md-4">
												<div class="form-group">
													<label>Others</label>
													<input type="text" class="form-control" name="others" value="<?php echo $row_committee['others']; ?>" required />
												</div>
											</div>
											<div class="col-md-4">
												<div class="form-group">
													<label>Order</label>
													<input type="number" class="form-control" name="order" value="<?php echo $row_committee['order_by']; ?>" required />
												</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='committee-list.php';</script>";
}
?>


<?php
if(isset($_POST['btnSubmit']))
{
	$committee = $_POST['committee'];
	$name = $_POST['name'];
	$designation = $_POST['designation'];
	$others = $_POST['others'];
	$order = $_POST['order'];

	$upd = mysqli_query($con,"UPDATE `committee`  SET committee='$committee', name='$name',  designation='$designation',  others='$others', order_by=$order WHERE id=$id");
	if($upd)
	{
		$_SESSION['success_msg'] = 'Committee has been updated...';
		echo"<script>window.location='committee-list.php';</script>";
	}
	else
	{
		$_SESSION['error_msg'] = 'Unable to update Committee...';
		echo"<script>window.location='committee-list.php';</script>";
	}
}
?>