File: /var/www/nclive/technc/physical_eligibility.php
<?php include 'header.php'; ?>
<style>
#form .form-group label.error {
color: #FB3A3A;
display: inline-block;
margin: 0px 0 0px 0px;
padding: 0;
text-align: left;
}
</style>
<main id="main-container">
<div class="content content-narrow">
<div class="row">
<div class="col-lg-12">
<h2 class="content-heading">Physical Eligibility</h2>
<?php
if(isset($_REQUEST['submit'])){
$examname= $_REQUEST['examname'];
$gender= $_REQUEST['gender'];
$category= $_REQUEST['category'];
$height=$_REQUEST['height'];
$Chest=$_REQUEST['Chest'];
$race=$_REQUEST['race'];
$time=$_REQUEST['time'];
$long_jump=$_REQUEST['long_jump'];
$high_jump=$_REQUEST['high_jump'];
$short_put=$_REQUEST['short_put'];
$age_limit=$_REQUEST['chance'];
$status=$_REQUEST['status'];
echo $query="INSERT INTO sp_physical_eligibility(exam_id, gender, categories, height, chest, race, time,long_jump, high_jump, short_put, chances, status) VALUES ('$examname','$gender','$category','$height','$Chest','$race','$time','$long_jump','$high_jump','$short_put','$age_limit','$status')";
$sql=$db->prepare($query);
if($sql->execute()){
echo '<h3 style="color:#000000;">Data submit successfully</h3>';
}
}
?>
<div class="block">
<div class="block-header">
<ul class="block-options">
<li>
<button type="button"><i class="si si-settings"></i></button>
</li>
</ul>
<h3 class="block-title"></h3>
</div>
<div class="block-content block-content-narrow">
<form class="js-validation-bootstrap form-horizontal" method="post" enctype="multipart/form-data" id="form">
<div class="form-group">
<label class="col-md-4 control-label" for="val-select2">Select Exam</label>
<div class="col-md-7">
<select class="js-select2 form-control" name="examname" style="width: 100%;">
<?php
$sql = $db->prepare("SELECT exam_id,exam_name FROM sp_exam");
$sql->execute();
?><option selected="selected">--Select exam--</option><?php
while($row=$sql->fetch(PDO::FETCH_ASSOC))
{
?>
<option value="<?php echo $row['exam_id']; ?>"><?php echo $row['exam_name']; ?></option>
<?php
} ?>
</select>
</div>
</div>
<div class="form-group">
<label class="col-md-4 control-label" for="val-password"> Gender <span class="text-danger">*</span></label>
<div class="col-md-7">
<select name="gender" class="form-control">
<option name="novalue" value="">-- Select Type --</option>
<option value="M"> Male </option>
<option value="F"> Female</option>
<option value="O"> Others</option>
</select>
</div>
</div>
<div class="form-group">
<label class="col-md-4 control-label" for="val-username">Category <span class="text-danger">*</span></label>
<div class="col-md-7">
<input class="form-control" type="text" name="category" placeholder="">
</div>
</div>
<div class="form-group">
<label class="col-md-4 control-label" for="val-username"> height <span class="text-danger">*</span></label>
<div class="col-md-7">
<input class="form-control" type="text" name="height" placeholder="">
</div>
</div>
<div class="form-group">
<label class="col-md-4 control-label" for="val-username"> Chest <span class="text-danger">*</span></label>
<div class="col-md-7">
<input class="form-control" type="text" name="Chest" placeholder="">
</div>
</div>
<div class="form-group">
<label class="col-md-4 control-label" for="val-username"> Race <span class="text-danger">*</span></label>
<div class="col-md-7">
<input class="form-control" type="text" name="race" placeholder="">
</div>
</div>
<div class="form-group">
<label class="col-md-4 control-label" for="val-username"> Time <span class="text-danger">*</span></label>
<div class="col-md-7">
<input class="form-control" type="text" name="time" placeholder="">
</div>
</div>
<div class="form-group">
<label class="col-md-4 control-label" for="val-username"> Long Jump <span class="text-danger">*</span></label>
<div class="col-md-7">
<input class="form-control" type="text" name="long_jump" placeholder="">
</div>
</div>
<div class="form-group">
<label class="col-md-4 control-label" for="val-username"> High Jump <span class="text-danger">*</span></label>
<div class="col-md-7">
<input class="form-control" type="text" name="high_jump" placeholder="">
</div>
</div>
<div class="form-group">
<label class="col-md-4 control-label" for="val-username"> Short put <span class="text-danger">*</span></label>
<div class="col-md-7">
<input class="form-control" type="text" name="short_put" placeholder="">
</div>
</div>
<div class="form-group">
<label class="col-md-4 control-label" for="val-username"> Chance <span class="text-danger">*</span></label>
<div class="col-md-7">
<input class="form-control" type="number" name="chance" placeholder="">
</div>
</div>
<div class="form-group">
<label class="col-md-4 control-label" for="val-password">Status<span class="text-danger">*</span></label>
<div class="col-md-7">
<select name="status" class="form-control">
<option value="">-- Select status --</option>
<option value="1"> Active </option>
<option value="0"> Deactive </option>
</select>
</div>
</div>
<div class="form-group">
<div class="col-md-8 col-md-offset-4">
<button class="btn btn-sm btn-primary" type="submit" name="submit">Submit</button>
</div>
</div>
</form>
</div>
</div>
</div>
</div>
</div>
</main>
<?php include 'footer.php'; ?>