File: /var/www/nclive/technc/list_institute_course.php
<?php
include 'header.php';
$count="select count(*) as total from sp_exam_category";
$sql=$db->prepare($count);
$sql->execute();
$plus=$sql->fetch();
$query="Select ic.id,ic.institute_id,ic.course_id,i.institutions_name,c.course_name from sp_institute_courses as ic
left join sp_institutions as i on i.id=ic.institute_id
left join sp_courses as c on c.id=ic.course_id
";
$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">Exam Category List</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">Institute name</th>
<th class="text-center">Course name</th>
<th class="text-center">Edit</th>
<th class="text-center">Delete</th>
</tr>
</thead>
<?php $i='1';
while($row=$sql->fetch()){
$com=$row['course_id'];
$name=$row['course_name'];
$var=array($name);
// print("<pre>".print_r($var,true)."</pre>");
$ini=$row['institute_id'];
?>
<tr>
<td class="text-center"><?php echo $i; ?></td>
<td class="text-center"><?php echo $row['institutions_name']; ?></td>
<td class="text-center"><?php echo $row['cname']; ?></td>
<td class="text-center"><button name="edit" class="btn btn-info" onclick="selectData(<?php echo $row['institute_id']; ?>)" data-toggle="tooltip" title="Edit this exam">Edit</button></td>
<td class="text-center"><a style="color:#fff;" href="delete.php?id=<?php echo $row['institute_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'];
//$insti=$_REQUEST['ins'];
$course=$_REQUEST['cour'];
foreach($course as $c){
$query1="Update sp_institute_courses set course_id='$c' where institute_id='$id'";
$sql1 = $db->prepare($query1);
$sql1->execute();
echo '<h3 style="color:green;">Data Update successfully</h3>';
// 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">Do you want to change status ? </h4>
</div>
<div class="modal-body">
<form class="js-validation-bootstrap form-horizontal" method="post" action="" enctype="multipart/form-data" id="serial">
<div class="form-group">
<label class="col-md-4 control-label" for="val-username">Name<span class="text-danger">*</span></label>
<div class="col-md-7">
<input type="hidden" name="id" id="id">
<select class="js-select2 form-control" name="ins" style="width: 100%;">
<?php
$sql8 = $db->prepare("SELECT id,institutions_name FROM sp_institutions");
$sql8->execute();
?>
<option selected="selected" id="ins">--Select Institute--</option>
<?php
while($row8=$sql8->fetch(PDO::FETCH_ASSOC)){
?>
<option value="<?php echo $row8['id']; ?>"><?php echo $row8['institutions_name']; ?></option>
<?php } ?>
</select>
</div>
</div>
<div class="form-group">
<label class="col-md-2 control-label" for="val-password">Course name<span class="text-danger">*</span></label>
<div class="col-md-10">
<?php
echo $jk="select count(*) from sp_institute_courses where course_id='$com'";
$check=$db->prepare("select count(*) from sp_institute_courses where course_id='$com'");
$check->execute();
$count=$check->rowCount();
print_r($count);
if($count==1){
$checked = "checked";
} else {
$checked = "";
}
$cou=$db->prepare("select id,course_name from sp_courses order by id asc");
$cou->execute();
while($row3=$cou->fetch(PDO::FETCH_ASSOC)){ ?>
<div class="col-md-4">
<input <?php echo $checked; ?> class="form-control" type="checkbox" name="cour[]" value="<?php echo $row3['id']; ?>"><?php echo $row3['course_name']; ?>
</div>
<?php } ?>
</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>
<!---------END STATUS MODEL----->
<!-- END Page Content -->
</main>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
<script type="text/javascript">
function selectData(id) {
// alert(id);
$.ajax('list_institute_course_select.php', {
type: 'POST', // http method
data: { id:id }, // data to submit
success: function (data, status, xhr) {
console.log(data);
//console.log("njkj");
//console.log(data[0]);
document.getElementById('id').value = data.institute_id;
document.getElementById('ins').innerHTML = data.institutions_name;
//document.getElementById('chk').value=data.course_id;
//document.getElementById("img").files[0].name;
},
error: function (jqXhr, textStatus, errorMessage) {
}
});
jQuery("#statusModel").modal();
// body...
}
</script>
<?php include 'footer.php'; ?>
<!-- END Main Container -->