<?php  
$page_title = 'Add Achievers';
include 'header.php';
?>
<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>Name</label>
											<input type="text" class="form-control" name="name" required />
										</div>
									</div>
									<div class="col-md-4">
										<div class="form-group">
											<label>Event</label>
											<input type="text" class="form-control" name="event" required />
										</div>
									</div>
									<div class="col-md-4">
										<div class="form-group">
											<label>Year</label>
											<input type="text" class="form-control" name="year" required />
										</div>
									</div>
								</div>
								<div class="row">
									<div class="col-md-4">
										<div class="form-group">
											<label>Place</label>
											<input type="text" class="form-control" name="place" required />
										</div>
									</div>
									<div class="col-md-4">
										<div class="form-group">
											<label>Section</label>
											<select name="section" class="form-control" required>
												<option selected>Achievers</option>
												<option>Sports</option>
											</select>
										</div>
									</div>
									<div class="col-md-4">
                                        <div class="form-group">
                                          <label for="exampleInputFile">File</label>
                                          <div class="input-group">
                                            <div class="custom-file">
                                              <input type="file" class="custom-file-input fileUpload_allow" name="profile_photo" id="exampleInputFile">
                                              <label class="custom-file-label" for="exampleInputFile">Choose file</label>
                                            </div>
                                          </div>
                                        </div>
                                      </div>
									<div class="col-md-12">
										<div class="form-group">
											<label>Remarks</label>
											<textarea class="text_editor" name="remarks">
											</textarea>
										</div>
									</div>
								</div>
								<button type="submit" class="btn btn-primary" name="btnSubmit">Submit</button>
							</div>
						</form>
					</div>
				</div>
			</div>
		</div>
	</section>
</div>
<?php include 'footer.php'; ?>


<?php
if(isset($_POST['btnSubmit']))
{
	$name = $_POST['name'];
	$event = $_POST['event'];
	$year = $_POST['year'];
	$place = $_POST['place'];
	$section = $_POST['section'];
	$remarks = mysqli_real_escape_string($con,$_POST['remarks']);
	
	$location = '';
	$upload = 0;
	if(isset($_FILES["profile_photo"]["name"]) && $_FILES["profile_photo"]["name"] !=  '') {
    	$fileinfo=PATHINFO($_FILES["profile_photo"]["name"]);
        $newFilename="achievers_". time()."." .$fileinfo['extension'];
        $location="uploads/achievers/" . $newFilename;
        $upload = 1;
	}

	$ins = mysqli_query($con,"INSERT INTO `achievers` (`id`, `name`, `event`, `year`, `place`, `remarks`, `section`, `file`) VALUES (NULL, '$name', '$event', '$year', '$place', '$remarks', '$section', '$location')");

	if($ins)
	{
	    if($upload == 1) {
	        move_uploaded_file($_FILES["profile_photo"]["tmp_name"],$location);
	    }
		$_SESSION['success_msg'] = 'Achievers has been added...';
		echo"<script>window.location='achievers.php';</script>";
	}
	else
	{
		$_SESSION['error_msg'] = 'Unable to add Achievers...';
		echo"<script>window.location='achievers.php';</script>";
	}
}
?>