File: /home/nyiet8349bzl/iecbm.sbsc.in/iecbm.sbsc.in/student-list.php
<?php
include("../config/connection.php");
$connection = new createCon();
$connection->connect();
if($_SESSION['admin']['user_id']=='')
{
echo "<script>window.location.href='index.php'</script>";
}
if(isset($_REQUEST['action']) and ($_REQUEST['action']=='Delete'))
{
$id = $_REQUEST['id'];
$sql = mysqli_query($connection->myconn, "DELETE FROM student WHERE id = '".$id."'");
if($sql==true)
{
echo "<script>alert('Information successfully deleted.')</script>";
echo "<script>window.location='student-list.php'</script>";
}
}
?>
<!doctype html>
<html class="fixed">
<head>
<title>Admin</title>
<?php include("inc-head.php"); ?>
</head>
<body>
<section class="body">
<?php include("inc-header.php"); ?>
<div class="inner-wrapper">
<?php include("inc-navigation.php"); ?>
<section role="main" class="content-body">
<header class="page-header">
<h2>Student Management</h2>
<div class="right-wrapper pull-right">
<ol class="breadcrumbs">
<li>
<a href="dashboard.php">
<i class="fa fa-home"></i>
</a>
</li>
<li><span>Student List</span></li>
</ol>
<a class="sidebar-right-toggle"></a>
</div>
</header>
<!-- start: page -->
<section class="panel">
<header class="panel-heading">
<div class="panel-actions">
<a href="#" class="panel-action panel-action-toggle" data-panel-toggle></a>
<a href="#" class="panel-action panel-action-dismiss" data-panel-dismiss></a>
</div>
<h2 class="panel-title">Student List</h2>
</header>
<div class="panel-body">
<div style="width:100%; overflow:scroll">
<table class="table table-bordered table-striped mb-none" id="example" >
<thead>
<tr>
<th>Title</th>
<th>First Name</th>
<th>Last Name</th>
<th>Institution</th>
<th>Registration Category</th>
<th>Research Field</th>
<th>Email</th>
<th>Phone</th>
<th>Create</th>
<th>Delete</th>
</tr>
</thead>
<tbody>
<?php
$sql = mysqli_query($connection->myconn, "SELECT * FROM student order by id desc") or die(mysqli_error($connection->myconn));
while($rows=mysqli_fetch_array($sql))
{
$createdOn=date('d M Y',strtotime($rows['created_on']));
?>
<tr>
<td><?php echo $rows['title']; ?></td>
<td><?php echo $rows['fname']; ?></td>
<td><?php echo $rows['lname']; ?></td>
<td><?php echo $rows['institution']; ?></td>
<td><?php echo $rows['category']; ?></td>
<td><?php echo $rows['field']; ?></td>
<td><?php echo $rows['email']; ?></td>
<td><?php echo $rows['mobile']; ?></td>
<td><?php echo $createdOn; ?></td>
<td class="actions">
<a style="color:#FF0000;" href="student-list.php?action=Delete&id=<?php echo $rows['id'] ?>" title="Delete" onClick="return confirm('Are you sure want to delete ?')">
<i class="fa fa-trash-o fa-2x"></i>
</a>
</td>
</tr>
<?php } ?>
</tbody>
</table>
</div>
</div>
</section>
<!-- end: page -->
</section>
</div>
</section>
<?php include("inc-footer.php"); ?>
<!-- Specific Page Vendor -->
<script src="assets/vendor/select2/js/select2.js"></script>
<script src="assets/vendor/jquery-datatables/media/js/jquery.dataTables.js"></script>
<script src="assets/vendor/jquery-datatables-bs3/assets/js/datatables.js"></script>
<!-- Theme Base, Components and Settings -->
<script src="assets/javascripts/theme.js"></script>
<!-- Theme Custom -->
<script src="assets/javascripts/theme.custom.js"></script>
<!-- Theme Initialization Files -->
<script src="assets/javascripts/theme.init.js"></script>
<!-- Examples -->
<script src="assets/javascripts/tables/examples.datatables.editable.js"></script>
<!----------------------FOR DOWNLOAD PDF AND EXCEL START------------------------>
<script src="https://cdn.datatables.net/buttons/1.2.4/js/dataTables.buttons.min.js"></script>
<script src="//cdnjs.cloudflare.com/ajax/libs/jszip/2.5.0/jszip.min.js"></script>
<script src="//cdn.datatables.net/buttons/1.2.4/js/buttons.html5.min.js"></script>
<!----------------------FOR DOWNLOAD PDF AND EXCEL END------------------------>
<script>
$(document).ready(function(){
$('#example').DataTable({
dom: 'lBfrtip',
buttons: {
buttons: [
{ extend: 'excel', className: 'btn btn-default',text: 'Download as Excel' },
]
}
});
});
</script>
</body>
</html>