File: /var/www/nclive/technc/exam_cutoff.php
<?php include 'header.php'; ?>
<main id="main-container">
<div class="content content-narrow">
<div class="row">
<div class="col-lg-12">
<h2 class="content-heading">Add Exam Cutoff</h2>
<?php
if(isset($_REQUEST['submit'])){
$exam=$_REQUEST['examname'];
$year=$_REQUEST['year'];
$general=$_REQUEST['general'];
$obc=$_REQUEST['obc'];
$sc=$_REQUEST['scst'];
$ex=$_REQUEST['exserv'];
$wo=$_REQUEST['women'];
$comment=$_REQUEST['comment'];
$ot=$_REQUEST['other'];
$status=$_REQUEST['status'];
$query="INSERT INTO sp_exam_cutoff set exam_id='$exam',year='$year',st_sc='$sc',obc='$obc',gen='$general',women='$wo',ex_servicemen='$ex',others='$ot',comment='$comment',status='$status'";
$sql=$db->prepare($query);
$sql->execute();
echo '<h3 style="color:#000000;">Data submit successfully</h3>';
}
else{
echo '<h3 style="color:#b80000;">Please Select Exam</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" action="exam_cutoff.php" method="post" id="form">
<div class="form-group">
<label class="col-md-2 control-label" for="val-select2">Select Exam</label>
<div class="col-md-10">
<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-2 control-label" for="val-username">Year<span class="text-danger">*</span></label>
<div class="col-md-10">
<input class="form-control" type="text" name="year" placeholder="">
</div>
</div>
<div class="form-group">
<label class="col-md-2 control-label" for="val-password">General<span class="text-danger">*</span></label>
<div class="col-md-10">
<input class="form-control" type="text" name="general" placeholder="">
</div>
</div>
<div class="form-group">
<label class="col-md-2 control-label" for="val-password">OBC<span class="text-danger">*</span></label>
<div class="col-md-10">
<input class="form-control" type="text" name="obc" placeholder="">
</div>
</div>
<div class="form-group">
<label class="col-md-2 control-label" for="val-password">SC/ST<span class="text-danger">*</span></label>
<div class="col-md-10">
<input class="form-control" type="text" name="scst" placeholder="">
</div>
</div>
<div class="form-group">
<label class="col-md-2 control-label" for="val-password">Ex-Servicemen<span class="text-danger">*</span></label>
<div class="col-md-10">
<input class="form-control" type="text" name="exserv" placeholder="">
</div>
</div>
<div class="form-group">
<label class="col-md-2 control-label" for="val-password">Women<span class="text-danger">*</span></label>
<div class="col-md-10">
<input class="form-control" type="text" name="women" placeholder="">
</div>
</div>
<div class="form-group">
<label class="col-md-2 control-label" for="val-password">Others<span class="text-danger">*</span></label>
<div class="col-md-10">
<input class="form-control" type="text" name="other" placeholder="">
</div>
</div>
<div class="form-group">
<label class="col-md-2 control-label" for="val-password">Comments<span class="text-danger">*</span></label>
<div class="col-md-10">
<textarea class="form-control" placeholder="Comments" cols="20" name="comment"></textarea>
</div>
</div>
<div class="form-group">
<label class="col-md-2 control-label" for="val-password">Status<span class="text-danger">*</span></label>
<div class="col-md-10">
<select name="status" class="form-control">
<option value="1">Active</option>
<option value="0">Deactive</option>
</select>
</div>
</div>
<div class="form-group">
<div class="col-md-10 col-md-offset-2">
<button class="btn btn-lg btn-primary" type="submit" name="submit">Submit</button>
</div>
</div>
</form>
</div>
</div>
</div>
</div>
</div>
</main>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.1.1/jquery.min.js"></script>
<script src="https://ajax.googleapis.com/ajax/libs/jqueryui/1.12.1/jquery-ui.min.js"></script>
<script src="https://ajax.aspnetcdn.com/ajax/jquery.validate/1.9/jquery.validate.min.js"></script>
<script type="text/javascript" charset="utf-8">
$(document).ready(function(){
$('#normal').on('change', function() {
$("#single").css('display','block');
$("#fromto").css('display','none');
});
$('#ft').on('change', function() {
$("#fromto").css('display','block');
$("#single").css('display','none');
});
});
</script>
<script type="text/javascript">
(function ($, W, D)
{
var JQUERY4U = {};
JQUERY4U.UTIL =
{
setupFormValidation: function ()
{
//form validation rules
$("#form").validate({
rules: {
examname: {
required: true,
},
year: {
required: true,
},
general: {
required: true,
},
obc: {
required: true,
},
scst: {
required: true,
},
exserv: {
required: true,
},
women: {
required: true,
},
other: {
required: true,
},
comment: {
required: true,
},
},
messages: {
examname: "Please select exam name",
entity: "Please select exam name",
dis_text: "Please select exam name",
editor: "Please fill exam title details",
link: "Please fill link details"
},
submitHandler: function (form) {
form.submit();
}
});
}
}
//when the dom has loaded setup form validation rules
$(D).ready(function ($) {
JQUERY4U.UTIL.setupFormValidation();
});
})(jQuery, window, document);
</script>
<?php include 'footer.php'; ?>