<?php  
$id=0;
if(isset($_GET['id']))
{
	$page_title = 'Edit Facilities';
	include 'header.php';
	$id = $_GET['id'];
	$sel=mysqli_query($con,"select * from facilities where id=$id");
	while($row_facilities=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-8">
												<div class="row">
													<div class="col-md-6">
														<div class="form-group">
															<label>Name</label>
															<input type="text" class="form-control" name="name" value="<?php echo $row_facilities['name']; ?>" required />
														</div>
													</div>
													<div class="col-md-6">
														<div class="form-group">
															<label>Department</label>
															<input type="text" class="form-control" name="department" required value="<?php echo $row_facilities['department']; ?>" />
														</div>
													</div>
												</div>
												<div class="row">
													<div class="col-md-12">
														<div class="form-group">
															<label>Description</label>
															<textarea class="text_editor" name="description">
																<?php echo $row_facilities['description']; ?>
															</textarea>
														</div>
													</div>
												</div>
												<div class="row">
													<div class="col-md-12">
														<div class="form-group">
															<label for="exampleInputFile">Photos</label>
															<div class="input-group">
																<div class="custom-file">
																	<input type="file" class="custom-file-input fileUpload_allow" name="facilities_photo" id="exampleInputFile">
																	<label class="custom-file-label" for="exampleInputFile">Choose file</label>
																</div>
															</div>
														</div>
													</div>
												</div>
											</div>
											<div class="col-md-4">
												<div class="form-group">
													<label for="exampleInputFile">Photos</label>
													<img src="<?php echo $row_facilities['photo']; ?>" style="width:100%;" />
												</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='facilities-list.php';</script>";
}
?>


<?php
if(isset($_POST['btnSubmit']))
{
	$name = $_POST['name'];
	//echo "test=".$name; exit;
	$description = mysqli_real_escape_string($con,$_POST['description']);
	$department = $_POST['department'];

	if($_FILES["facilities_photo"]["name"]!="")
	{
		$fileinfo=PATHINFO($_FILES["facilities_photo"]["name"]);
		$newFilename="facilities_". time()."." .$fileinfo['extension'];

		$location="uploads/facilities/" . $newFilename;
		$upd = mysqli_query($con,"UPDATE `facilities`  SET name='$name', department='$department',  description='$description', photo='$location' WHERE id=$id");

		if($upd)
		{
			move_uploaded_file($_FILES["facilities_photo"]["tmp_name"],$location);
			$_SESSION['success_msg'] = 'Facilities has been updated...';
			echo"<script>window.location='facilities-list.php';</script>";
		}
		else
		{
			$_SESSION['error_msg'] = 'Unable to update Facilities...';
			echo"<script>window.location='facilities-list.php';</script>";
		}
	}
	else
	{
		$upd = mysqli_query($con,"UPDATE `facilities`  SET name='$name', department='$department',  description='$description' WHERE id=$id");
		if($upd)
		{
			$_SESSION['success_msg'] = 'Facilities has been updated...';
			echo"<script>window.location='facilities-list.php';</script>";
		}
		else
		{
			$_SESSION['error_msg'] = 'Unable to update Facilities...';
			echo"<script>window.location='event-list.php';</script>";
		}
	}
}
?>