Online Student Attendance System in PHP Mysql
Do you know Online Attendance Management System is an advance tool, which help us to manage and maintain the records of student attendance. This type of tool mainly a one type of software that keep observe attendance details.
Here this is online attendance system, that means this system has very useful technique, because this system we can access from anywhere from any device, because this system has been develop by responsive web technology.
This is very simple and user friendly attendance management system for teacher, who want to digitize their student attendance record online. Digitize means convert paper work process into digital form, and store all data online, So he can view all details in single click.
For make this student attendance system in PHP Mysql, we have use all opensource technology like PHP, Mysql, jQery, Ajax, Bootstrap 4, jQuery Datatable plugin, Bootstrap Datepicker plugin. If you are looiking for your College project, then you can use this system in your education project also.
So, are you ready for learn how to make simple Student Attendance system in PHP and Mysql. So you have come on right place with right time, because here we have make tutorial on attendance management system by using latest web technology.
Features of Attendance Management System
The main feature of this Student Attendance system is that store student daily attendance record, and make PDF report from attendance data. This is very simple system, there are main two user, one is admin and other one is teacher. Admin has all rights for view or access system data, while teacher has rights to view only his or her grade student data. In this system Admin and teacher password has been store in encrypted form.
User of this System
Admin
Teacher
Admin Activity
Admin can Add Update Delete Grade Master Data
Admin has rights to add new teacher account, edit teacher details, and remove teacher account
Admin can assign grade to teacher, so teacher can view his or her student and take attendace of that student only.
Admin can Add new student, edit existing student and delete student data. Student grade also assign by admin only.
Admin can view all student attendance records of any grade.
Admin can make pdf report of any student attendance record
Admin can view all student overall attendance details in percentage form.
Teacher Activity
Teacher can update his or her profile details like change password, change profile picture etc
Teacher can view his or her grade student list.
Teacher can take attendance of his or her grade student.
Teacher can view his or her grade student attendance details
Teacher can generate PDF report of Attendance records.
Teacher can view overall attendance percentage of all student of his or her grade.
We have following Web Technology has been used for this attendance management system.
Database Structure
Directory Stucture
Below you can find directory structure of this attendance management system project in PHP.
admin/database_connection.php
<?php
//database_connection.php
$connect = new PDO("mysql:host=localhost;dbname=attendance","root","");
$base_url = "http://localhost/tutorial/student-attendance-system-in-php-using-ajax/";
function get_total_records($connect, $table_name)
{
$query = "SELECT * FROM $table_name";
$statement = $connect->prepare($query);
$statement->execute();
return $statement->rowCount();
}
function load_grade_list($connect)
{
$query = "
SELECT * FROM tbl_grade ORDER BY grade_name ASC
";
$statement = $connect->prepare($query);
$statement->execute();
$result = $statement->fetchAll();
$output = '';
foreach($result as $row)
{
$output .= '<option value="'.$row["grade_id"].'">'.$row["grade_name"].'</option>';
}
return $output;
}
function get_attendance_percentage($connect, $student_id)
{
$query = "
SELECT
ROUND((SELECT COUNT(*) FROM tbl_attendance
WHERE attendance_status = 'Present'
AND student_id = '".$student_id."')
* 100 / COUNT(*)) AS percentage FROM tbl_attendance
WHERE student_id = '".$student_id."'
";
$statement = $connect->prepare($query);
$statement->execute();
$result = $statement->fetchAll();
foreach($result as $row)
{
if($row["percentage"] > 0)
{
return $row["percentage"] . '%';
}
else
{
return 'NA';
}
}
}
function Get_student_name($connect, $student_id)
{
$query = "
SELECT student_name FROM tbl_student
WHERE student_id = '".$student_id."'
";
$statement = $connect->prepare($query);
$statement->execute();
$result = $statement->fetchAll();
foreach($result as $row)
{
return $row["student_name"];
}
}
function Get_student_grade_name($connect, $student_id)
{
$query = "
SELECT tbl_grade.grade_name FROM tbl_student
INNER JOIN tbl_grade
ON tbl_grade.grade_id = tbl_student.student_grade_id
WHERE tbl_student.student_id = '".$student_id."'
";
$statement = $connect->prepare($query);
$statement->execute();
$result = $statement->fetchAll();
foreach($result as $row)
{
return $row['grade_name'];
}
}
function Get_student_teacher_name($connect, $student_id)
{
$query = "
SELECT tbl_teacher.teacher_name
FROM tbl_student
INNER JOIN tbl_grade
ON tbl_grade.grade_id = tbl_student.student_grade_id
INNER JOIN tbl_teacher
ON tbl_teacher.teacher_grade_id = tbl_grade.grade_id
WHERE tbl_student.student_id = '".$student_id."'
";
$statement = $connect->prepare($query);
$statement->execute();
$result = $statement->fetchAll();
foreach($result as $row)
{
return $row["teacher_name"];
}
}
function Get_grade_name($connect, $grade_id)
{
$query = "
SELECT grade_name FROM tbl_grade
WHERE grade_id = '".$grade_id."'
";
$statement = $connect->prepare($query);
$statement->execute();
$result = $statement->fetchAll();
foreach($result as $row)
{
return $row["grade_name"];
}
}
?>
Admin Login
admin/login.php
<?php
//login.php
include('database_connection.php');
session_start();
if(isset($_SESSION["admin_id"]))
{
header('location:index.php');
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<title>Student Attendance System in PHP using Ajax</title>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css">
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.4.0/jquery.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.7/umd/popper.min.js"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.3.1/js/bootstrap.min.js"></script>
</head>
<body>
<div class="jumbotron text-center" style="margin-bottom:0">
<h1>Student Attendance System</h1>
</div>
<div class="container">
<div class="row">
<div class="col-md-4">
</div>
<div class="col-md-4" style="margin-top:20px;">
<div class="card">
<div class="card-header">Admin Login</div>
<div class="card-body">
<form method="post" id="admin_login_form">
<div class="form-group">
<label>Enter Username</label>
<input type="text" name="admin_user_name" id="admin_user_name" class="form-control" />
<span id="error_admin_user_name" class="text-danger"></span>
</div>
<div class="form-group">
<label>Enter Password</label>
<input type="password" name="admin_password" id="admin_password" class="form-control" />
<span id="error_admin_password" class="text-danger"></span>
</div>
<div class="form-group">
<input type="submit" name="admin_login" id="admin_login" class="btn btn-info" value="Login" />
</div>
</form>
</div>
</div>
</div>
<div class="col-md-4">
</div>
</div>
</div>
</body>
</html>
<script>
$(document).ready(function(){
$('#admin_login_form').on('submit', function(event){
event.preventDefault();
$.ajax({
url:"check_admin_login.php",
method:"POST",
data:$(this).serialize(),
dataType:"json",
beforeSend:function(){
$('#admin_login').val('Validate...');
$('#admin_login').attr('disabled', 'disabled');
},
success:function(data)
{
if(data.success)
{
location.href = "<?php echo $base_url; ?>admin";
}
if(data.error)
{
$('#admin_login').val('Login');
$('#admin_login').attr('disabled', false);
if(data.error_admin_user_name != '')
{
$('#error_admin_user_name').text(data.error_admin_user_name);
}
else
{
$('#error_admin_user_name').text('');
}
if(data.error_admin_password != '')
{
$('#error_admin_password').text(data.error_admin_password);
}
else
{
$('#error_admin_password').text('');
}
}
}
});
});
});
</script>
admin/header.php
<?php
//header.php
include('database_connection.php');
session_start();
if(!isset($_SESSION["admin_id"]))
{
header('location:login.php');
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<title>Student Attendance System in PHP using Ajax</title>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<!--<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css">
<link rel="stylesheet" href="https://cdn.datatables.net/1.10.19/css/dataTables.bootstrap4.min.css">
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.4.0/jquery.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.7/umd/popper.min.js"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.3.1/js/bootstrap.min.js"></script>
<script src="https://cdn.datatables.net/1.10.19/js/jquery.dataTables.min.js"></script>
<script src="https://cdn.datatables.net/1.10.19/js/dataTables.bootstrap4.min.js"></script>!-->
<link rel="stylesheet" href="../css/bootstrap.min.css">
<link rel="stylesheet" href="../css/dataTables.bootstrap4.min.css">
<script src="../js/jquery.min.js"></script>
<script src="../js/popper.min.js"></script>
<script src="../js/bootstrap.min.js"></script>
<script src="../js/jquery.dataTables.min.js"></script>
<script src="../js/dataTables.bootstrap4.min.js"></script>
</head>
<body>
<div class="jumbotron-small text-center" style="margin-bottom:0">
<h1>Student Attendance System</h1>
</div>
<nav class="navbar navbar-expand-sm bg-dark navbar-dark">
<a class="navbar-brand" href="index.php">Home</a>
<button class="navbar-toggler" type="button" data-toggle="collapse" data-target="#collapsibleNavbar">
<span class="navbar-toggler-icon"></span>
</button>
<div class="collapse navbar-collapse" id="collapsibleNavbar">
<ul class="navbar-nav">
<li class="nav-item">
<a class="nav-link" href="grade.php">Grade</a>
</li>
<li class="nav-item">
<a class="nav-link" href="teacher.php">Teacher</a>
</li>
<li class="nav-item">
<a class="nav-link" href="student.php">Student</a>
</li>
<li class="nav-item">
<a class="nav-link" href="attendance.php">Attendance</a>
</li>
<li class="nav-item">
<a class="nav-link" href="logout.php">Logout</a>
</li>
</ul>
</div>
</nav>
admin/index.php
<?php
//index.php
include('header.php');
?>
<div class="container" style="margin-top:30px">
<div class="card">
<div class="card-header">
<div class="row">
<div class="col-md-9">Overall Student Attendance Status</div>
<div class="col-md-3" align="right">
</div>
</div>
</div>
<div class="card-body">
<div class="table-responsive">
<table class="table table-striped table-bordered" id="student_table">
<thead>
<tr>
<th>Student Name</th>
<th>Roll Number</th>
<th>Grade</th>
<th>Teacher</th>
<th>Attendance Percentage</th>
<th>Report</th>
</tr>
</thead>
<tbody>
</tbody>
</table>
</div>
</div>
</div>
</div>
</body>
</html>
<script type="text/javascript" src="../js/bootstrap-datepicker.js"></script>
<link rel="stylesheet" href="../css/datepicker.css" />
<style>
.datepicker
{
z-index: 1600 !important; /* has to be larger than 1050 */
}
</style>
<div class="modal" id="formModal">
<div class="modal-dialog">
<div class="modal-content">
<!-- Modal Header -->
<div class="modal-header">
<h4 class="modal-title">Make Report</h4>
<button type="button" class="close" data-dismiss="modal">×</button>
</div>
<!-- Modal body -->
<div class="modal-body">
<div class="form-group">
<select name="report_action" id="report_action" class="form-control">
<option value="pdf_report">PDF Report</option>
<option value="chart_report">Chart Report</option>
</select>
</div>
<div class="form-group">
<div class="input-daterange">
<input type="text" name="from_date" id="from_date" class="form-control" placeholder="From Date" readonly />
<span id="error_from_date" class="text-danger"></span>
<br />
<input type="text" name="to_date" id="to_date" class="form-control" placeholder="To Date" readonly />
<span id="error_to_date" class="text-danger"></span>
</div>
</div>
</div>
<!-- Modal footer -->
<div class="modal-footer">
<input type="hidden" name="student_id" id="student_id" />
<button type="button" name="create_report" id="create_report" class="btn btn-success btn-sm">Create Report</button>
<button type="button" class="btn btn-danger btn-sm" data-dismiss="modal">Close</button>
</div>
</div>
</div>
</div>
<script>
$(document).ready(function(){
var dataTable = $('#student_table').DataTable({
"processing":true,
"serverSide":true,
"order":[],
"ajax":{
url:"attendance_action.php",
type:"POST",
data:{action:'index_fetch'}
}
});
$('.input-daterange').datepicker({
todayBtn:"linked",
format:'yyyy-mm-dd',
autoclose:true,
container: '#formModal modal-body'
});
$(document).on('click', '.report_button', function(){
var student_id = $(this).data('student_id');
$('#student_id').val(student_id);
$('#formModal').modal('show');
});
$('#create_report').click(function(){
var student_id = $('#student_id').val();
var from_date = $('#from_date').val();
var to_date = $('#to_date').val();
var error = 0;
var action = $('#report_action').val();
if(from_date == '')
{
$('#error_from_date').text('From Date is Required');
error++;
}
else
{
$('#error_from_date').text('');
}
if(to_date == '')
{
$('#error_to_date').text("To Date is Required");
error++;
}
else
{
$('#error_to_date').text('');
}
if(error == 0)
{
$('#from_date').val('');
$('#to_date').val('');
$('#formModal').modal('hide');
if(action == 'pdf_report')
{
window.open("report.php?action=student_report&student_id="+student_id+"&from_date="+from_date+"&to_date="+to_date);
}
if(action == 'chart_report')
{
location.href = "chart.php?action=student_chart&student_id="+student_id+"&from_date="+from_date+"&to_date="+to_date;
}
}
});
});
</script>
admin/logout.php
<?php
//logout.php
session_start();
session_destroy();
header('location:login.php');
?>
Grade Management
admin/grade.php
<?php
include('header.php');
?>
<div class="container" style="margin-top:30px">
<div class="card">
<div class="card-header">
<div class="row">
<div class="col-md-9">Grade List</div>
<div class="col-md-3" align="right">
<button type="button" id="add_button" class="btn btn-info btn-sm">Add</button>
</div>
</div>
</div>
<div class="card-body">
<div class="table-responsive">
<span id="message_operation"></span>
<table class="table table-striped table-bordered" id="grade_table">
<thead>
<tr>
<th>Grade Name</th>
<th>Edit</th>
<th>Delete</th>
</tr>
</thead>
<tbody>
</tbody>
</table>
</div>
</div>
</div>
</div>
</body>
</html>
<div class="modal" id="formModal">
<div class="modal-dialog">
<form method="post" id="grade_form">
<div class="modal-content">
<!-- Modal Header -->
<div class="modal-header">
<h4 class="modal-title" id="modal_title"></h4>
<button type="button" class="close" data-dismiss="modal">×</button>
</div>
<!-- Modal body -->
<div class="modal-body">
<div class="form-group">
<div class="row">
<label class="col-md-4 text-right">Grade Name <span class="text-danger">*</span></label>
<div class="col-md-8">
<input type="text" name="grade_name" id="grade_name" class="form-control" />
<span id="error_grade_name" class="text-danger"></span>
</div>
</div>
</div>
</div>
<!-- Modal footer -->
<div class="modal-footer">
<input type="hidden" name="grade_id" id="grade_id" />
<input type="hidden" name="action" id="action" value="Add" />
<input type="submit" name="button_action" id="button_action" class="btn btn-success btn-sm" value="Add" />
<button type="button" class="btn btn-danger btn-sm" data-dismiss="modal">Close</button>
</div>
</div>
</form>
</div>
</div>
<div class="modal" id="deleteModal">
<div class="modal-dialog">
<div class="modal-content">
<!-- Modal Header -->
<div class="modal-header">
<h4 class="modal-title">Delete Confirmation</h4>
<button type="button" class="close" data-dismiss="modal">×</button>
</div>
<!-- Modal body -->
<div class="modal-body">
<h3 align="center">Are you sure you want to remove this?</h3>
</div>
<!-- Modal footer -->
<div class="modal-footer">
<button type="button" name="ok_button" id="ok_button" class="btn btn-primary btn-sm">OK</button>
<button type="button" class="btn btn-danger btn-sm" data-dismiss="modal">Close</button>
</div>
</div>
</div>
</div>
<script>
$(document).ready(function(){
var dataTable = $('#grade_table').DataTable({
"processing":true,
"serverSide":true,
"order":[],
"ajax":{
url:"grade_action.php",
type:"POST",
data:{action:'fetch'}
},
"columnDefs":[
{
"targets":[0, 1, 2],
"orderable":false,
},
],
});
$('#add_button').click(function(){
$('#modal_title').text("Add Grade");
$('#button_action').val('Add');
$('#action').val('Add');
$('#formModal').modal('show');
clear_field();
});
function clear_field()
{
$('#grade_form')[0].reset();
$('#error_grade_name').text('');
}
$('#grade_form').on('submit', function(event){
event.preventDefault();
$.ajax({
url:"grade_action.php",
method:"POST",
data:$(this).serialize(),
dataType:"json",
beforeSend:function()
{
$('#button_action').attr('disabled', 'disabled');
$('#button_action').val('Validate...');
},
success:function(data){
$('#button_action').attr('disabled', false);
$('#button_action').val($('#action').val());
if(data.success)
{
$('#message_operation').html('<div class="alert alert-success">'+data.success+'</div>');
clear_field();
dataTable.ajax.reload();
$('#formModal').modal('hide');
}
if(data.error)
{
if(data.error_grade_name != '')
{
$('#error_grade_name').text(data.error_grade_name);
}
else
{
$('#error_grade_name').text('');
}
}
}
});
});
var grade_id = '';
$(document).on('click', '.edit_grade', function(){
grade_id = $(this).attr('id');
clear_field();
$.ajax({
url:"grade_action.php",
method:"POST",
data:{action:'edit_fetch', grade_id:grade_id},
dataType:"json",
success:function(data)
{
$('#grade_name').val(data.grade_name);
$('#grade_id').val(data.grade_id);
$('#modal_title').text("Edit Grade");
$('#button_action').val('Edit');
$('#action').val('Edit');
$('#formModal').modal('show');
}
});
});
$(document).on('click', '.delete_grade', function(){
grade_id = $(this).attr('id');
$('#deleteModal').modal('show');
});
$('#ok_button').click(function(){
$.ajax({
url:"grade_action.php",
method:"POST",
data:{grade_id:grade_id, action:'delete'},
success:function(data)
{
$('#message_operation').html('<div class="alert alert-success">'+data+'</div>');
$('#deleteModal').modal('hide');
dataTable.ajax.reload();
}
});
});
});
</script>
admin/grade_action.php
<?php
//grade_action.php
include('database_connection.php');
session_start();
$output = '';
if(isset($_POST["action"]))
{
if($_POST["action"] == 'fetch')
{
$query = "SELECT * FROM tbl_grade ";
if(isset($_POST["search"]["value"]))
{
$query .= 'WHERE grade_name LIKE "%'.$_POST["search"]["value"].'%" ';
}
if(isset($_POST["order"]))
{
$query .= 'ORDER BY '.$_POST['order']['0']['column'].' '.$_POST['order']['0']['dir'].' ';
}
else
{
$query .= 'ORDER BY grade_id DESC ';
}
if($_POST["length"] != -1)
{
$query .= 'LIMIT ' . $_POST['start'] . ', ' . $_POST['length'];
}
$statement = $connect->prepare($query);
$statement->execute();
$result = $statement->fetchAll();
$data = array();
$filtered_rows = $statement->rowCount();
foreach($result as $row)
{
$sub_array = array();
$sub_array[] = $row["grade_name"];
$sub_array[] = '<button type="button" name="edit_grade" class="btn btn-primary btn-sm edit_grade" id="'.$row["grade_id"].'">Edit</button>';
$sub_array[] = '<button type="button" name="delete_grade" class="btn btn-danger btn-sm delete_grade" id="'.$row["grade_id"].'">Delete</button>';
$data[] = $sub_array;
}
$output = array(
"draw" => intval($_POST["draw"]),
"recordsTotal" => $filtered_rows,
"recordsFiltered" => get_total_records($connect, 'tbl_grade'),
"data" => $data
);
echo json_encode($output);
}
if($_POST["action"] == 'Add' || $_POST["action"] == "Edit")
{
$grade_name = '';
$error_grade_name = '';
$error = 0;
if(empty($_POST["grade_name"]))
{
$error_grade_name = 'Grade Name is required';
$error++;
}
else
{
$grade_name = $_POST["grade_name"];
}
if($error > 0)
{
$output = array(
'error' => true,
'error_grade_name' => $error_grade_name
);
}
else
{
if($_POST["action"] == "Add")
{
$data = array(
':grade_name' => $grade_name
);
$query = "
INSERT INTO tbl_grade
(grade_name)
SELECT * FROM (SELECT :grade_name) as temp
WHERE NOT EXISTS (
SELECT grade_name FROM tbl_grade WHERE grade_name = :grade_name
) LIMIT 1
";
$statement = $connect->prepare($query);
if($statement->execute($data))
{
if($statement->rowCount() > 0)
{
$output = array(
'success' => 'Data Added Successfully',
);
}
else
{
$output = array(
'error' => true,
'error_grade_name' => 'Grade Name Already Exists'
);
}
}
}
if($_POST["action"] == "Edit")
{
$data = array(
':grade_name' => $grade_name,
':grade_id' => $_POST["grade_id"]
);
$query = "
UPDATE tbl_grade
SET grade_name = :grade_name
WHERE grade_id = :grade_id
";
$statement = $connect->prepare($query);
if($statement->execute($data))
{
$output = array(
'success' => 'Data Updated Successfully',
);
}
}
}
echo json_encode($output);
}
if($_POST["action"] == "edit_fetch")
{
$query = "SELECT * FROM tbl_grade WHERE grade_id = '".$_POST["grade_id"]."'";
$statement = $connect->prepare($query);
if($statement->execute())
{
$result = $statement->fetchAll();
foreach($result as $row)
{
$output['grade_name'] = $row["grade_name"];
$output['grade_id'] = $row['grade_id'];
}
echo json_encode($output);
}
}
if($_POST["action"] == "delete")
{
$query = "DELETE FROM tbl_grade WHERE grade_id = '".$_POST["grade_id"]."'";
$statement = $connect->prepare($query);
if($statement->execute())
{
echo 'Data Delete Successfully';
}
}
}
?>
Teacher Management
admin/teacher.php
<?php
include('header.php');
?>
<div class="container" style="margin-top:30px">
<div class="card">
<div class="card-header">
<div class="row">
<div class="col-md-9">Teacher List</div>
<div class="col-md-3" align="right">
<button type="button" id="add_button" class="btn btn-info btn-sm">Add</button>
</div>
</div>
</div>
<div class="card-body">
<div class="table-responsive">
<span id="message_operation"></span>
<table class="table table-striped table-bordered" id="teacher_table">
<thead>
<tr>
<th>Image</th>
<th>Teacher Name</th>
<th>Email Address</th>
<th>Grade</th>
<th>View</th>
<th>Edit</th>
<th>Delete</th>
</tr>
</thead>
<tbody>
</tbody>
</table>
</div>
</div>
</div>
</div>
</body>
</html>
<script type="text/javascript" src="https://www.eyecon.ro/bootstrap-datepicker/js/bootstrap-datepicker.js"></script>
<link rel="stylesheet" href="https://www.eyecon.ro/bootstrap-datepicker/css/datepicker.css" />
<style>
.datepicker {
z-index: 1600 !important; /* has to be larger than 1050 */
}
</style>
<div class="modal" id="formModal">
<div class="modal-dialog">
<form method="post" id="teacher_form" enctype="multipart/form-data">
<div class="modal-content">
<!-- Modal Header -->
<div class="modal-header">
<h4 class="modal-title" id="modal_title"></h4>
<button type="button" class="close" data-dismiss="modal">×</button>
</div>
<!-- Modal body -->
<div class="modal-body">
<div class="form-group">
<div class="row">
<label class="col-md-4 text-right">Teacher Name <span class="text-danger">*</span></label>
<div class="col-md-8">
<input type="text" name="teacher_name" id="teacher_name" class="form-control" />
<span id="error_teacher_name" class="text-danger"></span>
</div>
</div>
</div>
<div class="form-group">
<div class="row">
<label class="col-md-4 text-right">Address <span class="text-danger">*</span></label>
<div class="col-md-8">
<textarea name="teacher_address" id="teacher_address" class="form-control"></textarea>
<span id="error_teacher_address" class="text-danger"></span>
</div>
</div>
</div>
<div class="form-group">
<div class="row">
<label class="col-md-4 text-right">Email Address <span class="text-danger">*</span></label>
<div class="col-md-8">
<input type="text" name="teacher_emailid" id="teacher_emailid" class="form-control" />
<span id="error_teacher_emailid" class="text-danger"></span>
</div>
</div>
</div>
<div class="form-group">
<div class="row">
<label class="col-md-4 text-right">Password <span class="text-danger">*</span></label>
<div class="col-md-8">
<input type="password" name="teacher_password" id="teacher_password" class="form-control" />
<span id="error_teacher_password" class="text-danger"></span>
</div>
</div>
</div>
<div class="form-group">
<div class="row">
<label class="col-md-4 text-right">Qualification <span class="text-danger">*</span></label>
<div class="col-md-8">
<input type="text" name="teacher_qualification" id="teacher_qualification" class="form-control" />
<span id="error_teacher_qualification" class="text-danger"></span>
</div>
</div>
</div>
<div class="form-group">
<div class="row">
<label class="col-md-4 text-right">Grade <span class="text-danger">*</span></label>
<div class="col-md-8">
<select name="teacher_grade_id" id="teacher_grade_id" class="form-control">
<option value="">Select Grade</option>
<?php
echo load_grade_list($connect);
?>
</select>
<span id="error_teacher_grade_id" class="text-danger"></span>
</div>
</div>
</div>
<div class="form-group">
<div class="row">
<label class="col-md-4 text-right">Date of Joining <span class="text-danger">*</span></label>
<div class="col-md-8">
<input type="text" name="teacher_doj" id="teacher_doj" class="form-control" />
<span id="error_teacher_doj" class="text-danger"></span>
</div>
</div>
</div>
<div class="form-group">
<div class="row">
<label class="col-md-4 text-right">Image <span class="text-danger">*</span></label>
<div class="col-md-8">
<input type="file" name="teacher_image" id="teacher_image" />
<span class="text-muted">Only .jpg and .png allowed</span><br />
<span id="error_teacher_image" class="text-danger"></span>
</div>
</div>
</div>
</div>
<!-- Modal footer -->
<div class="modal-footer">
<input type="hidden" name="hidden_teacher_image" id="hidden_teacher_image" value="" />
<input type="hidden" name="teacher_id" id="teacher_id" />
<input type="hidden" name="action" id="action" value="Add" />
<input type="submit" name="button_action" id="button_action" class="btn btn-success btn-sm" value="Add" />
<button type="button" class="btn btn-danger btn-sm" data-dismiss="modal">Close</button>
</div>
</div>
</form>
</div>
</div>
<div class="modal" id="viewModal">
<div class="modal-dialog modal-lg">
<div class="modal-content">
<!-- Modal Header -->
<div class="modal-header">
<h4 class="modal-title">Teacher Details</h4>
<button type="button" class="close" data-dismiss="modal">×</button>
</div>
<!-- Modal body -->
<div class="modal-body" id="teacher_details">
</div>
<!-- Modal footer -->
<div class="modal-footer">
<button type="button" class="btn btn-danger btn-sm" data-dismiss="modal">Close</button>
</div>
</div>
</div>
</div>
<div class="modal" id="deleteModal">
<div class="modal-dialog">
<div class="modal-content">
<!-- Modal Header -->
<div class="modal-header">
<h4 class="modal-title">Delete Confirmation</h4>
<button type="button" class="close" data-dismiss="modal">×</button>
</div>
<!-- Modal body -->
<div class="modal-body">
<h3 align="center">Are you sure you want to remove this?</h3>
</div>
<!-- Modal footer -->
<div class="modal-footer">
<button type="button" name="ok_button" id="ok_button" class="btn btn-primary btn-sm">OK</button>
<button type="button" class="btn btn-danger btn-sm" data-dismiss="modal">Close</button>
</div>
</div>
</div>
</div>
<script>
$(document).ready(function(){
var dataTable = $('#teacher_table').DataTable({
"processing":true,
"serverSide":true,
"order":[],
"ajax":{
url:"teacher_action.php",
type:"POST",
data:{action:'fetch'}
},
"columnDefs":[
{
"targets":[0, 4, 5, 6],
"orderable":false,
},
],
});
$('#teacher_doj').datepicker({
format: "yyyy-mm-dd",
autoclose: true,
container: '#formModal modal-body'
});
function clear_field()
{
$('#teacher_form')[0].reset();
$('#error_teacher_name').text('');
$('#error_teacher_address').text('');
$('#error_teacher_emailid').text('');
$('#error_teacher_password').text('');
$('#error_teacher_qualification').text('');
$('#error_teacher_doj').text('');
$('#error_teacher_image').text('');
$('#error_teacher_grade_id').text('');
}
$('#add_button').click(function(){
$('#modal_title').text("Add Teacher");
$('#button_action').val('Add');
$('#action').val('Add');
$('#formModal').modal('show');
clear_field();
});
$('#teacher_form').on('submit', function(event){
event.preventDefault();
$.ajax({
url:"teacher_action.php",
method:"POST",
data:new FormData(this),
dataType:"json",
contentType:false,
processData:false,
beforeSend:function()
{
$('#button_action').val('Validate...');
$('#button_action').attr('disabled', 'disabled');
},
success:function(data){
$('#button_action').attr('disabled', false);
$('#button_action').val($('#action').val());
if(data.success)
{
$('#message_operation').html('<div class="alert alert-success">'+data.success+'</div>');
clear_field();
$('#formModal').modal('hide');
dataTable.ajax.reload();
}
if(data.error)
{
if(data.error_teacher_name != '')
{
$('#error_teacher_name').text(data.error_teacher_name);
}
else
{
$('#error_teacher_name').text('');
}
if(data.error_teacher_address != '')
{
$('#error_teacher_address').text(data.error_teacher_address);
}
else
{
$('#error_teacher_address').text('');
}
if(data.error_teacher_emailid != '')
{
$('#error_teacher_emailid').text(data.error_teacher_emailid);
}
else
{
$('#error_teacher_emailid').text('');
}
if(data.error_teacher_password != '')
{
$('#error_teacher_password').text(data.error_teacher_password);
}
else
{
$('#error_teacher_password').text('');
}
if(data.error_teacher_grade_id != '')
{
$('#error_teacher_grade_id').text(data.error_teacher_grade_id);
}
else
{
$('#error_teacher_grade_id').text('');
}
if(data.error_teacher_qualification != '')
{
$('#error_teacher_qualification').text(data.error_teacher_qualification);
}
else
{
$('#error_teacher_qualification').text('');
}
if(data.error_teacher_doj != '')
{
$('#error_teacher_doj').text(data.error_teacher_doj);
}
else
{
$('#error_teacher_doj').text('');
}
if(data.error_teacher_image != '')
{
$('#error_teacher_image').text(data.error_teacher_image);
}
else
{
$('#error_teacher_image').text('');
}
}
}
});
});
var teacher_id = '';
$(document).on('click', '.view_teacher', function(){
teacher_id = $(this).attr('id');
$.ajax({
url:"teacher_action.php",
method:"POST",
data:{action:'single_fetch', teacher_id:teacher_id},
success:function(data)
{
$('#viewModal').modal('show');
$('#teacher_details').html(data);
}
});
});
$(document).on('click', '.edit_teacher', function(){
teacher_id = $(this).attr('id');
clear_field();
$.ajax({
url:"teacher_action.php",
method:"POST",
data:{action:'edit_fetch', teacher_id:teacher_id},
dataType:"json",
success:function(data)
{
$('#teacher_name').val(data.teacher_name);
$('#teacher_address').val(data.teacher_address);
//$('#teacher_emailid').val(data.teacher_emailid);
$('#teacher_grade_id').val(data.teacher_grade_id);
$('#teacher_qualification').val(data.teacher_qualification);
$('#teacher_doj').val(data.teacher_doj);
$('#error_teacher_image').html('<img src="teacher_image/'+data.teacher_image+'" class="img-thumbnail" width="50" />');
$('#hidden_teacher_image').val(data.teacher_image);
$('#teacher_id').val(data.teacher_id);
$('#modal_title').text("Edit Teacher");
$('#button_action').val('Edit');
$('#action').val('Edit');
$('#formModal').modal('show');
}
});
});
$(document).on('click', '.delete_teacher', function(){
teacher_id = $(this).attr('id');
$('#deleteModal').modal('show');
});
$('#ok_button').click(function(){
$.ajax({
url:"teacher_action.php",
method:"POST",
data:{teacher_id:teacher_id, action:'delete'},
success:function(data)
{
$('#message_operation').html('<div class="alert alert-success">'+data+'</div>');
$('#deleteModal').modal('hide');
dataTable.ajax.reload();
}
});
});
});
</script>
admin/teacher_action.php
<?php
//teacher_action.php
include('database_connection.php');
session_start();
$output = '';
if(isset($_POST["action"]))
{
if($_POST["action"] == 'fetch')
{
$query = "
SELECT * FROM tbl_teacher
INNER JOIN tbl_grade
ON tbl_grade.grade_id = tbl_teacher.teacher_grade_id ";
if(isset($_POST["search"]["value"]))
{
$query .= 'WHERE tbl_teacher.teacher_name LIKE "%'.$_POST["search"]["value"].'%"
OR tbl_teacher.teacher_emailid LIKE "%'.$_POST["search"]["value"].'%"
OR tbl_grade.grade_name LIKE "%'.$_POST["search"]["value"].'%" ';
}
if(isset($_POST["order"]))
{
$query .= 'ORDER BY '.$_POST['order']['0']['column'].' '.$_POST['order']['0']['dir'].' ';
}
else
{
$query .= 'ORDER BY tbl_teacher.teacher_id DESC ';
}
if($_POST["length"] != -1)
{
$query .= 'LIMIT ' . $_POST['start'] . ', ' . $_POST['length'];
}
$statement = $connect->prepare($query);
$statement->execute();
$result = $statement->fetchAll();
$data = array();
$filtered_rows = $statement->rowCount();
foreach($result as $row)
{
$sub_array = array();
$sub_array[] = '<img src="teacher_image/'.$row["teacher_image"].'" class="img-thumbnail" width="75" />';
$sub_array[] = $row["teacher_name"];
$sub_array[] = $row["teacher_emailid"];
$sub_array[] = $row["grade_name"];
$sub_array[] = '<button type="button" name="view_teacher" class="btn btn-info btn-sm view_teacher" id="'.$row["teacher_id"].'">View</button>';
$sub_array[] = '<button type="button" name="edit_teacher" class="btn btn-primary btn-sm edit_teacher" id="'.$row["teacher_id"].'">Edit</button>';
$sub_array[] = '<button type="button" name="delete_teacher" class="btn btn-danger btn-sm delete_teacher" id="'.$row["teacher_id"].'">Delete</button>';
$data[] = $sub_array;
}
$output = array(
"draw" => intval($_POST["draw"]),
"recordsTotal" => $filtered_rows,
"recordsFiltered" => get_total_records($connect, 'tbl_teacher'),
"data" => $data
);
echo json_encode($output);
}
if($_POST["action"] == 'Add' || $_POST["action"] == "Edit")
{
$teacher_name = '';
$teacher_address = '';
$teacher_emailid = '';
$teacher_password = '';
$teacher_grade_id = '';
$teacher_qualification = '';
$teacher_doj = '';
$teacher_image = '';
$error_teacher_name = '';
$error_teacher_address = '';
$error_teacher_emailid = '';
$error_teacher_password = '';
$error_teacher_grade_id = '';
$error_teacher_qualification = '';
$error_teacher_doj = '';
$error_teacher_image = '';
$error = 0;
$teacher_image = $_POST["hidden_teacher_image"];
if($_FILES["teacher_image"]["name"] != '')
{
$file_name = $_FILES["teacher_image"]["name"];
$tmp_name = $_FILES["teacher_image"]['tmp_name'];
$extension_array = explode(".", $file_name);
$extension = strtolower($extension_array[1]);
$allowed_extension = array('jpg','png');
if(!in_array($extension, $allowed_extension))
{
$error_teacher_image = 'Invalid Image Format';
$error++;
}
else
{
$teacher_image = uniqid() . '.' . $extension;
$upload_path = 'teacher_image/' . $teacher_image;
move_uploaded_file($tmp_name, $upload_path);
}
}
else
{
if($teacher_image == '')
{
$error_teacher_image = $teacher_image;
$error++;
}
}
if(empty($_POST["teacher_name"]))
{
$error_teacher_name = 'Teacher Name is required';
$error++;
}
else
{
$teacher_name = $_POST["teacher_name"];
}
if(empty($_POST["teacher_address"]))
{
$error_teacher_address = 'Teacher Address is required';
$error++;
}
else
{
$teacher_address = $_POST["teacher_address"];
}
if($_POST["action"] == "Add")
{
if(empty($_POST["teacher_emailid"]))
{
$error_teacher_emailid = 'Email Address is required';
$error++;
}
else
{
if (!filter_var($_POST["teacher_emailid"], FILTER_VALIDATE_EMAIL))
{
$error_teacher_emailid = "Invalid email format";
$error++;
}
else
{
$teacher_emailid = $_POST["teacher_emailid"];
}
}
if(empty($_POST["teacher_password"]))
{
$error_teacher_password = 'Password is required';
$error++;
}
else
{
$teacher_password = $_POST["teacher_password"];
}
}
if(empty($_POST["teacher_grade_id"]))
{
$error_teacher_grade_id = 'Grade is required';
$error++;
}
else
{
$teacher_grade_id = $_POST["teacher_grade_id"];
}
if(empty($_POST["teacher_qualification"]))
{
$error_teacher_qualification = 'Qualification Field is required';
$error++;
}
else
{
$teacher_qualification = $_POST["teacher_qualification"];
}
if(empty($_POST["teacher_doj"]))
{
$error_teacher_doj = 'Date of Join Field is required';
$error++;
}
else
{
$teacher_doj = $_POST["teacher_doj"];
}
if($error > 0)
{
$output = array(
'error' => true,
'error_teacher_name' => $error_teacher_name,
'error_teacher_address' => $error_teacher_address,
'error_teacher_emailid' => $error_teacher_emailid,
'error_teacher_password' => $error_teacher_password,
'error_teacher_grade_id' => $error_teacher_grade_id,
'error_teacher_qualification' => $error_teacher_qualification,
'error_teacher_doj' => $error_teacher_doj,
'error_teacher_image' => $error_teacher_image
);
}
else
{
if($_POST["action"] == "Add")
{
$data = array(
':teacher_name' => $teacher_name,
':teacher_address' => $teacher_address,
':teacher_emailid' => $teacher_emailid,
':teacher_password' => password_hash($teacher_password, PASSWORD_DEFAULT),
':teacher_qualification' => $teacher_qualification,
':teacher_doj' => $teacher_doj,
':teacher_image' => $teacher_image,
':teacher_grade_id' => $teacher_grade_id
);
$query = "
INSERT INTO tbl_teacher
(teacher_name, teacher_address, teacher_emailid, teacher_password, teacher_qualification, teacher_doj, teacher_image, teacher_grade_id)
SELECT * FROM (SELECT :teacher_name, :teacher_address, :teacher_emailid, :teacher_password, :teacher_qualification, :teacher_doj, :teacher_image, :teacher_grade_id) as temp
WHERE NOT EXISTS (
SELECT teacher_emailid FROM tbl_teacher WHERE teacher_emailid = :teacher_emailid
) LIMIT 1
";
$statement = $connect->prepare($query);
if($statement->execute($data))
{
if($statement->rowCount() > 0)
{
$output = array(
'success' => 'Data Added Successfully',
);
}
else
{
$output = array(
'error' => true,
'error_teacher_emailid' => 'Email Already Exists'
);
}
}
}
if($_POST["action"] == "Edit")
{
$data = array(
':teacher_name' => $teacher_name,
':teacher_address' => $teacher_address,
':teacher_qualification' => $teacher_qualification,
':teacher_doj' => $teacher_doj,
':teacher_image' => $teacher_image,
':teacher_grade_id' => $teacher_grade_id,
':teacher_id' => $_POST["teacher_id"]
);
$query = "
UPDATE tbl_teacher
SET teacher_name = :teacher_name,
teacher_address = :teacher_address,
teacher_grade_id = :teacher_grade_id,
teacher_qualification = :teacher_qualification,
teacher_doj = :teacher_doj,
teacher_image = :teacher_image
WHERE teacher_id = :teacher_id
";
$statement = $connect->prepare($query);
if($statement->execute($data))
{
$output = array(
'success' => 'Data Edited Successfully',
);
}
}
}
echo json_encode($output);
}
if($_POST["action"] == 'single_fetch')
{
$query = "
SELECT * FROM tbl_teacher
INNER JOIN tbl_grade
ON tbl_grade.grade_id = tbl_teacher.teacher_grade_id
WHERE tbl_teacher.teacher_id = '".$_POST["teacher_id"]."'";
$statement = $connect->prepare($query);
if($statement->execute())
{
$result = $statement->fetchAll();
$output = '
<div class="row">
';
foreach($result as $row)
{
$output .= '
<div class="col-md-3">
<img src="teacher_image/'.$row["teacher_image"].'" class="img-thumbnail" />
</div>
<div class="col-md-9">
<table class="table">
<tr>
<th>Name</th>
<td>'.$row["teacher_name"].'</td>
</tr>
<tr>
<th>Address</th>
<td>'.$row["teacher_address"].'</td>
</tr>
<tr>
<th>Email Address</th>
<td>'.$row["teacher_emailid"].'</td>
</tr>
<tr>
<th>Qualification</th>
<td>'.$row["teacher_qualification"].'</td>
</tr>
<tr>
<th>Date of Joining</th>
<td>'.$row["teacher_doj"].'</td>
</tr>
<tr>
<th>Grade</th>
<td>'.$row["grade_name"].'</td>
</tr>
</table>
</div>
';
}
$output .= '</div>';
echo $output;
}
}
if($_POST["action"] == "edit_fetch")
{
$query = "SELECT * FROM tbl_teacher WHERE teacher_id = '".$_POST["teacher_id"]."'";
$statement = $connect->prepare($query);
if($statement->execute())
{
$result = $statement->fetchAll();
foreach($result as $row)
{
$output['teacher_name'] = $row["teacher_name"];
$output['teacher_address'] = $row['teacher_address'];
//$output['teacher_emailid'] = $row['teacher_emailid'];
$output['teacher_qualification'] = $row['teacher_qualification'];
$output['teacher_doj'] = $row['teacher_doj'];
$output['teacher_image'] = $row['teacher_image'];
$output['teacher_grade_id'] = $row['teacher_grade_id'];
$output['teacher_id'] = $row['teacher_id'];
}
echo json_encode($output);
}
}
if($_POST["action"] == "delete")
{
$query = "DELETE FROM tbl_teacher WHERE teacher_id = '".$_POST["teacher_id"]."'";
$statement = $connect->prepare($query);
if($statement->execute())
{
echo 'Data Delete Successfully';
}
}
}
?>
Student Management
admin/student.php
<?php
include('header.php');
?>
<div class="container" style="margin-top:30px">
<div class="card">
<div class="card-header">
<div class="row">
<div class="col-md-9">Student List</div>
<div class="col-md-3" align="right">
<button type="button" id="add_button" class="btn btn-info btn-sm">Add</button>
</div>
</div>
</div>
<div class="card-body">
<div class="table-responsive">
<span id="message_operation"></span>
<table class="table table-striped table-bordered" id="student_table">
<thead>
<tr>
<th>Student Name</th>
<th>Roll No.</th>
<th>Date of Birth</th>
<th>Grade</th>
<th>Edit</th>
<th>Delete</th>
</tr>
</thead>
<tbody>
</tbody>
</table>
</div>
</div>
</div>
</div>
</body>
</html>
<script type="text/javascript" src="https://www.eyecon.ro/bootstrap-datepicker/js/bootstrap-datepicker.js"></script>
<link rel="stylesheet" href="https://www.eyecon.ro/bootstrap-datepicker/css/datepicker.css" />
<style>
.datepicker {
z-index: 1600 !important; /* has to be larger than 1050 */
}
</style>
<div class="modal" id="formModal">
<div class="modal-dialog">
<form method="post" id="student_form">
<div class="modal-content">
<!-- Modal Header -->
<div class="modal-header">
<h4 class="modal-title" id="modal_title"></h4>
<button type="button" class="close" data-dismiss="modal">×</button>
</div>
<!-- Modal body -->
<div class="modal-body">
<div class="form-group">
<div class="row">
<label class="col-md-4 text-right">Student Name <span class="text-danger">*</span></label>
<div class="col-md-8">
<input type="text" name="student_name" id="student_name" class="form-control" />
<span id="error_student_name" class="text-danger"></span>
</div>
</div>
</div>
<div class="form-group">
<div class="row">
<label class="col-md-4 text-right">Roll No. <span class="text-danger">*</span></label>
<div class="col-md-8">
<input type="text" name="student_roll_number" id="student_roll_number" class="form-control" />
<span id="error_student_roll_number" class="text-danger"></span>
</div>
</div>
</div>
<div class="form-group">
<div class="row">
<label class="col-md-4 text-right">Date of Birth <span class="text-danger">*</span></label>
<div class="col-md-8">
<input type="text" name="student_dob" id="student_dob" class="form-control" />
<span id="error_student_dob" class="text-danger"></span>
</div>
</div>
</div>
<div class="form-group">
<div class="row">
<label class="col-md-4 text-right">Grade <span class="text-danger">*</span></label>
<div class="col-md-8">
<select name="student_grade_id" id="student_grade_id" class="form-control">
<option value="">Select Grade</option>
<?php
echo load_grade_list($connect);
?>
</select>
<span id="error_student_grade_id" class="text-danger"></span>
</div>
</div>
</div>
</div>
<!-- Modal footer -->
<div class="modal-footer">
<input type="hidden" name="student_id" id="student_id" />
<input type="hidden" name="action" id="action" value="Add" />
<input type="submit" name="button_action" id="button_action" class="btn btn-success btn-sm" value="Add" />
<button type="button" class="btn btn-danger btn-sm" data-dismiss="modal">Close</button>
</div>
</div>
</form>
</div>
</div>
<div class="modal" id="deleteModal">
<div class="modal-dialog">
<div class="modal-content">
<!-- Modal Header -->
<div class="modal-header">
<h4 class="modal-title">Delete Confirmation</h4>
<button type="button" class="close" data-dismiss="modal">×</button>
</div>
<!-- Modal body -->
<div class="modal-body">
<h3 align="center">Are you sure you want to remove this?</h3>
</div>
<!-- Modal footer -->
<div class="modal-footer">
<button type="button" name="ok_button" id="ok_button" class="btn btn-primary btn-sm">OK</button>
<button type="button" class="btn btn-danger btn-sm" data-dismiss="modal">Close</button>
</div>
</div>
</div>
</div>
<script>
$(document).ready(function(){
var dataTable = $('#student_table').DataTable({
"processing":true,
"serverSide":true,
"order":[],
"ajax":{
url:"student_action.php",
type:"POST",
data:{action:'fetch'}
},
"columnDefs":[
{
"targets":[4, 5],
"orderable":false,
},
],
});
$('#student_dob').datepicker({
format: "yyyy-mm-dd",
autoclose: true,
container: '#formModal modal-body'
});
function clear_field()
{
$('#student_form')[0].reset();
$('#error_student_name').text('');
$('#error_student_roll_number').text('');
$('#error_student_dob').text('');
$('#error_student_grade_id').text('');
}
$('#add_button').click(function(){
$('#modal_title').text("Add Student");
$('#button_action').val('Add');
$('#action').val('Add');
$('#formModal').modal('show');
clear_field();
});
$('#student_form').on('submit', function(event){
event.preventDefault();
$.ajax({
url:"student_action.php",
method:"POST",
data:$(this).serialize(),
dataType:"json",
beforeSend:function()
{
$('#button_action').attr('disabled', 'disabled');
$('#button_action').val('Validate...');
},
success:function(data){
$('#button_action').attr('disabled', false);
$('#button_action').val($('#action').val());
if(data.success)
{
$('#message_operation').html('<div class="alert alert-success">'+data.success+'</div>');
clear_field();
$('#formModal').modal('hide');
dataTable.ajax.reload();
}
if(data.error)
{
if(data.error_student_name != '')
{
$('#error_student_name').text(data.error_student_name);
}
else
{
$('#error_student_name').text('');
}
if(data.error_student_roll_number != '')
{
$('#error_student_roll_number').text(data.error_student_roll_number);
}
else
{
$('#error_student_roll_number').text('');
}
if(data.error_student_dob != '')
{
$('#error_student_dob').text(data.error_student_dob);
}
else
{
$('#error_student_dob').text('');
}
if(data.error_student_grade_id != '')
{
$('#error_student_grade_id').text(data.error_student_grade_id);
}
else
{
$('#error_student_grade_id').text('');
}
}
}
});
});
var student_id = '';
$(document).on('click', '.edit_student', function(){
student_id = $(this).attr('id');
clear_field();
$.ajax({
url:"student_action.php",
method:"POST",
data:{action:'edit_fetch', student_id:student_id},
dataType:"json",
success:function(data)
{
$('#student_name').val(data.student_name);
$('#student_roll_number').val(data.student_roll_number);
$('#student_dob').val(data.student_dob);
//$('#teacher_qualification').val(data.teacher_qualification);
//$('#teacher_doj').val(data.teacher_doj);
$('#student_grade_id').val(data.student_grade_id);
$('#student_id').val(data.student_id);
$('#modal_title').text("Edit Student");
$('#button_action').val('Edit');
$('#action').val('Edit');
$('#formModal').modal('show');
}
});
});
$(document).on('click', '.delete_student', function(){
student_id = $(this).attr('id');
$('#deleteModal').modal('show');
});
$('#ok_button').click(function(){
$.ajax({
url:"student_action.php",
method:"POST",
data:{student_id:student_id, action:'delete'},
success:function(data)
{
$('#message_operation').html('<div class="alert alert-success">'+data+'</div>');
$('#deleteModal').modal('hide');
dataTable.ajax.reload();
}
});
});
});
</script>
admin/student_action.php
<?php
//student_action.php
include('database_connection.php');
session_start();
$output = '';
if(isset($_POST["action"]))
{
if($_POST["action"] == 'fetch')
{
$query = "
SELECT * FROM tbl_student
INNER JOIN tbl_grade
ON tbl_grade.grade_id = tbl_student.student_grade_id ";
if(isset($_POST["search"]["value"]))
{
$query .= 'WHERE tbl_student.student_name LIKE "%'.$_POST["search"]["value"].'%"
OR tbl_student.student_roll_number LIKE "%'.$_POST["search"]["value"].'%"
OR tbl_student.student_dob LIKE "%'.$_POST["search"]["value"].'%"
OR tbl_grade.grade_name LIKE "%'.$_POST["search"]["value"].'%" ';
}
if(isset($_POST["order"]))
{
$query .= 'ORDER BY '.$_POST['order']['0']['column'].' '.$_POST['order']['0']['dir'].' ';
}
else
{
$query .= 'ORDER BY tbl_student.student_id DESC ';
}
if($_POST["length"] != -1)
{
$query .= 'LIMIT ' . $_POST['start'] . ', ' . $_POST['length'];
}
$statement = $connect->prepare($query);
$statement->execute();
$result = $statement->fetchAll();
$data = array();
$filtered_rows = $statement->rowCount();
foreach($result as $row)
{
$sub_array = array();
$sub_array[] = $row["student_name"];
$sub_array[] = $row["student_roll_number"];
$sub_array[] = $row["student_dob"];
$sub_array[] = $row["grade_name"];
$sub_array[] = '<button type="button" name="edit_student" class="btn btn-primary btn-sm edit_student" id="'.$row["student_id"].'">Edit</button>';
$sub_array[] = '<button type="button" name="delete_student" class="btn btn-danger btn-sm delete_student" id="'.$row["student_id"].'">Delete</button>';
$data[] = $sub_array;
}
$output = array(
"draw" => intval($_POST["draw"]),
"recordsTotal" => $filtered_rows,
"recordsFiltered" => get_total_records($connect, 'tbl_student'),
"data" => $data
);
echo json_encode($output);
}
if($_POST["action"] == 'Add' || $_POST["action"] == "Edit")
{
$student_name = '';
$student_roll_number = '';
$student_dob = '';
$student_grade_id = '';
$error_student_name = '';
$error_student_roll_number = '';
$error_student_dob = '';
$error_student_grade_id = '';
$error = 0;
if(empty($_POST["student_name"]))
{
$error_student_name = 'Student Name is required';
$error++;
}
else
{
$student_name = $_POST["student_name"];
}
if(empty($_POST["student_roll_number"]))
{
$error_student_roll_number = 'Student Roll Number is required';
$error++;
}
else
{
$student_roll_number = $_POST["student_roll_number"];
}
if(empty($_POST["student_dob"]))
{
$error_student_dob = 'Student Date of Birth is required';
$error++;
}
else
{
$student_dob = $_POST["student_dob"];
}
if(empty($_POST["student_grade_id"]))
{
$error_student_grade_id = 'Grade is required';
$error++;
}
else
{
$student_grade_id = $_POST["student_grade_id"];
}
if($error > 0)
{
$output = array(
'error' => true,
'error_student_name' => $error_student_name,
'error_student_roll_number' => $error_student_roll_number,
'error_student_dob' => $error_student_dob,
'error_student_grade_id' => $error_student_grade_id
);
}
else
{
if($_POST["action"] == "Add")
{
$data = array(
':student_name' => $student_name,
':student_roll_number' => $student_roll_number,
':student_dob' => $student_dob,
':student_grade_id' => $student_grade_id
);
$query = "
INSERT INTO tbl_student
(student_name, student_roll_number, student_dob, student_grade_id)
VALUES (:student_name, :student_roll_number, :student_dob, :student_grade_id)
";
$statement = $connect->prepare($query);
if($statement->execute($data))
{
$output = array(
'success' => 'Data Added Successfully',
);
}
}
if($_POST["action"] == "Edit")
{
$data = array(
':student_name' => $student_name,
':student_roll_number' => $student_roll_number,
':student_dob' => $student_dob,
':student_grade_id' => $student_grade_id,
':student_id' => $_POST["student_id"]
);
$query = "
UPDATE tbl_student
SET student_name = :student_name,
student_roll_number = :student_roll_number,
student_dob = :student_dob,
student_grade_id = :student_grade_id
WHERE student_id = :student_id
";
$statement = $connect->prepare($query);
if($statement->execute($data))
{
$output = array(
'success' => 'Data Edited Successfully',
);
}
}
}
echo json_encode($output);
}
if($_POST["action"] == "edit_fetch")
{
$query = "SELECT * FROM tbl_student WHERE student_id = '".$_POST["student_id"]."'";
$statement = $connect->prepare($query);
if($statement->execute())
{
$result = $statement->fetchAll();
foreach($result as $row)
{
$output['student_name'] = $row["student_name"];
$output['student_roll_number'] = $row['student_roll_number'];
$output['student_dob'] = $row['student_dob'];
$output['student_grade_id'] = $row['student_grade_id'];
$output['student_id'] = $row['student_id'];
}
echo json_encode($output);
}
}
if($_POST["action"] == "delete")
{
$query = "
DELETE FROM tbl_student
WHERE student_id = '".$_POST["student_id"]."'";
$statement = $connect->prepare($query);
if($statement->execute())
{
echo 'Data Delete Successfully';
}
}
}
?>
Teacher Login
login.php
<?php
//login.php
include('admin/database_connection.php');
session_start();
if(isset($_SESSION["teacher_id"]))
{
header('location:index.php');
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<title>Student Attendance System in PHP using Ajax</title>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css">
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.4.0/jquery.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.7/umd/popper.min.js"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.3.1/js/bootstrap.min.js"></script>
</head>
<body>
<div class="jumbotron text-center" style="margin-bottom:0">
<h1>Student Attendance System</h1>
</div>
<div class="container">
<div class="row">
<div class="col-md-4">
</div>
<div class="col-md-4" style="margin-top:20px;">
<div class="card">
<div class="card-header">Teacher Login</div>
<div class="card-body">
<form method="post" id="teacher_login_form">
<div class="form-group">
<label>Enter Email Address</label>
<input type="text" name="teacher_emailid" id="teacher_emailid" class="form-control" />
<span id="error_teacher_emailid" class="text-danger"></span>
</div>
<div class="form-group">
<label>Enter Password</label>
<input type="password" name="teacher_password" id="teacher_password" class="form-control" />
<span id="error_teacher_password" class="text-danger"></span>
</div>
<div class="form-group">
<input type="submit" name="teacher_login" id="teacher_login" class="btn btn-info" value="Login" />
</div>
</form>
</div>
</div>
</div>
<div class="col-md-4">
</div>
</div>
</div>
</body>
</html>
<script>
$(document).ready(function(){
$('#teacher_login_form').on('submit', function(event){
event.preventDefault();
$.ajax({
url:"check_teacher_login.php",
method:"POST",
data:$(this).serialize(),
dataType:"json",
beforeSend:function()
{
$('#teacher_login').val('Validate...');
$('#teacher_login').attr('disabled', 'disabled');
},
success:function(data)
{
if(data.success)
{
location.href = "index.php";
}
if(data.error)
{
$('#teacher_login').val('Login');
$('#teacher_login').attr('disabled', false);
if(data.error_teacher_emailid != '')
{
$('#error_teacher_emailid').text(data.error_teacher_emailid);
}
else
{
$('#error_teacher_emailid').text('');
}
if(data.error_teacher_password != '')
{
$('#error_teacher_password').text(data.error_teacher_password);
}
else
{
$('#error_teacher_password').text('');
}
}
}
})
});
});
</script>
check_teacher_login.php
<?php
//check_teacher_login.php
include('admin/database_connection.php');
session_start();
sleep(1);
$teacher_emailid = '';
$teacher_password = '';
$error_teacher_emailid = '';
$error_teacher_password = '';
$error = 0;
if(empty($_POST["teacher_emailid"]))
{
$error_teacher_emailid = 'Email Address is required';
$error++;
}
else
{
$teacher_emailid = $_POST["teacher_emailid"];
}
if(empty($_POST["teacher_password"]))
{
$error_teacher_password = 'Password is required';
$error++;
}
else
{
$teacher_password = $_POST["teacher_password"];
}
if($error == 0)
{
$query = "
SELECT * FROM tbl_teacher
WHERE teacher_emailid = '".$teacher_emailid."'
";
$statement = $connect->prepare($query);
if($statement->execute())
{
$total_row = $statement->rowCount();
if($total_row > 0)
{
$result = $statement->fetchAll();
foreach($result as $row)
{
if(password_verify($teacher_password, $row["teacher_password"]))
{
$_SESSION['teacher_id'] = $row['teacher_id'];
}
else
{
$error_teacher_password = "Wrong Password";
$error++;
}
}
}
else
{
$error_teacher_emailid = 'Wrong Email Address';
$error++;
}
}
}
if($error > 0)
{
$output = array(
'error' => true,
'error_teacher_emailid' => $error_teacher_emailid,
'error_teacher_password' => $error_teacher_password
);
}
else
{
$output = array(
'success' => true
);
}
echo json_encode($output);
?>
header.php
<?php
include('admin/database_connection.php');
session_start();
if(!isset($_SESSION["teacher_id"]))
{
header("location:login.php");
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<title>Student Attendance System in PHP using Ajax</title>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="stylesheet" href="css/bootstrap.min.css">
<link rel="stylesheet" href="css/dataTables.bootstrap4.min.css">
<script src="js/jquery.min.js"></script>
<script src="js/popper.min.js"></script>
<script src="js/bootstrap.min.js"></script>
<script src="js/jquery.dataTables.min.js"></script>
<script src="js/dataTables.bootstrap4.min.js"></script>
</head>
<body>
<div class="jumbotron-small text-center" style="margin-bottom:0">
<h1>Student Attendance System</h1>
</div>
<nav class="navbar navbar-expand-sm bg-dark navbar-dark">
<a class="navbar-brand" href="index.php">Home</a>
<button class="navbar-toggler" type="button" data-toggle="collapse" data-target="#collapsibleNavbar">
<span class="navbar-toggler-icon"></span>
</button>
<div class="collapse navbar-collapse" id="collapsibleNavbar">
<ul class="navbar-nav">
<li class="nav-item">
<a class="nav-link" href="profile.php">Profile</a>
</li>
<li class="nav-item">
<a class="nav-link" href="attendance.php">Attendance</a>
</li>
<li class="nav-item">
<a class="nav-link" href="logout.php">Logout</a>
</li>
</ul>
</div>
</nav>
index.php
<?php
include('header.php');
?>
<div class="container" style="margin-top:30px">
<div class="card">
<div class="card-header">
<div class="row">
<div class="col-md-9">Overall Student Attendance Status</div>
<div class="col-md-3" align="right">
</div>
</div>
</div>
<div class="card-body">
<div class="table-responsive">
<span id="message_operation"></span>
<table class="table table-striped table-bordered" id="student_table">
<thead>
<tr>
<th>Student Name</th>
<th>Roll Number</th>
<th>Grade</th>
<th>Attendance Percentage</th>
<th>Report</th>
</tr>
</thead>
<tbody>
</tbody>
</table>
</div>
</div>
</div>
</div>
</body>
</html>
<script type="text/javascript" src="js/bootstrap-datepicker.js"></script>
<link rel="stylesheet" href="css/datepicker.css" />
<style>
.datepicker
{
z-index: 1600 !important; /* has to be larger than 1050 */
}
</style>
<div class="modal" id="formModal">
<div class="modal-dialog">
<div class="modal-content">
<!-- Modal Header -->
<div class="modal-header">
<h4 class="modal-title">Make Report</h4>
<button type="button" class="close" data-dismiss="modal">×</button>
</div>
<!-- Modal body -->
<div class="modal-body">
<div class="form-group">
<div class="input-daterange">
<input type="text" name="from_date" id="from_date" class="form-control" placeholder="From Date" readonly />
<span id="error_from_date" class="text-danger"></span>
<br />
<input type="text" name="to_date" id="to_date" class="form-control" placeholder="To Date" readonly />
<span id="error_to_date" class="text-danger"></span>
</div>
</div>
</div>
<!-- Modal footer -->
<div class="modal-footer">
<input type="hidden" name="student_id" id="student_id" />
<button type="button" name="create_report" id="create_report" class="btn btn-success btn-sm">Create Report</button>
<button type="button" class="btn btn-danger btn-sm" data-dismiss="modal">Close</button>
</div>
</div>
</div>
</div>
<script>
$(document).ready(function(){
var dataTable = $('#student_table').DataTable({
"processing":true,
"serverSide":true,
"order":[],
"ajax":{
url:"attendance_action.php",
type:"POST",
data:{action:'index_fetch'}
}
});
$('.input-daterange').datepicker({
todayBtn: "linked",
format: "yyyy-mm-dd",
autoclose: true,
container: '#formModal modal-body'
});
$(document).on('click', '.report_button', function(){
var student_id = $(this).attr('id');
$('#student_id').val(student_id);
$('#formModal').modal('show');
});
$('#create_report').click(function(){
var student_id = $('#student_id').val();
var from_date = $('#from_date').val();
var to_date = $('#to_date').val();
var error = 0;
if(from_date == '')
{
$('#error_from_date').text('From Date is Required');
error++;
}
else
{
$('#error_from_date').text('');
}
if(to_date == '')
{
$('#error_to_date').text('To Date is Required');
error++;
}
else
{
$('#error_to_date').text('');
}
if(error == 0)
{
$('#from_date').val('');
$('#to_date').val('');
$('#formModal').modal('hide');
window.open("report.php?action=student_report&student_id="+student_id+"&from_date="+from_date+"&to_date="+to_date);
}
});
});
</script>
logout.php
<?php
//logout.php
session_start();
session_destroy();
header('location:login.php');
?>
Teacher Profile
profile.php
<?php
//profile.php
include('header.php');
$teacher_name = '';
$teacher_address = '';
$teacher_emailid = '';
$teacher_password = '';
$teacher_grade_id = '';
$teacher_qualification = '';
$teacher_doj = '';
$teacher_image = '';
$error_teacher_name = '';
$error_teacher_address = '';
$error_teacher_emailid = '';
$error_teacher_grade_id = '';
$error_teacher_qualification = '';
$error_teacher_doj = '';
$error_teacher_image = '';
$error = 0;
$success = '';
if(isset($_POST["button_action"]))
{
$teacher_image = $_POST["hidden_teacher_image"];
if($_FILES["teacher_image"]["name"] != '')
{
$file_name = $_FILES["teacher_image"]["name"];
$tmp_name = $_FILES["teacher_image"]['tmp_name'];
$extension_array = explode(".", $file_name);
$extension = strtolower($extension_array[1]);
$allowed_extension = array('jpg','png');
if(!in_array($extension, $allowed_extension))
{
$error_teacher_image = 'Invalid Image Format';
$error++;
}
else
{
$teacher_image = uniqid() . '.' . $extension;
$upload_path = 'admin/teacher_image/' . $teacher_image;
move_uploaded_file($tmp_name, $upload_path);
}
}
if(empty($_POST["teacher_name"]))
{
$error_teacher_name = 'Teacher Name is required';
$error++;
}
else
{
$teacher_name = $_POST["teacher_name"];
}
if(empty($_POST["teacher_address"]))
{
$error_teacher_address = 'Teacher Address is required';
$error++;
}
else
{
$teacher_address = $_POST["teacher_address"];
}
if(empty($_POST["teacher_emailid"]))
{
$error_teacher_emailid = 'Email Address is required';
$error++;
}
else
{
if (!filter_var($_POST["teacher_emailid"], FILTER_VALIDATE_EMAIL))
{
$error_teacher_emailid = "Invalid email format";
$error++;
}
else
{
$teacher_emailid = $_POST["teacher_emailid"];
}
}
if(!empty($_POST["teacher_password"]))
{
$teacher_password = $_POST["teacher_password"];
}
if(empty($_POST["teacher_grade_id"]))
{
$error_teacher_grade_id = 'Grade is required';
$error++;
}
else
{
$teacher_grade_id = $_POST["teacher_grade_id"];
}
if(empty($_POST["teacher_qualification"]))
{
$error_teacher_qualification = 'Qualification Field is required';
$error++;
}
else
{
$teacher_qualification = $_POST["teacher_qualification"];
}
if(empty($_POST["teacher_doj"]))
{
$error_teacher_doj = 'Date of Join Field is required';
$error++;
}
else
{
$teacher_doj = $_POST["teacher_doj"];
}
if($error == 0)
{
if($teacher_password != "")
{
$data = array(
':teacher_name' => $teacher_name,
':teacher_address' => $teacher_address,
':teacher_emailid' => $teacher_emailid,
':teacher_password' => password_hash($teacher_password, PASSWORD_DEFAULT),
':teacher_qualification' => $teacher_qualification,
':teacher_doj' => $teacher_doj,
':teacher_image' => $teacher_image,
':teacher_grade_id' => $teacher_grade_id,
':teacher_id' => $_POST["teacher_id"]
);
$query = "
UPDATE tbl_teacher
SET teacher_name = :teacher_name,
teacher_address = :teacher_address,
teacher_emailid = :teacher_emailid,
teacher_password = :teacher_password,
teacher_grade_id = :teacher_grade_id,
teacher_qualification = :teacher_qualification,
teacher_doj = :teacher_doj,
teacher_image = :teacher_image
WHERE teacher_id = :teacher_id
";
}
else
{
$data = array(
':teacher_name' => $teacher_name,
':teacher_address' => $teacher_address,
':teacher_emailid' => $teacher_emailid,
':teacher_qualification' => $teacher_qualification,
':teacher_doj' => $teacher_doj,
':teacher_image' => $teacher_image,
':teacher_grade_id' => $teacher_grade_id,
':teacher_id' => $_POST["teacher_id"]
);
$query = "
UPDATE tbl_teacher
SET teacher_name = :teacher_name,
teacher_address = :teacher_address,
teacher_emailid = :teacher_emailid,
teacher_grade_id = :teacher_grade_id,
teacher_qualification = :teacher_qualification,
teacher_doj = :teacher_doj,
teacher_image = :teacher_image
WHERE teacher_id = :teacher_id
";
}
$statement = $connect->prepare($query);
if($statement->execute($data))
{
$success = '<div class="alert alert-success">Profile Details Change Successfully</div>';
}
}
}
$query = "
SELECT * FROM tbl_teacher
WHERE teacher_id = '".$_SESSION["teacher_id"]."'
";
$statement = $connect->prepare($query);
$statement->execute();
$result = $statement->fetchAll();
?>
<div class="container" style="margin-top:30px">
<span id="message_operation"><?php echo $success; ?></span>
<div class="card">
<form method="post" id="profile_form" enctype="multipart/form-data">
<div class="card-header">
<div class="row">
<div class="col-md-9">Profile</div>
<div class="col-md-3" align="right">
</div>
</div>
</div>
<div class="card-body">
<div class="form-group">
<div class="row">
<label class="col-md-4 text-right">Teacher Name <span class="text-danger">*</span></label>
<div class="col-md-8">
<input type="text" name="teacher_name" id="teacher_name" class="form-control" />
<span class="text-danger"><?php echo $error_teacher_name; ?></span>
</div>
</div>
</div>
<div class="form-group">
<div class="row">
<label class="col-md-4 text-right">Address <span class="text-danger">*</span></label>
<div class="col-md-8">
<textarea name="teacher_address" id="teacher_address" class="form-control"></textarea>
<span class="text-danger"><?php echo $error_teacher_address; ?></span>
</div>
</div>
</div>
<div class="form-group">
<div class="row">
<label class="col-md-4 text-right">Email Address <span class="text-danger">*</span></label>
<div class="col-md-8">
<input type="text" name="teacher_emailid" id="teacher_emailid" class="form-control" />
<span class="text-danger"><?php echo $error_teacher_emailid; ?></span>
</div>
</div>
</div>
<div class="form-group">
<div class="row">
<label class="col-md-4 text-right">Password <span class="text-danger">*</span></label>
<div class="col-md-8">
<input type="password" name="teacher_password" id="teacher_password" class="form-control" placeholder="Leave blank to not change it" />
<span class="text-danger"></span>
</div>
</div>
</div>
<div class="form-group">
<div class="row">
<label class="col-md-4 text-right">Qualification <span class="text-danger">*</span></label>
<div class="col-md-8">
<input type="text" name="teacher_qualification" id="teacher_qualification" class="form-control" />
<span class="text-danger"><?php echo $error_teacher_qualification; ?></span>
</div>
</div>
</div>
<div class="form-group">
<div class="row">
<label class="col-md-4 text-right">Grade <span class="text-danger">*</span></label>
<div class="col-md-8">
<select name="teacher_grade_id" id="teacher_grade_id" class="form-control">
<option value="">Select Grade</option>
<?php
echo load_grade_list($connect);
?>
</select>
<span class="text-danger"><?php echo $error_teacher_grade_id; ?></span>
</div>
</div>
</div>
<div class="form-group">
<div class="row">
<label class="col-md-4 text-right">Date of Joining <span class="text-danger">*</span></label>
<div class="col-md-8">
<input type="text" name="teacher_doj" id="teacher_doj" class="form-control" readonly />
<span class="text-danger"><?php echo $error_teacher_doj; ?></span>
</div>
</div>
</div>
<div class="form-group">
<div class="row">
<label class="col-md-4 text-right">Image <span class="text-danger">*</span></label>
<div class="col-md-8">
<input type="file" name="teacher_image" id="teacher_image" />
<span class="text-muted">Only .jpg and .png allowed</span><br />
<span id="error_teacher_image" class="text-danger"><?php echo $error_teacher_image; ?></span>
</div>
</div>
</div>
</div>
<div class="card-footer" align="center">
<input type="hidden" name="hidden_teacher_image" id="hidden_teacher_image" value="" />
<input type="hidden" name="teacher_id" id="teacher_id" />
<input type="submit" name="button_action" id="button_action" class="btn btn-success btn-sm" value="Save" />
</div>
</form>
</div>
</div>
</body>
</html>
<script type="text/javascript" src="js/bootstrap-datepicker.js"></script>
<link rel="stylesheet" href="css/datepicker.css" />
<style>
.datepicker
{
z-index: 1600 !important; /* has to be larger than 1050 */
}
</style>
<script>
$(document).ready(function(){
<?php
foreach($result as $row)
{
?>
$('#teacher_name').val("<?php echo $row['teacher_name']; ?>");
$('#teacher_address').val("<?php echo $row['teacher_address']; ?>");
$('#teacher_emailid').val("<?php echo $row['teacher_emailid']; ?>");
$('#teacher_qualification').val("<?php echo $row['teacher_qualification']; ?>");
$('#teacher_grade_id').val("<?php echo $row['teacher_grade_id']; ?>");
$('#teacher_doj').val("<?php echo $row['teacher_doj']; ?>");
$('#error_teacher_image').html("<img src='admin/teacher_image/<?php echo $row['teacher_image']; ?>' class='img-thumbnail' width='100' />");
$('#hidden_teacher_image').val("<?php echo $row['teacher_image']; ?>");
$('#teacher_id').val("<?php echo $row['teacher_id']; ?>");
<?php
}
?>
$('#teacher_doj').datepicker({
format: "yyyy-mm-dd",
autoclose: true
});
});
</script>
Attendance Management
attendance.php
<?php
include('header.php');
?>
<div class="container" style="margin-top:30px">
<div class="card">
<div class="card-header">
<div class="row">
<div class="col-md-9">Attendance List</div>
<div class="col-md-3" align="right">
<button type="button" id="report_button" class="btn btn-danger btn-sm">Report</button>
<button type="button" id="add_button" class="btn btn-info btn-sm">Add</button>
</div>
</div>
</div>
<div class="card-body">
<div class="table-responsive">
<span id="message_operation"></span>
<table class="table table-striped table-bordered" id="attendance_table">
<thead>
<tr>
<th>Student Name</th>
<th>Roll Number</th>
<th>Grade</th>
<th>Attendance Status</th>
<th>Attendance Date</th>
</tr>
</thead>
<tbody>
</tbody>
</table>
</div>
</div>
</div>
</div>
</body>
</html>
<script type="text/javascript" src="js/bootstrap-datepicker.js"></script>
<link rel="stylesheet" href="css/datepicker.css" />
<style>
.datepicker
{
z-index: 1600 !important; /* has to be larger than 1050 */
}
</style>
<?php
$query = "
SELECT * FROM tbl_grade WHERE grade_id = (SELECT teacher_grade_id FROM tbl_teacher
WHERE teacher_id = '".$_SESSION["teacher_id"]."')
";
$statement = $connect->prepare($query);
$statement->execute();
$result = $statement->fetchAll();
?>
<div class="modal" id="formModal">
<div class="modal-dialog">
<form method="post" id="attendance_form">
<div class="modal-content">
<!-- Modal Header -->
<div class="modal-header">
<h4 class="modal-title" id="modal_title"></h4>
<button type="button" class="close" data-dismiss="modal">×</button>
</div>
<!-- Modal body -->
<div class="modal-body">
<?php
foreach($result as $row)
{
?>
<div class="form-group">
<div class="row">
<label class="col-md-4 text-right">Grade <span class="text-danger">*</span></label>
<div class="col-md-8">
<?php
echo '<label>'.$row["grade_name"].'</label>';
?>
</div>
</div>
</div>
<div class="form-group">
<div class="row">
<label class="col-md-4 text-right">Attendance Date <span class="text-danger">*</span></label>
<div class="col-md-8">
<input type="text" name="attendance_date" id="attendance_date" class="form-control" readonly />
<span id="error_attendance_date" class="text-danger"></span>
</div>
</div>
</div>
<div class="form-group" id="student_details">
<div class="table-responsive">
<table class="table table-striped table-bordered">
<thead>
<tr>
<th>Roll No.</th>
<th>Student Name</th>
<th>Present</th>
<th>Absent</th>
</tr>
</thead>
<?php
$sub_query = "
SELECT * FROM tbl_student
WHERE student_grade_id = '".$row["grade_id"]."'
";
$statement = $connect->prepare($sub_query);
$statement->execute();
$student_result = $statement->fetchAll();
foreach($student_result as $student)
{
?>
<tr>
<td><?php echo $student["student_roll_number"]; ?></td>
<td>
<?php echo $student["student_name"]; ?>
<input type="hidden" name="student_id[]" value="<?php echo $student["student_id"]; ?>" />
</td>
<td align="center">
<input type="radio" name="attendance_status<?php echo $student["student_id"]; ?>" value="Present" />
</td>
<td align="center">
<input type="radio" name="attendance_status<?php echo $student["student_id"]; ?>" checked value="Absent" />
</td>
</tr>
<?php
}
?>
</table>
</div>
</div>
<?php
}
?>
</div>
<!-- Modal footer -->
<div class="modal-footer">
<input type="hidden" name="attendance_id" id="attendance_id" />
<input type="hidden" name="action" id="action" value="Add" />
<input type="submit" name="button_action" id="button_action" class="btn btn-success btn-sm" value="Add" />
<button type="button" class="btn btn-danger btn-sm" data-dismiss="modal">Close</button>
</div>
</div>
</form>
</div>
</div>
<div class="modal" id="reportModal">
<div class="modal-dialog">
<div class="modal-content">
<!-- Modal Header -->
<div class="modal-header">
<h4 class="modal-title">Make Report</h4>
<button type="button" class="close" data-dismiss="modal">×</button>
</div>
<!-- Modal body -->
<div class="modal-body">
<div class="form-group">
<div class="input-daterange">
<input type="text" name="from_date" id="from_date" class="form-control" placeholder="From Date" readonly />
<span id="error_from_date" class="text-danger"></span>
<br />
<input type="text" name="to_date" id="to_date" class="form-control" placeholder="To Date" readonly />
<span id="error_to_date" class="text-danger"></span>
</div>
</div>
</div>
<!-- Modal footer -->
<div class="modal-footer">
<input type="hidden" name="student_id" id="student_id" />
<button type="button" name="create_report" id="create_report" class="btn btn-success btn-sm">Create Report</button>
<button type="button" class="btn btn-danger btn-sm" data-dismiss="modal">Close</button>
</div>
</div>
</div>
</div>
<script>
$(document).ready(function(){
var dataTable = $('#attendance_table').DataTable({
"processing":true,
"serverSide":true,
"order":[],
"ajax":{
url:"attendance_action.php",
type:"POST",
data:{action:'fetch'}
}
});
$('#attendance_date').datepicker({
format: "yyyy-mm-dd",
autoclose: true,
container: '#formModal modal-body'
});
function clear_field()
{
$('#attendance_form')[0].reset();
//$('#error_student_grade_id').text('');
$('#error_attendance_date').text('');
}
$('#add_button').click(function(){
$('#modal_title').text("Add Attendance");
//$('#button_action').val('Add');
//$('#action').val('Add');
$('#formModal').modal('show');
clear_field();
});
$('#attendance_form').on('submit', function(event){
event.preventDefault();
$.ajax({
url:"attendance_action.php",
method:"POST",
data:$(this).serialize(),
dataType:"json",
beforeSend:function()
{
$('#button_action').attr('disabled', 'disabled');
$('#button_action').val('Validate...');
},
success:function(data){
$('#button_action').attr('disabled', false);
$('#button_action').val($('#action').val());
if(data.success)
{
$('#message_operation').html('<div class="alert alert-success">'+data.success+'</div>');
clear_field();
$('#formModal').modal('hide');
dataTable.ajax.reload();
}
if(data.error)
{
if(data.error_attendance_date != '')
{
$('#error_attendance_date').text(data.error_attendance_date);
}
else
{
$('#error_attendance_date').text('');
}
}
}
});
});
$('.input-daterange').datepicker({
todayBtn: "linked",
format: "yyyy-mm-dd",
autoclose: true,
container: '#formModal modal-body'
});
$(document).on('click', '#report_button', function(){
$('#reportModal').modal('show');
});
$('#create_report').click(function(){
var from_date = $('#from_date').val();
var to_date = $('#to_date').val();
var error = 0;
if(from_date == '')
{
$('#error_from_date').text('From Date is Required');
error++;
}
else
{
$('#error_from_date').text('');
}
if(to_date == '')
{
$('#error_to_date').text('To Date is Required');
error++;
}
else
{
$('#error_to_date').text('');
}
if(error == 0)
{
$('#from_date').val('');
$('#to_date').val('');
$('#formModal').modal('hide');
window.open("report.php?action=attendance_report&from_date="+from_date+"&to_date="+to_date);
}
});
});
</script>
attendance_action.php
<?php
//attendance_action.php
include('admin/database_connection.php');
session_start();
$output = '';
if(isset($_POST["action"]))
{
if($_POST["action"] == 'fetch')
{
$query = "
SELECT * FROM tbl_attendance
INNER JOIN tbl_student
ON tbl_student.student_id = tbl_attendance.student_id
INNER JOIN tbl_grade
ON tbl_grade.grade_id = tbl_student.student_grade_id
WHERE tbl_attendance.teacher_id = '".$_SESSION["teacher_id"]."' AND (";
if(isset($_POST["search"]["value"]))
{
$query .= 'tbl_student.student_name LIKE "%'.$_POST["search"]["value"].'%"
OR tbl_student.student_roll_number LIKE "%'.$_POST["search"]["value"].'%"
OR tbl_attendance.attendance_status LIKE "%'.$_POST["search"]["value"].'%"
OR tbl_attendance.attendance_date LIKE "%'.$_POST["search"]["value"].'%") ';
}
if(isset($_POST["order"]))
{
$query .= 'ORDER BY '.$_POST['order']['0']['column'].' '.$_POST['order']['0']['dir'].' ';
}
else
{
$query .= 'ORDER BY tbl_attendance.attendance_id DESC ';
}
if($_POST["length"] != -1)
{
$query .= 'LIMIT ' . $_POST['start'] . ', ' . $_POST['length'];
}
$statement = $connect->prepare($query);
$statement->execute();
$result = $statement->fetchAll();
$data = array();
$filtered_rows = $statement->rowCount();
foreach($result as $row)
{
$sub_array = array();
$status = '';
if($row["attendance_status"] == 'Present')
{
$status = '<label class="badge badge-success">Present</label>';
}
if($row["attendance_status"] == 'Absent')
{
$status = '<label class="badge badge-danger">Absent</label>';
}
$sub_array[] = $row["student_name"];
$sub_array[] = $row["student_roll_number"];
$sub_array[] = $row["grade_name"];
$sub_array[] = $status;
$sub_array[] = $row["attendance_date"];
$data[] = $sub_array;
}
$output = array(
"draw" => intval($_POST["draw"]),
"recordsTotal" => $filtered_rows,
"recordsFiltered" => get_total_records($connect, 'tbl_attendance'),
"data" => $data
);
echo json_encode($output);
}
if($_POST["action"] == "Add")
{
$attendance_date = '';
$error_attendance_date = '';
$error = 0;
if(empty($_POST["attendance_date"]))
{
$error_attendance_date = 'Attendance Date is required';
$error++;
}
else
{
$attendance_date = $_POST["attendance_date"];
}
if($error > 0)
{
$output = array(
'error' => true,
'error_attendance_date' => $error_attendance_date
);
}
else
{
$student_id = $_POST["student_id"];
$query = '
SELECT attendance_date FROM tbl_attendance
WHERE teacher_id = "'.$_SESSION["teacher_id"].'"
AND attendance_date = "'.$attendance_date.'"
';
$statement = $connect->prepare($query);
$statement->execute();
if($statement->rowCount() > 0)
{
$output = array(
'error' => true,
'error_attendance_date' => 'Attendance Data Already Exists on this date'
);
}
else
{
for($count = 0; $count < count($student_id); $count++)
{
$data = array(
':student_id' => $student_id[$count],
':attendance_status' => $_POST["attendance_status".$student_id[$count].""],
':attendance_date' => $attendance_date,
':teacher_id' => $_SESSION["teacher_id"]
);
$query = "
INSERT INTO tbl_attendance
(student_id, attendance_status, attendance_date, teacher_id)
VALUES (:student_id, :attendance_status, :attendance_date, :teacher_id)
";
$statement = $connect->prepare($query);
$statement->execute($data);
}
$output = array(
'success' => 'Data Added Successfully',
);
}
}
echo json_encode($output);
}
if($_POST["action"] == "index_fetch")
{
$query = "
SELECT * FROM tbl_attendance
INNER JOIN tbl_student
ON tbl_student.student_id = tbl_attendance.student_id
INNER JOIN tbl_grade
ON tbl_grade.grade_id = tbl_student.student_grade_id
WHERE tbl_attendance.teacher_id = '".$_SESSION["teacher_id"]."' AND (";
if(isset($_POST["search"]["value"]))
{
$query .= 'tbl_student.student_name LIKE "%'.$_POST["search"]["value"].'%"
OR tbl_student.student_roll_number LIKE "%'.$_POST["search"]["value"].'%"
OR tbl_grade.grade_name LIKE "%'.$_POST["search"]["value"].'%" )';
}
$query .= 'GROUP BY tbl_student.student_id ';
if(isset($_POST["order"]))
{
$query .= 'ORDER BY '.$_POST['order']['0']['column'].' '.$_POST['order']['0']['dir'].' ';
}
else
{
$query .= 'ORDER BY tbl_student.student_roll_number ASC ';
}
if($_POST["length"] != -1)
{
$query .= 'LIMIT ' . $_POST['start'] . ', ' . $_POST['length'];
}
$statement = $connect->prepare($query);
$statement->execute();
$result = $statement->fetchAll();
$data = array();
$filtered_rows = $statement->rowCount();
foreach($result as $row)
{
$sub_array = array();
$sub_array[] = $row["student_name"];
$sub_array[] = $row["student_roll_number"];
$sub_array[] = $row["grade_name"];
$sub_array[] = get_attendance_percentage($connect, $row["student_id"]);
$sub_array[] = '<button type="button" name="report_button" id="'.$row["student_id"].'" class="btn btn-info btn-sm report_button">Report</button>';
$data[] = $sub_array;
}
$output = array(
"draw" => intval($_POST["draw"]),
"recordsTotal" => $filtered_rows,
"recordsFiltered" => get_total_records($connect, 'tbl_student'),
"data" => $data
);
echo json_encode($output);
}
}
?>
report.php
<?php
//report.php
if(isset($_GET["action"]))
{
include('admin/database_connection.php');
require_once 'admin/pdf.php';
session_start();
$output = '';
if($_GET["action"] == "student_report")
{
if(isset($_GET["student_id"], $_GET["from_date"], $_GET["to_date"]))
{
$pdf = new Pdf();
$query = "
SELECT * FROM tbl_student
INNER JOIN tbl_grade
ON tbl_grade.grade_id = tbl_student.student_grade_id
WHERE tbl_student.student_id = '".$_GET["student_id"]."'
";
$statement = $connect->prepare($query);
$statement->execute();
$result = $statement->fetchAll();
foreach($result as $row)
{
$output .= '
<style>
@page { margin: 20px; }
</style>
<p> </p>
<h3 align="center">Attendance Report</h3><br /><br />
<table width="100%" border="0" cellpadding="5" cellspacing="0">
<tr>
<td width="25%"><b>Student Name</b></td>
<td width="75%">'.$row["student_name"].'</td>
</tr>
<tr>
<td width="25%"><b>Roll Number</b></td>
<td width="75%">'.$row["student_roll_number"].'</td>
</tr>
<tr>
<td width="25%"><b>Grade</b></td>
<td width="75%">'.$row["grade_name"].'</td>
</tr>
<tr>
<td colspan="2" height="5">
<h3 align="center">Attendance Details</h3>
</td>
</tr>
<tr>
<td colspan="2">
<table width="100%" border="1" cellpadding="5" cellspacing="0">
<tr>
<td><b>Attendance Date</b></td>
<td><b>Attendance Status</b></td>
</tr>
';
$sub_query = "
SELECT * FROM tbl_attendance
WHERE student_id = '".$_GET["student_id"]."'
AND (attendance_date BETWEEN '".$_GET["from_date"]."' AND '".$_GET["to_date"]."')
ORDER BY attendance_date ASC
";
$statement = $connect->prepare($sub_query);
$statement->execute();
$sub_result = $statement->fetchAll();
foreach($sub_result as $sub_row)
{
$output .= '
<tr>
<td>'.$sub_row["attendance_date"].'</td>
<td>'.$sub_row["attendance_status"].'</td>
</tr>
';
}
$output .= '
</table>
</td>
</tr>
</table>
';
$file_name = 'Attendance Report.pdf';
$pdf->loadHtml($output);
$pdf->render();
$pdf->stream($file_name, array("Attachment" => false));
exit(0);
}
}
}
if($_GET["action"] == "attendance_report")
{
if(isset($_GET["from_date"], $_GET["to_date"]))
{
$pdf = new Pdf();
$query = "
SELECT attendance_date FROM tbl_attendance
WHERE teacher_id = '".$_SESSION["teacher_id"]."'
AND (attendance_date BETWEEN '".$_GET["from_date"]."' AND '".$_GET["to_date"]."')
GROUP BY attendance_date
ORDER BY attendance_date ASC
";
$statement = $connect->prepare($query);
$statement->execute();
$result = $statement->fetchAll();
$output .= '
<style>
@page { margin: 20px; }
</style>
<p> </p>
<h3 align="center">Attendance Report</h3><br />';
foreach($result as $row)
{
$output .= '
<table width="100%" border="0" cellpadding="5" cellspacing="0">
<tr>
<td><b>Date - '.$row["attendance_date"].'</b></td>
</tr>
<tr>
<td>
<table width="100%" border="1" cellpadding="5" cellspacing="0">
<tr>
<td><b>Student Name</b></td>
<td><b>Roll Number</b></td>
<td><b>Grade</b></td>
<td><b>Attendance Status</b></td>
</tr>
';
$sub_query = "
SELECT * FROM tbl_attendance
INNER JOIN tbl_student
ON tbl_student.student_id = tbl_attendance.student_id
INNER JOIN tbl_grade
ON tbl_grade.grade_id = tbl_student.student_grade_id
WHERE teacher_id = '".$_SESSION["teacher_id"]."'
AND attendance_date = '".$row["attendance_date"]."'
";
$statement = $connect->prepare($sub_query);
$statement->execute();
$sub_result = $statement->fetchAll();
foreach($sub_result as $sub_row)
{
$output .= '
<tr>
<td>'.$sub_row["student_name"].'</td>
<td>'.$sub_row["student_roll_number"].'</td>
<td>'.$sub_row["grade_name"].'</td>
<td>'.$sub_row["attendance_status"].'</td>
</tr>
';
}
$output .=
'</table>
</td>
</tr>
</table><br />';
}
$file_name = 'Attendance Report.pdf';
$pdf->loadHtml($output);
$pdf->render();
$pdf->stream($file_name, array("Attachment" => false));
exit(0);
}
}
}
?>
Admin Side - Attendance Management
admin/attendance.php
<?php
//attendance.php
include('header.php');
?>
<div class="container" style="margin-top:30px">
<div class="card">
<div class="card-header">
<div class="row">
<div class="col-md-9">Attendance List</div>
<div class="col-md-3" align="right">
<button type="button" id="chart_button" class="btn btn-primary btn-sm">Chart</button>
<button type="button" id="report_button" class="btn btn-danger btn-sm">Report</button>
</div>
</div>
</div>
<div class="card-body">
<div class="table-responsive">
<table class="table table-striped table-bordered" id="attendance_table">
<thead>
<tr>
<th>Student Name</th>
<th>Roll Number</th>
<th>Grade</th>
<th>Attendance Status</th>
<th>Attendance Date</th>
<th>Teacher</th>
</tr>
</thead>
<tbody>
</tbody>
</table>
</div>
</div>
</div>
</div>
</body>
</html>
<script type="text/javascript" src="../js/bootstrap-datepicker.js"></script>
<link rel="stylesheet" href="../css/datepicker.css" />
<style>
.datepicker
{
z-index: 1600 !important; /* has to be larger than 1050 */
}
</style>
<div class="modal" id="reportModal">
<div class="modal-dialog">
<div class="modal-content">
<!-- Modal Header -->
<div class="modal-header">
<h4 class="modal-title">Make Report</h4>
<button type="button" class="close" data-dismiss="modal">×</button>
</div>
<!-- Modal body -->
<div class="modal-body">
<div class="form-group">
<select name="grade_id" id="grade_id" class="form-control">
<option value="">Select Grade</option>
<?php
echo load_grade_list($connect);
?>
</select>
<span id="error_grade_id" class="text-danger"></span>
</div>
<div class="form-group">
<div class="input-daterange">
<input type="text" name="from_date" id="from_date" class="form-control" placeholder="From Date" readonly />
<span id="error_from_date" class="text-danger"></span>
<br />
<input type="text" name="to_date" id="to_date" class="form-control" placeholder="To Date" readonly />
<span id="error_to_date" class="text-danger"></span>
</div>
</div>
</div>
<!-- Modal footer -->
<div class="modal-footer">
<button type="button" name="create_report" id="create_report" class="btn btn-success btn-sm">Create Report</button>
<button type="button" class="btn btn-danger btn-sm" data-dismiss="modal">Close</button>
</div>
</div>
</div>
</div>
<div class="modal" id="chartModal">
<div class="modal-dialog">
<div class="modal-content">
<!-- Modal Header -->
<div class="modal-header">
<h4 class="modal-title">Create Grade Attandance Chart</h4>
<button type="button" class="close" data-dismiss="modal">×</button>
</div>
<!-- Modal body -->
<div class="modal-body">
<div class="form-group">
<select name="chart_grade_id" id="chart_grade_id" class="form-control">
<option value="">Select Grade</option>
<?php
echo load_grade_list($connect);
?>
</select>
<span id="error_chart_grade_id" class="text-danger"></span>
</div>
<div class="form-group">
<div class="input-daterange">
<input type="text" name="attendance_date" id="attendance_date" class="form-control" placeholder="Select Date" readonly />
<span id="error_attendance_date" class="text-danger"></span>
</div>
</div>
</div>
<!-- Modal footer -->
<div class="modal-footer">
<button type="button" name="create_chart" id="create_chart" class="btn btn-success btn-sm">Create Chart</button>
<button type="button" class="btn btn-danger btn-sm" data-dismiss="modal">Close</button>
</div>
</div>
</div>
</div>
<script>
$(document).ready(function(){
var dataTable = $('#attendance_table').DataTable({
"processing":true,
"serverSide":true,
"order":[],
"ajax":{
url:"attendance_action.php",
type:"POST",
data:{action:'fetch'}
}
});
$('.input-daterange').datepicker({
todayBtn: "linked",
format: "yyyy-mm-dd",
autoclose: true,
container: '#formModal modal-body'
});
$(document).on('click', '#report_button', function(){
$('#reportModal').modal('show');
});
$('#create_report').click(function(){
var grade_id = $('#grade_id').val();
var from_date = $('#from_date').val();
var to_date = $('#to_date').val();
var error = 0;
if(grade_id == '')
{
$('#error_grade_id').text('Grade is Required');
error++;
}
else
{
$('#error_grade_id').text('');
}
if(from_date == '')
{
$('#error_from_date').text('From Date is Required');
error++;
}
else
{
$('#error_from_date').text('');
}
if(to_date == '')
{
$('#error_to_date').text("To Date is Required");
error++;
}
else
{
$('#error_to_date').text('');
}
if(error == 0)
{
$('#from_date').val('');
$('#to_date').val('');
$('#formModal').modal('hide');
window.open("report.php?action=attendance_report&grade_id="+grade_id+"&from_date="+from_date+"&to_date="+to_date);
}
});
$('#chart_button').click(function(){
$('#chart_grade_id').val('');
$('#attendance_date').val('');
$('#chartModal').modal('show');
});
$('#create_chart').click(function(){
var grade_id = $('#chart_grade_id').val();
var attendance_date = $('#attendance_date').val();
var error = 0;
if(grade_id == '')
{
$('#error_chart_grade_id').text('Grade is Required');
error++;
}
else
{
$('#error_chart_grade_id').text('');
}
if(attendance_date == '')
{
$('#error_attendance_date').text('Date is Required');
$error++;
}
else
{
$('#error_attendance_date').text('');
}
if(error == 0)
{
$('#attendance_date').val('');
$('#chart_grade_id').val('');
$('#chartModal').modal('show');
window.open("chart1.php?action=attendance_report&grade_id="+grade_id+"&date="+attendance_date);
}
});
});
</script>
admin/attendance_action.php
<?php
//student_action.php
include('database_connection.php');
session_start();
if(isset($_POST["action"]))
{
if($_POST["action"] == "fetch")
{
$query = "
SELECT * FROM tbl_attendance
INNER JOIN tbl_student
ON tbl_student.student_id = tbl_attendance.student_id
INNER JOIN tbl_grade
ON tbl_grade.grade_id = tbl_student.student_grade_id
INNER JOIN tbl_teacher
ON tbl_teacher.teacher_id = tbl_attendance.teacher_id
";
if(isset($_POST["search"]["value"]))
{
$query .= '
WHERE tbl_student.student_name LIKE "%'.$_POST["search"]["value"].'%"
OR tbl_student.student_roll_number LIKE "%'.$_POST["search"]["value"].'%"
OR tbl_attendance.attendance_status LIKE "%'.$_POST["search"]["value"].'%"
OR tbl_attendance.attendance_date LIKE "%'.$_POST["search"]["value"].'%"
OR tbl_teacher.teacher_name LIKE "%'.$_POST["search"]["value"].'%"
';
}
if(isset($_POST["order"]))
{
$query .= '
ORDER BY '.$_POST['order']['0']['column'].' '.$_POST['order']['0']['dir'].'
';
}
else
{
$query .= '
ORDER BY tbl_attendance.attendance_id DESC
';
}
if($_POST["length"] != -1)
{
$query .= 'LIMIT ' . $_POST['start'] . ', ' . $_POST['length'];
}
$statement = $connect->prepare($query);
$statement->execute();
$result = $statement->fetchAll();
$data = array();
$filtered_rows = $statement->rowCount();
foreach($result as $row)
{
$sub_array = array();
$status = '';
if($row["attendance_status"] == "Present")
{
$status = '<label class="badge badge-success">Present</label>';
}
if($row["attendance_status"] == "Absent")
{
$status = '<label class="badge badge-danger">Absent</label>';
}
$sub_array[] = $row["student_name"];
$sub_array[] = $row["student_roll_number"];
$sub_array[] = $row["grade_name"];
$sub_array[] = $status;
$sub_array[] = $row["attendance_date"];
$sub_array[] = $row["teacher_name"];
$data[] = $sub_array;
}
$output = array(
"draw" => intval($_POST["draw"]),
"recordsTotal" => $filtered_rows,
"recordsFiltered" => get_total_records($connect, 'tbl_attendance'),
"data" => $data
);
echo json_encode($output);
}
if($_POST["action"] == "index_fetch")
{
$query = "
SELECT * FROM tbl_student
LEFT JOIN tbl_attendance
ON tbl_attendance.student_id = tbl_student.student_id
INNER JOIN tbl_grade
ON tbl_grade.grade_id = tbl_student.student_grade_id
INNER JOIN tbl_teacher
ON tbl_teacher.teacher_grade_id = tbl_grade.grade_id
";
if(isset($_POST["search"]["value"]))
{
$query .= '
WHERE tbl_student.student_name LIKE "%'.$_POST["search"]["value"].'%"
OR tbl_student.student_roll_number LIKE "%'.$_POST["search"]["value"].'%"
OR tbl_grade.grade_name LIKE "%'.$_POST["search"]["value"].'%"
OR tbl_teacher.teacher_name LIKE "%'.$_POST["search"]["value"].'%"
';
}
$query .= 'GROUP BY tbl_student.student_id ';
if(isset($_POST["order"]))
{
$query .= 'ORDER BY '.$_POST['order']['0']['column'].' '.$_POST['order']['0']['dir'].' ';
}
else
{
$query .= 'ORDER BY tbl_student.student_name ASC ';
}
if($_POST["length"] != -1)
{
$query .= 'LIMIT ' . $_POST['start'] . ', ' . $_POST['length'];
}
$statement = $connect->prepare($query);
$statement->execute();
$result = $statement->fetchAll();
$data = array();
$filtered_rows = $statement->rowCount();
foreach($result as $row)
{
$sub_array = array();
$sub_array[] = $row["student_name"];
$sub_array[] = $row["student_roll_number"];
$sub_array[] = $row["grade_name"];
$sub_array[] = $row["teacher_name"];
$sub_array[] = get_attendance_percentage($connect, $row["student_id"]);
$sub_array[] = '<button type="button" name="report_button" data-student_id="'.$row["student_id"].'" class="btn btn-info btn-sm report_button">Report</button> <button type="button" name="chart_button" data-student_id="'.$row["student_id"].'" class="btn btn-danger btn-sm report_button">Chart</button>
';
$data[] = $sub_array;
}
$output = array(
'draw' => intval($_POST["draw"]),
"recordsTotal" => $filtered_rows,
"recordsFiltered" => get_total_records($connect, 'tbl_student'),
"data" => $data
);
echo json_encode($output);
}
}
?>
admin/chart.php
<?php
//chart.php
include('header.php');
$present_percentage = 0;
$absent_percentage = 0;
$total_present = 0;
$total_absent = 0;
$output = "";
$query = "
SELECT * FROM tbl_attendance
WHERE student_id = '".$_GET['student_id']."'
AND attendance_date >= '".$_GET["from_date"]."'
AND attendance_date <= '".$_GET["to_date"]."'
";
$statement = $connect->prepare($query);
$statement->execute();
$result = $statement->fetchAll();
$total_row = $statement->rowCount();
foreach($result as $row)
{
$status = '';
if($row["attendance_status"] == "Present")
{
$total_present++;
$status = '<span class="badge badge-success">Present</span>';
}
if($row["attendance_status"] == "Absent")
{
$total_absent++;
$status = '<span class="badge badge-danger">Absent</span>';
}
$output .= '
<tr>
<td>'.$row["attendance_date"].'</td>
<td>'.$status.'</td>
</tr>
';
$present_percentage = ($total_present/$total_row) * 100;
$absent_percentage = ($total_absent/$total_row) * 100;
}
?>
<div class="container" style="margin-top:30px">
<div class="card">
<div class="card-header"><b>Attendance Chart</b></div>
<div class="card-body">
<div class="table-responsive">
<table class="table table-bordered table-striped">
<tr>
<th>Student Name</th>
<td><?php echo Get_student_name($connect, $_GET["student_id"]); ?></td>
</tr>
<tr>
<th>Grade</th>
<td><?php echo Get_student_grade_name($connect, $_GET["student_id"]); ?></td>
</tr>
<tr>
<th>Teacher Name</th>
<td><?php echo Get_student_teacher_name($connect, $_GET["student_id"]); ?></td>
</tr>
<tr>
<th>Time Period</th>
<td><?php echo $_GET["from_date"] . ' to '. $_GET["to_date"]; ?></td>
</tr>
</table>
<div id="attendance_pie_chart" style="width: 100%; height: 400px;">
</div>
<div class="table-responsive">
<table class="table table-striped table-bordered">
<tr>
<th>Date</th>
<th>Attendance Status</th>
</tr>
<?php echo $output; ?>
</table>
</div>
</div>
</div>
</div>
</div>
</body>
</html>
<script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script>
<script type="text/javascript">
google.charts.load('current', {'packages':['corechart']});
google.charts.setOnLoadCallback(drawChart);
function drawChart()
{
var data = google.visualization.arrayToDataTable([
['Attendance Status', 'Percentage'],
['Present', <?php echo $present_percentage; ?>],
['Absent', <?php echo $absent_percentage; ?>]
]);
var options = {
title : 'Overall Attendance Analytics',
hAxis : {
title: 'Percentage',
minValue: 0,
maxValue: 100
},
vAxis : {
title: 'Attendance Status'
}
};
var chart = new google.visualization.PieChart(document.getElementById('attendance_pie_chart'));
chart.draw(data, options);
}
</script>
admin/chart1.php
<?php
//chart1.php
include('header.php');
$present_percentage = 0;
$absent_percentage = 0;
$total_present = 0;
$total_absent = 0;
$output = "";
$query = "
SELECT * FROM tbl_attendance
INNER JOIN tbl_student
ON tbl_student.student_id = tbl_attendance.student_id
INNER JOIN tbl_grade
ON tbl_grade.grade_id = tbl_student.student_grade_id
WHERE tbl_student.student_grade_id = '".$_GET['grade_id']."'
AND tbl_attendance.attendance_date = '".$_GET["date"]."'
";
//echo $query;
$statement = $connect->prepare($query);
$statement->execute();
$result = $statement->fetchAll();
$total_row = $statement->rowCount();
foreach($result as $row)
{
$status = '';
if($row["attendance_status"] == "Present")
{
$total_present++;
$status = '<span class="badge badge-success">Present</span>';
}
if($row["attendance_status"] == "Absent")
{
$total_absent++;
$status = '<span class="badge badge-danger">Absent</span>';
}
$output .= '
<tr>
<td>'.$row["student_name"].'</td>
<td>'.$status.'</td>
</tr>
';
}
if($total_row > 0)
{
$present_percentage = ($total_present / $total_row) * 100;
$absent_percentage = ($total_absent / $total_row) * 100;
}
?>
<div class="container" style="margin-top:30px">
<div class="card">
<div class="card-header"><b>Attendance Chart</b></div>
<div class="card-body">
<div class="table-responsive">
<table class="table table-bordered table-striped">
<tr>
<th>Grade Name</th>
<td><?php echo Get_grade_name($connect, $_GET["grade_id"]); ?></td>
</tr>
<tr>
<th>Date</th>
<td><?php echo $_GET["date"]; ?></td>
</tr>
</table>
</div>
<div id="attendance_pie_chart" style="width: 100%; height: 400px;">
</div>
<div class="table-responsive">
<table class="table table-striped table-bordered">
<tr>
<th>Student Name</th>
<th>Attendance Status</th>
</tr>
<?php
echo $output;
?>
</table></div>
</div>
</div>
</div>
</body>
</html>
<script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script>
<script type="text/javascript">
google.charts.load('current', {'packages':['corechart']});
google.charts.setOnLoadCallback(drawChart);
function drawChart()
{
var data = google.visualization.arrayToDataTable([
['Attendance Status', 'Percentage'],
['Present', <?php echo $present_percentage; ?>],
['Absent', <?php echo $absent_percentage; ?>]
]);
var options = {
title: 'Overall Attendance Analytics',
hAxis: {
title: 'Percentage',
minValue: 0,
maxValue: 100
},
vAxis: {
title: 'Attendance Status'
}
};
var chart = new google.visualization.PieChart(document.getElementById('attendance_pie_chart'));
chart.draw(data, options);
}
</script>
admin/report.php
<?php
//report.php
if(isset($_GET["action"]))
{
include('database_connection.php');
require_once 'pdf.php';
session_start();
$output = '';
if($_GET["action"] == "student_report")
{
if(isset($_GET["student_id"], $_GET["from_date"], $_GET["to_date"]))
{
$pdf = new Pdf();
$query = "
SELECT * FROM tbl_student
INNER JOIN tbl_grade
ON tbl_grade.grade_id = tbl_student.student_grade_id
WHERE tbl_student.student_id = '".$_GET["student_id"]."'
";
$statement = $connect->prepare($query);
$statement->execute();
$result = $statement->fetchAll();
foreach($result as $row)
{
$output .= '
<style>
@page { margin: 20px; }
</style>
<p> </p>
<h3 align="center">Attendance Report</h3><br /><br />
<table width="100%" border="0" cellpadding="5" cellspacing="0">
<tr>
<td width="25%"><b>Student Name</b></td>
<td width="75%">'.$row["student_name"].'</td>
</tr>
<tr>
<td width="25%"><b>Roll Number</b></td>
<td width="75%">'.$row["student_roll_number"].'</td>
</tr>
<tr>
<td width="25%"><b>Grade</b></td>
<td width="75%">'.$row["grade_name"].'</td>
</tr>
<tr>
<td colspan="2" height="5">
<h3 align="center">Attendance Details</h3>
</td>
</tr>
<tr>
<td colspan="2">
<table width="100%" border="1" cellpadding="5" cellspacing="0">
<tr>
<td><b>Attendance Date</b></td>
<td><b>Attendance Status</b></td>
</tr>
';
$sub_query = "
SELECT * FROM tbl_attendance
WHERE student_id = '".$_GET["student_id"]."'
AND (attendance_date BETWEEN '".$_GET["from_date"]."' AND '".$_GET["to_date"]."')
ORDER BY attendance_date ASC
";
$statement = $connect->prepare($sub_query);
$statement->execute();
$sub_result = $statement->fetchAll();
foreach($sub_result as $sub_row)
{
$output .= '
<tr>
<td>'.$sub_row["attendance_date"].'</td>
<td>'.$sub_row["attendance_status"].'</td>
</tr>
';
}
$output .= '
</table>
</td>
</tr>
</table>
';
$file_name = 'Attendance Report.pdf';
$pdf->loadHtml($output);
$pdf->render();
$pdf->stream($file_name, array("Attachment" => false));
exit(0);
}
}
}
if($_GET["action"] == "attendance_report")
{
if(isset($_GET["grade_id"], $_GET["from_date"], $_GET["to_date"]))
{
$pdf = new Pdf();
$query = "
SELECT tbl_attendance.attendance_date FROM tbl_attendance
INNER JOIN tbl_student
ON tbl_student.student_id = tbl_attendance.student_id
WHERE tbl_student.student_grade_id = '".$_GET["grade_id"]."'
AND (tbl_attendance.attendance_date BETWEEN '".$_GET["from_date"]."' AND '".$_GET["to_date"]."')
GROUP BY tbl_attendance.attendance_date
ORDER BY tbl_attendance.attendance_date ASC
";
$statement = $connect->prepare($query);
$statement->execute();
$result = $statement->fetchAll();
$output .= '
<style>
@page { margin: 20px; }
</style>
<p> </p>
<h3 align="center">Attendance Report</h3><br />';
foreach($result as $row)
{
$output .= '
<table width="100%" border="0" cellpadding="5" cellspacing="0">
<tr>
<td><b>Date - '.$row["attendance_date"].'</b></td>
</tr>
<tr>
<td>
<table width="100%" border="1" cellpadding="5" cellspacing="0">
<tr>
<td><b>Student Name</b></td>
<td><b>Roll Number</b></td>
<td><b>Grade</b></td>
<td><b>Teacher</b></td>
<td><b>Attendance Status</b></td>
</tr>
';
$sub_query = "
SELECT * FROM tbl_attendance
INNER JOIN tbl_student
ON tbl_student.student_id = tbl_attendance.student_id
INNER JOIN tbl_grade
ON tbl_grade.grade_id = tbl_student.student_grade_id
INNER JOIN tbl_teacher
ON tbl_teacher.teacher_grade_id = tbl_grade.grade_id
WHERE tbl_student.student_grade_id = '".$_GET["grade_id"]."'
AND tbl_attendance.attendance_date = '".$row["attendance_date"]."'
";
$statement = $connect->prepare($sub_query);
$statement->execute();
$sub_result = $statement->fetchAll();
foreach($sub_result as $sub_row)
{
$output .= '
<tr>
<td>'.$sub_row["student_name"].'</td>
<td>'.$sub_row["student_roll_number"].'</td>
<td>'.$sub_row["grade_name"].'</td>
<td>'.$sub_row["teacher_name"].'</td>
<td>'.$sub_row["attendance_status"].'</td>
</tr>
';
}
$output .=
'</table>
</td>
</tr>
</table><br />';
}
$file_name = 'Attendance Report.pdf';
$pdf->loadHtml($output);
$pdf->render();
$pdf->stream($file_name, array("Attachment" => false));
exit(0);
}
}
}
?>
