File: /var/www/nclive/technc/exam_question_pattern.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">
<?php
if(isset($_REQUEST['update'])){
$sub=$_REQUEST['subject'];
$questions=$_REQUEST['que'];
$marks=$_REQUEST['marks'];
$st=$_REQUEST['status'];
$id=$_REQUEST['id'];
$query="UPDATE sp_exam_pattern SET subject_name='$sub',no_of_question='$questions',marks_for_subject='$marks',status='$st' WHERE id='$id'";
$sql = $db->prepare($query);
if($sql->execute()){
echo '<b><span style="color:green;">Updated</span></b>';
}
else{'<b><span style="color:red;">Something Wrong!</span></b>';}
}
if(isset($_REQUEST['addnew'])){
$addsub=$_REQUEST['subject2'];
$addquestions=$_REQUEST['que2'];
$addmarks=$_REQUEST['marks2'];
$addst=$_REQUEST['status2'];
$addid=$_REQUEST['id2'];
$query2="INSERT INTO sp_exam_pattern(exam_id, subject_name, no_of_question, marks_for_subject, status) VALUES ('$addid','$addsub','$addquestions','$addmarks','$addst')";
$sql2 = $db->prepare($query2);
if($sql2->execute()){
echo '<b><span style="color:green;">Subject Added</span></b>';
}
else{'<b><span style="color:red;">Something Wrong!</span></b>';}
}
?>
<div class="row">
<div class="col-lg-12">
<h2 class="content-heading">Exam Question Pattern</h2>
<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_question_pattern.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" value="">--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">
<div class="col-md-10 col-md-offset-2">
<button class="btn btn-lg btn-primary" name="submit" type="submit">Submit</button>
</div>
</div>
</form>
<?php
if(isset($_REQUEST['submit'])){
$exam=$_REQUEST['examname'];
$query="SELECT id,exam_id, subject_name, no_of_question, marks_for_subject, status FROM sp_exam_pattern WHERE exam_id='$exam'";
$sql=$db->prepare($query);
$sql->execute(); ?>
<button style="margin-left: 705px;" onclick="adddata( <?php echo $exam; ?>)" class="btn btn-sm btn-primary" >Add Subject </button>
</br></br>
<table class="table table-bordered">
<thead>
<tr>
<th> Subject Name</th>
<th>No of Question</th>
<th> Marks For subject</th>
<th> Status</th>
<th> Edit </th>
</tr>
</thead>
<tbody>
<?php while($row=$sql->fetch()){
?>
<tr>
<td> <?php echo $row['subject_name']; ?></td>
<td> <?php echo $row['no_of_question']; ?></td>
<td><?php echo $row['marks_for_subject']; ?></td>
<td><?php if($row['status']=="1"){echo '<span style="color:green;">Active</span>';}elseif($row['status']=="0"){echo '<span style="color:red;">De-active</span>';} ?></td>
<td><button name="edit" class="btn btn-info" onclick="selectData(<?php echo $row['id']; ?>)" data-toggle="tooltip" title="Edit this exam">Edit</button></td>
</tr>
<?php } ?>
</tbody>
</table>
<?php } ?>
</div>
</div>
</div>
</div>
</div>
</div>
</main>
<!-------STATUS MODEL------------------------------->
<div class=" modal fade" id="statusModel" role="dialog">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal">×</button>
<h4 class="modal-title">Edit</h4>
</div>
<div class="modal-body">
<form class="js-validation-bootstrap form-horizontal" method="post" id="serial">
<div class="form-group">
<label class="col-md-4 control-label" for="val-username">Subject Name<span class="text-danger">*</span></label>
<div class="col-md-7">
<input type="hidden" name="id" id="id">
<input class="form-control" type="text" id="subject" name="subject" value="" required/>
</div>
</div>
<div class="form-group">
<label class="col-md-4 control-label" for="question"> No. of Questions<span class="text-danger">*</span></label>
<div class="col-md-7">
<input class="form-control" type="number" id="que" name="que" value="" required/>
</div>
</div>
<div class="form-group">
<label class="col-md-4 control-label" for="val-email">Marks for Subject<span class="text-danger">*</span></label>
<div class="col-md-7">
<input class="form-control" type="number" id="marks" name="marks" value="" required/>
</div>
</div>
<div class="form-group">
<label class="col-md-4 control-label" for="val-confirm-password">Status<span class="text-danger">*</span></label>
<div class="col-md-7">
<select class="js-select2 form-control" id="type1" name="status" style="width: 100%;">
<option id="status" value="1">Active</option>
<option value="1">Active</option>
<option value="0">De -Active</option>
</select>
</div>
</div>
<div class="col-md-6">
</div>
<button type="submit" class="btn btn-success" name="update">Update</button>
</form>
</div>
</div>
</div>
</div>
<!---------END STATUS MODEL----->
<!-------STATUS MODEL--2------------------------------->
<div class=" modal fade" id="statusModel2" role="dialog">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal">×</button>
<h4 class="modal-title">Add more Subject</h4>
</div>
<div class="modal-body">
<form class="js-validation-bootstrap form-horizontal" method="post" id="serial">
<div class="form-group">
<label class="col-md-4 control-label" for="val-username">Subject Name<span class="text-danger">*</span></label>
<div class="col-md-7">
<input type="hidden" name="id2" id="id2">
<input class="form-control" type="text" id="subject" name="subject2" value="" required/>
</div>
</div>
<div class="form-group">
<label class="col-md-4 control-label" for="val-email"> No. of Questions<span class="text-danger">*</span></label>
<div class="col-md-7">
<input class="form-control" type="number" id="que" name="que2" value="">
</div>
</div>
<div class="form-group">
<label class="col-md-4 control-label" for="val-email">Marks for Subject<span class="text-danger">*</span></label>
<div class="col-md-7">
<input class="form-control" type="number" id="marks" name="marks2" value="" >
</div>
</div>
<div class="form-group">
<label class="col-md-4 control-label" for="val-confirm-password">Status<span class="text-danger">*</span></label>
<div class="col-md-7">
<select class="js-select2 form-control" id="type1" name="status2" style="width: 100%;">
<option id="status" value="1">Active</option>
<option value="1">Active</option>
<option value="0">De -Active</option>
</select>
</div>
</div>
<div class="col-md-6">
</div>
<button type="submit" class="btn btn-success" name="addnew">Add </button>
</form>
</div>
</div>
</div>
</div>
<!---------END STATUS MODEL----->
<script type="text/javascript">
function selectData(id) {
$.ajax('exam_question_pattern_update.php', {
type: 'POST',
dataType: 'json',
data: { id:id },
success: function (data) {
document.getElementById("subject").value=data.subname;
document.getElementById("que").value=data.ques;
document.getElementById("marks").value=data.mark;
document.getElementById("status").value=data.status;
document.getElementById("id").value=id;
},
error: function (jqXhr, textStatus, errorMessage) {
}
});
jQuery("#statusModel").modal();
}
function adddata(id) {
jQuery("#statusModel2").modal();
document.getElementById("id2").value=id;
}
(function ($, W, D)
{
var JQUERY4U = {};
JQUERY4U.UTIL =
{
setupFormValidation: function ()
{
//form validation rules
$("#form").validate({
rules: {
examname: {
required: true,
},
subject_name: {
required: true,
}, questions: {
required: true,
}, marks: {
required: true,
}, status: {
required: true,
},
messages: {
examname: "Please select exam name",
subject_name: "Please select subject name",
questions: "Please select questions",
marks: "Please fill marks",
status: "Please fill status"
},
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'; ?>