File: /var/www/nclive/technc/add_new_exam_editor.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 New Exam</h2>
<?php
$curDate = date('Y-m-d H:i:s');
if(isset($_REQUEST['submit'])){
$exam=$_REQUEST['exam_type'];
$examname=$_REQUEST['exam_name'];
$postname=$_REQUEST['post_name'];
$display=$_REQUEST['display'];
$examtype=$exam;
$exam_year=$_REQUEST['exam_year'];
$quali=$_REQUEST['quali'];
$quali_desc=$_REQUEST['quali_dis'];
$age=0;
$age_to=$_REQUEST['age_to'];
$age_from=$_REQUEST['age_from'];
$age_desc=$_REQUEST['age_dis'];
$exam_summary=$_REQUEST['summary'];
$exam_id=$_REQUEST['examid'];
$keyword=$_REQUEST['display'].$_REQUEST['exam_name'];
$fee=$_REQUEST['editor3'];
$feess=$_REQUEST['feess'];
$vacancy=$_REQUEST['vacancy'];
$link=$_REQUEST['link'];
$order=$_REQUEST['order'];
$status='0';
$ques=$_REQUEST['question'];
$mark=$_REQUEST['marks'];
$mode=$_REQUEST['mode'];
$marking=$_REQUEST['marking'];
$exam_category=$_REQUEST['category'];
$state=$_REQUEST['state'];
$state_commission=$_REQUEST['state_commission'];
$other_info = $_REQUEST['other_info'];
$tab = $_REQUEST['tabname'];
$important=$_REQUEST['important'];
$top_order = $_REQUEST['top_order'];
$query="INSERT INTO sp_exam set exam_name='$examname', post_name='$postname',exam_year='$exam_year', url_slug='$display', type_id='$examtype', cat_id='$exam_category',state_id='$state',state_commission='$state_commission', qualification_id='$quali', qualification_desc='$quali_desc', age_id='$age',age_to='$age_to', age_from='$age_from',age_desc='$age_desc',fee_desc='$fee', exam_summary='$exam_summary', total_vacancy='$vacancy',sp_exam_id='$exam_id',total_time='$ques',total_marks='$mark',exam_mode='$mode',negative_marking='$marking',off_web_link='$link', display_order='$order', status='$status', other_info='$other_info', other_info_tabname='$tab',important_notes='$important',add_by='$user_id',add_date='$curDate',update_date='$curDate',top_display_order='$top_order',fee='$feess'";
$sql=$db->prepare($query);
$sql->execute();
$lastid = $db->lastInsertId();
$query3="INSERT INTO sp_exam_update SET exam_id='$lastid',type='A',user_id='$user_id',date='$curDate', description='$desc'";
$sql2=$db->prepare($query3);
$sql2->execute();
if ($exam_category!='' OR $exam_category!=0)
{
$category=$exam_category;
echo $query22="INSERT INTO sp_pages_seo SET exam_id='$lastid', category_id='$category', title='$examname', keywords='$keyword', meta_description='$exam_summary', meta_keywords='$keyword', status='1',added_date='$curDate'";
}
else {
$category=$_REQUEST['state'];
$query22="INSERT INTO sp_pages_seo SET exam_id='$lastid', category_id='$category', title='$examname', keywords='$keyword', meta_description='$exam_summary', meta_keywords='$keyword', status='1',added_date='$curDate'";
}
$sql22=$db->prepare($query22);
$sql22->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" action="add_new_exam_editor.php" method="post" name="myForm" id="form">
<div class="form-group">
<label class="col-md-2 control-label" for="val-username">Exam Name<span class="text-danger">*</span></label>
<div class="col-md-10">
<input class="form-control" type="text" name="exam_name" placeholder="example:CGL Tier-I, SBI-Clerk">
</div>
</div>
<div class="form-group">
<label class="col-md-2 control-label" for="val-email">Post Name<span class="text-danger">*</span></label>
<div class="col-md-8">
<input class="form-control" type="text" name="post_name" placeholder="Enter post name">
</div>
<div class="col-md-2">
<select class="js-select2 form-control" name="exam_year">
<option value="2017">2017</option>
<option selected="selected" value="2018">2018</option>
<option value="2019">2019</option>
<option value="2020">2020</option>
<option value="2021">2021</option>
</select>
</div>
</div>
<div class="form-group">
<label class="col-md-2 control-label" for="val-password">Url Slug<span class="text-danger">*</span></label>
<div class="col-md-10">
<input class="form-control" type="text" name="display" placeholder="Enter Url slug">
</div>
</div>
<div class="form-group" >
<label class="col-md-2 control-label" for="val-select2">Select Exam Type<span class="text-danger">*</span></label>
<div class="col-md-10">
<select class="js-select2 form-control" name="exam_type" style="width: 100%;">
<option selected="selected" value="">--Select type--</option>
<option value="1">Central</option>
<option value="2">State</option>
</select>
</div>
</div>
<div class="form-group">
<label class="col-md-2 control-label" for="val-select2">Select Exam Category<span class="text-danger">*</span></label>
<div class="col-md-10">
<select class="js-select2 form-control" name="category" style="width: 100%;">
<?php
$sql = $db->prepare("SELECT cat_id,name FROM sp_exam_category");
$sql->execute();
?>
<option selected="selected">--Select category--</option>
<?php while($row=$sql->fetch(PDO::FETCH_ASSOC)) { ?>
<option value="<?php echo $row['cat_id']; ?>"><?php echo $row['name']; ?></option>
<?php } ?>
</select>
</div>
</div>
<div class="form-group" >
<label class="col-md-2 control-label" for="val-select2">Select State<span class="text-danger">*</span></label>
<div class="col-md-10">
<select class="js-select2 form-control" id="type2" name="state" style="width: 100%;">
<?php
$sql = $db->prepare("SELECT state_id,state_name FROM sp_states");
$sql->execute();
?>
<option selected="selected">--Select State--</option>
<?php while($row1=$sql->fetch(PDO::FETCH_ASSOC)) { ?>
<option value="<?php echo $row1['state_id']; ?>"><?php echo $row1['state_name']; ?></option>
<?php } ?>
</select>
</div>
</div>
<div class="form-group" >
<label class="col-md-2 control-label" for="val-select2">Select Commission<span class="text-danger">*</span></label>
<div class="col-md-10">
<select name="state_commission" class="form-control" id="statecommission">
<option selected="selected">Select Commission</option>
</select>
</div>
</div>
<div class="form-group" >
<label class="col-md-2 control-label" for="val-select2">Age<span class="text-danger">*</span></label>
<div class="col-md-2">
<input class="form-control" type="number" name="age_to" placeholder="To">
</div>
<div class="col-md-2">
<input class="form-control" type="number" name="age_from" placeholder="From">
</div>
<div class="col-md-6">
<input class="form-control" type="text" name="age_dis" placeholder="Age Description">
</div>
</div>
<div class="form-group" >
<label class="col-md-2 control-label" for="val-select2">Qualification<span class="text-danger">*</span></label>
<div class="col-md-4">
<select class="js-select2 form-control" name="quali" style="width: 100%;">
<?php
$sql = $db->prepare("SELECT qualification_id,quali_name FROM sp_qualification order by display_order ASC");
$sql->execute();
?>
<option selected="selected">Select Qualification</option>
<?php while($row=$sql->fetch(PDO::FETCH_ASSOC)) { ?>
<option value="<?php echo $row['qualification_id']; ?>"><?php echo $row['quali_name']; ?></option>
<?php } ?>
</select>
</div>
<div class="col-md-6">
<input class="form-control" type="text" name="quali_dis" placeholder="Qualification Description">
</div>
</div>
<div class="form-group">
<label class="col-md-2 control-label" for="val-confirm-password">Fees<span class="text-danger">*</span></label>
<div class="col-md-10">
<input class="form-control" type="number" name="feess" placeholder="500/-">
</div>
</div>
<div class="form-group">
<label class="col-md-2 control-label" for="val-confirm-password">Fee Description<span class="text-danger">*</span></label>
<div class="col-md-10">
<textarea class="ckeditor" name="editor3" id="editor3"></textarea>
</div>
</div>
<div class="form-group">
<label class="col-md-2 control-label" for="val-confirm-password">Exam Summary<span class="text-danger">*</span></label>
<div class="col-md-10">
<textarea class="ckeditor" name="summary" id="editor4"></textarea>
</div>
</div>
<div class="form-group">
<label class="col-md-2 control-label" for="val-confirm-password">Total Vacancy<span class="text-danger">*</span></label>
<div class="col-md-10">
<input class="form-control" type="number" name="vacancy" placeholder="">
</div>
</div>
<div class="form-group">
<label class="col-md-2 control-label" for="val-confirm-password">SP Exam id<span class="text-danger">*</span></label>
<div class="col-md-10">
<input class="form-control" type="text" name="examid" placeholder="">
</div>
</div>
<div class="form-group">
<label class="col-md-2 control-label" for="val-confirm-password">Total Time<span class="text-danger">*</span></label>
<div class="col-md-10">
<input class="form-control" type="text" name="question" placeholder="">
</div>
</div>
<div class="form-group">
<label class="col-md-2 control-label" for="val-confirm-password">Total Marks<span class="text-danger">*</span></label>
<div class="col-md-10">
<input class="form-control" type="text" name="marks" placeholder="">
</div>
</div>
<div class="form-group">
<label class="col-md-2 control-label" for="val-confirm-password">Exam Mode<span class="text-danger">*</span></label>
<div class="col-md-10">
<input class="form-control" type="text" name="mode" placeholder="">
</div>
</div>
<div class="form-group">
<label class="col-md-2 control-label" for="val-confirm-password">Negative Marking<span class="text-danger">*</span></label>
<div class="col-md-10">
<input class="form-control" type="text" name="marking" placeholder="">
</div>
</div>
<div class="form-group">
<label class="col-md-2 control-label" for="val-confirm-password">Official Website Link<span class="text-danger">*</span></label>
<div class="col-md-10">
<input class="form-control" type="text" name="link" placeholder="https://example.com">
</div>
</div>
<div class="form-group">
<label class="col-md-2 control-label" for="val-confirm-password">Tabname<span class="text-danger"></span></label>
<div class="col-md-10">
<input class="form-control" type="text" name="tabname" placeholder="" value="">
</div>
</div>
<div class="form-group">
<label class="col-md-2 control-label" for="val-confirm-password">Other Info<span class="text-danger"></span></label>
<div class="col-md-10">
<textarea class="ckeditor" name="other_info" id="editor4"></textarea>
</div>
</div>
<div class="form-group">
<label class="col-md-2 control-label" for="val-confirm-password">Important Notes<span class="text-danger"></span></label>
<div class="col-md-10">
<textarea class="ckeditor" name="important" id="editor4"></textarea>
</div>
</div>
<div class="form-group">
<label class="col-md-2 control-label" for="val-confirm-password">Display order<span class="text-danger">*</span></label>
<div class="col-md-10">
<input class="form-control" type="number" name="order" placeholder="">
</div>
</div>
<div class="form-group">
<label class="col-md-2 control-label" for="val-confirm-password">Top Display order<span class="text-danger">*</span></label>
<div class="col-md-10">
<input class="form-control" type="number" name="top_order" placeholder="">
</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/1.12.4/jquery.min.js"></script>
<script src="https://ajax.aspnetcdn.com/ajax/jquery.validate/1.9/jquery.validate.min.js"></script>
<script type="text/javascript">
$(document).ready(function()
{
$("#type2").change(function()
{
var id=$(this).val();
var dataString = 'id='+ id;
$.ajax
({
type: "POST",
url: "get_state_comm.php",
data: dataString,
cache: false,
success: function(html)
{
$("#statecommission").html(html);
}
});
});
});
</script>
<script type="text/javascript">
(function ($, W, D)
{
var JQUERY4U = {};
JQUERY4U.UTIL =
{
setupFormValidation: function ()
{
//form validation rules
$("#form").validate({
rules: {
exam_name: {
required: true,
},
post_name: {
required: true,
},
display: {
required: true,
},
exam_type: {
required: true,
},
editor1:{
required: true,
},
editor2: {
required:true,
},
editor3: {
required:true,
},
link: {
required:true,
},
exam_type: {
required:true,
},
order: {
required:true,
},
top_order: {
required:true,
}
},
messages: {
exam_name: "Please Enter exam name",
post_name: "Please Enter post name",
display: "Please Enter display name",
exam_type: "Please Enter exam type",
editor1:"Please Enter eligibility",
editor2: "Please Enter age limit",
editor3: "Please Enter fee description",
vacancy: "Please Enter vacancy number",
link: "Please Enter Website Url",
order: "Please Enter order number",
top_order: "Please Enter order number"
},
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'; ?>