File: /var/www/nclive/technc/list_course.php
<?php
include 'header.php';
$count="select count(*) as total from sp_institute_courses";
$sql=$db->prepare($count);
$sql->execute();
$plus=$sql->fetch();
$query="SELECT t1.id, t1.course_name, t1.course_code, t1.display_order, t1.status, t1.added_date FROM sp_courses as t1";
$sql=$db->prepare($query);
$sql->execute();
?>
<!-- Main Container -->
<main id="main-container">
<div class="content content-narrow">
<!-- Forms Row -->
<div class="row">
<div class="col-lg-12">
<!-- Bootstrap Forms Validation -->
<h2 class="content-heading">List Course</h2>
<table class="table table-striped table-hover text-capitalize">
<thead>
<tr class="danger">
<th class="text-center">S.no</th>
<th class="text-center">Course Name</th>
<th class="text-center">Course Code</th>
<th class="text-center">Display Order </th>
<th class="text-center">status</th>
<th class="text-center"> Added Date</th>
<th class="text-center">Edit</th>
<th class="text-center">Delete</th>
</tr>
</thead>
<?php $i='1';
while($row=$sql->fetch()){
?>
<tr>
<td class="text-center"><?php echo $i; ?></td>
<td class="text-center"><?php echo $row['course_name']; ?></td>
<td class="text-center"><?php echo $row['course_code']; ?></td>
<td class="text-center"><?php echo $row['display_order']; ?></td>
<td class="text-center"><?php if($row['status']=="1"){echo '<span style="color:green;">Active </span>';}else if($row['status']=="0"){echo '<span style="color:red;">De-Active </span>';} ?></td>
<td class="text-center"><?php echo date('d-M-Y',strtotime($row['added_date'])); ?></td>
<td class="text-center"><button name="edit" class="btn btn-info" onclick="selectData(<?php echo $row['id']; ?>)" data-toggle="tooltip" title="Edit this exam">Edit</button></td>
<td class="text-center"><a style="color:#fff;" href="list_course_delete.php?id=<?php echo $row['id'];?>" onclick="return confirm('Are you sure you want to delete')"><button class="btn btn-danger" data-toggle="tooltip" title="Delete this exam!" data-placement="bottom">Delete</button></a></td>
</tr>
<?php $i++; } ?>
<tr class="danger">
<th colspan='4'>Total Category</th>
<td colspan='4'><?php echo $plus['total']; ?></td>
</tr>
</table>
<!-- Bootstrap Forms Validation -->
</div>
</div>
</div>
<!-- END Forms Row -->
</div>
<?php
if(isset($_REQUEST['submit'])){
$id=$_REQUEST['id'];
$course= $_REQUEST['course'];
$course_code= $_REQUEST['code'];
$order=$_REQUEST['order'];
$status=$_REQUEST['status'];
$query="UPDATE sp_courses SET course_name = '$course', course_code = '$course_code', display_order = '$order',status='$status' WHERE id = '$id'";
$sql=$db->prepare($query);
$sql->execute();
echo "<meta http-equiv='refresh' content='0'>";
}
?>
<!-------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" action="" method="post" enctype="multipart/form-data" id="form">
<div class="form-group">
<label class="col-md-4 control-label" for="val-select2">Course Name</label>
<div class="col-md-7">
<input type="hidden" name="id" id="id">
<input type="text" class="form-control" name="course" placeholder="Enter Course Name" id="course">
</div>
</div>
<div class="form-group">
<label class="col-md-4 control-label" for="val-confirm-password">Course Code<span class="text-danger">*</span></label>
<div class="col-md-7">
<input type="text" class="form-control" name="code" placeholder="Enter Course Code" id="code">
</div>
</div>
<div class="form-group">
<label class="col-md-4 control-label" for="val-email">Display Order <span class="text-danger">*</span></label>
<div class="col-md-7">
<input type="number" class="form-control" name="order" placeholder="Enter display order" id="order">
</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="form-control" name="status">
<option selected="selected" id="status" value=""></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>
<!---------END STATUS MODEL----->
<!-- END Page Content -->
</main>
<script type="text/javascript">
function selectData(id) {
var base_url = window.location.origin;
// alert(id);
$.ajax('list_courses_edit.php', {
type: 'POST',
dataType: 'json',
"processing": true,
"serverSide": true,
data: { id:id },
success: function (data) {
console.log(data);
document.getElementById("course").value=data.course_name;
//document.getElementById("institute").innerHTML=data.institutions_name;
document.getElementById("code").value=data.course_code;
//document.getElementById("course").innerHTML=data.course_name;
document.getElementById("order").value=data.display_order;
document.getElementById("id").value=id;
document.getElementById("status").value=data.status;
if(document.getElementById("status").value=="1"){
document.getElementById("status").innerHTML="Active";
}
else if(document.getElementById("status").value=="0"){
document.getElementById("status").innerHTML="De-Active";
}
},
error: function (jqXhr, textStatus, errorMessage) {
}
});
jQuery("#statusModel").modal();
}
</script>
<?php include 'footer.php'; ?>
<!-- END Main Container -->