MAINHACK

Viewing / Editing File: student-attendance-class.php

<?php 
date_default_timezone_set("Africa/Accra"); // adjust to your TZ
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);

include("../functions.php");
 //error_reporting(0);
 if(!isset($_SESSION['dbmail_Xw211qAAsq4'])){
     header("location:../auth-login");
 } else {

$s_code = $_SESSION['s_code_Xw2119904'];
if (isset($_GET['schoolCode']) || !empty($_GET['schoolCode'])) {
   $schoolCode = test_input($_GET['schoolCode']);
}

if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $classname   = $_POST['classname1'] ?? '';
   $semester   = $_POST['semester1'] ?? '';

$students   = $_POST['schoolID'] ?? [];
    $today      = date("Y-m-d");
    $nowTime    = date("H:i:s");
    $dayOfWeek  = date("l"); // e.g. Monday, Tuesday

// 3. Save attendance for selected students
    foreach ($students as $studID) {
        $check = mysqli_query($new, "
            SELECT * FROM attendance 
            WHERE student_id = '$studID' 
              AND classname   = '$classname' 
              AND date       = '$today'
        ");

if (mysqli_num_rows($check) == 0) {
            mysqli_query($new, "
                INSERT INTO attendance (student_id,sch_code, classname,semester, date, time_in, status) 
                VALUES ('$studID','$schoolCode', '$classname', '$semester','$today', '$nowTime', 'Present')
            ");
        }
    }

echo "✅ Attendance marked successfully for " . count($students) . " students.";
}

}
?>

<!doctype html>
<html lang="en">
<head>
<meta charset="utf-8" />
<title>MARK ATTENDANCE  </title>
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta content="Premium Multipurpose Admin & Dashboard Template" name="description" />
<meta content="Themesbrand" name="author" />

<link href="assets/libs/datatables.net-bs4/css/dataTables.bootstrap4.min.css" rel="stylesheet" type="text/css" />
<link href="assets/libs/datatables.net-buttons-bs4/css/buttons.bootstrap4.min.css" rel="stylesheet" type="text/css" />

<link href="assets/libs/datatables.net-responsive-bs4/css/responsive.bootstrap4.min.css" rel="stylesheet" type="text/css" />

<link rel="stylesheet" href="assets/css/preloader.min.css" type="text/css" />

<link href="assets/css/bootstrap.min.css" id="bootstrap-style" rel="stylesheet" type="text/css" />

<link href="assets/css/icons.min.css" rel="stylesheet" type="text/css" />

<link href="assets/css/app.min.css" id="app-style" rel="stylesheet" type="text/css" />

<div id="layout-wrapper">

<?php include("includes/header.php");?>
<?php include("includes/sidebar.php");?>
<div class="main-content">
<div class="page-content">
<div class="container-fluid">

<div class="row">
<div class="col-12">
<div class="page-title-box d-sm-flex align-items-center justify-content-between">
<h4 class="mb-sm-0 font-size-18">STUDENT ATTENDANCE</h4>

<div class="page-title-right">
<ol class="breadcrumb m-0">
<li class="breadcrumb-item"><a href="javascript: void(0);">Home</a></li>
<li class="breadcrumb-item active">STUDENT ATTENDANCE</li>
</ol>
</div>
</div>
</div>
</div>

<div class="row">
  <div class="col-12">
    <div class="card shadow-sm border-0">
      <div class="card-header d-flex justify-content-between align-items-center">
        <h5 class="mb-0">📋 Mark Attendance</h5>
        <button type="button" class="btn btn-sm btn-primary" onclick="toggleSelectAll()">Check/Uncheck All</button>
      </div>
      <div class="card-body">

<div class="col-4">
<select class="form-control" name="className" required>
    <option value="">Select</option>
<?php 
$result = mysqli_query($new,"SELECT DISTINCT classname FROM `enrol_details` WHERE s_code= '$schoolCode'"); 
while($row = mysqli_fetch_array($result)){ 
?>
<option value="<?php echo $row['classname'];?>"><?php echo $row['classname'];?></option>
<?php }?>
</select>
</div>

<div class="col-4">
<select class="form-control" name="semester" required>
    <option value="">Select</option>
<?php 
$result = mysqli_query($new,"SELECT  semester FROM `semester` WHERE s_code= '$schoolCode'"); 
while($row = mysqli_fetch_array($result)){ 
?>
<option value="<?php echo $row['semester'];?>"><?php echo $row['semester'];?></option>
<?php }?>
</select>
</div>

<div class="table-responsive">
            <table class="table table-striped table-bordered align-middle">
              <thead class="table-light">
                <tr>
                  <th style="width:50px;" class="text-center">#</th>
                  <th>Student ID</th>
                  <th>Name</th>
                  <th>Status</th>
                </tr>
              </thead>
    <?php

// Default variables
$scholCode = '';
$classname = '';
$semester = '';

// Handle POST if submitted
if (isset($_POST['loadthis'])) {
    $semester = test_input($_POST['semester']);
    $classname = test_input($_POST['className']);
    $scholCode = test_input($_POST['scholCode']);
}

// Prepare and execute query (using prepared statements for security)
$sql = "SELECT * FROM enrol_details WHERE s_code = ? AND classname = ? AND semester = ?";
$stmt = mysqli_prepare($new, $sql);

if ($stmt) {
    mysqli_stmt_bind_param($stmt, "sss", $scholCode, $classname, $semester); // 'sss' for three strings
    mysqli_stmt_execute($stmt);
    $result = mysqli_stmt_get_result($stmt);
    
    $students = [];
    while ($row = mysqli_fetch_assoc($result)) {
        $students[] = $row;
    }
    mysqli_stmt_close($stmt);
} else {
    // Query preparation failed
    echo "Query error: " . mysqli_error($new); // For debugging—remove in production
    $students = [];
}

<tbody>
    <?php if (!empty($students)): ?>
        <?php foreach ($students as $i => $s): ?>
            <tr>
                <td class="text-center">
                    <input type="checkbox" name="schoolID[]" value="<?= htmlspecialchars($s['schoolID']) ?>" class="student-check">
                </td>
                <td><?= htmlspecialchars($s['index_no']) ?></td>
                <td><?= htmlspecialchars($s['student_name']) ?></td>
                <td>
                    <span class="badge bg-secondary">Not Marked</span>
                </td>
            </tr>
        <?php endforeach; ?>
    <?php else: ?>
        <tr>
            <td colspan="4" class="text-center text-muted">No students found in this class</td>
        </tr>
    <?php endif; ?>
</tbody>
            </table>
          </div>

<div class="mt-3 text-end">
            <button type="submit" class="btn btn-success px-4">✅ Submit Attendance</button>
          </div>
        </form>

</div>
    </div>
  </div>
</div>

</div>

<?php include("includes/footer.php");?>
</div>

</div>

<div class="right-bar">
<div data-simplebar class="h-100">
<div class="rightbar-title d-flex align-items-center p-3">

<h5 class="m-0 me-2">Theme Customizer</h5>

<hr class="m-0" />

<div class="p-4">
<h6 class="mb-3">Layout</h6>
<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="layout"
id="layout-vertical" value="vertical">
<label class="form-check-label" for="layout-vertical">Vertical</label>
</div>
<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="layout"
id="layout-horizontal" value="horizontal">
<label class="form-check-label" for="layout-horizontal">Horizontal</label>
</div>

<h6 class="mt-4 mb-3 pt-2">Layout Mode</h6>

<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="layout-mode"
id="layout-mode-light" value="light">
<label class="form-check-label" for="layout-mode-light">Light</label>
</div>
<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="layout-mode"
id="layout-mode-dark" value="dark">
<label class="form-check-label" for="layout-mode-dark">Dark</label>
</div>

<h6 class="mt-4 mb-3 pt-2">Layout Width</h6>

<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="layout-width"
id="layout-width-fuild" value="fuild" onchange="document.body.setAttribute('data-layout-size', 'fluid')">
<label class="form-check-label" for="layout-width-fuild">Fluid</label>
</div>
<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="layout-width"
id="layout-width-boxed" value="boxed" onchange="document.body.setAttribute('data-layout-size', 'boxed')">
<label class="form-check-label" for="layout-width-boxed">Boxed</label>
</div>

<h6 class="mt-4 mb-3 pt-2">Layout Position</h6>

<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="layout-position"
id="layout-position-fixed" value="fixed" onchange="document.body.setAttribute('data-layout-scrollable', 'false')">
<label class="form-check-label" for="layout-position-fixed">Fixed</label>
</div>
<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="layout-position"
id="layout-position-scrollable" value="scrollable" onchange="document.body.setAttribute('data-layout-scrollable', 'true')">
<label class="form-check-label" for="layout-position-scrollable">Scrollable</label>
</div>

<h6 class="mt-4 mb-3 pt-2">Topbar Color</h6>

<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="topbar-color"
id="topbar-color-light" value="light" onchange="document.body.setAttribute('data-topbar', 'light')">
<label class="form-check-label" for="topbar-color-light">Light</label>
</div>
<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="topbar-color"
id="topbar-color-dark" value="dark" onchange="document.body.setAttribute('data-topbar', 'dark')">
<label class="form-check-label" for="topbar-color-dark">Dark</label>
</div>

<h6 class="mt-4 mb-3 pt-2 sidebar-setting">Sidebar Size</h6>

<div class="form-check sidebar-setting">
<input class="form-check-input" type="radio" name="sidebar-size"
id="sidebar-size-default" value="default" onchange="document.body.setAttribute('data-sidebar-size', 'lg')">
<label class="form-check-label" for="sidebar-size-default">Default</label>
</div>
<div class="form-check sidebar-setting">
<input class="form-check-input" type="radio" name="sidebar-size"
id="sidebar-size-compact" value="compact" onchange="document.body.setAttribute('data-sidebar-size', 'md')">
<label class="form-check-label" for="sidebar-size-compact">Compact</label>
</div>
<div class="form-check sidebar-setting">
<input class="form-check-input" type="radio" name="sidebar-size"
id="sidebar-size-small" value="small" onchange="document.body.setAttribute('data-sidebar-size', 'sm')">
<label class="form-check-label" for="sidebar-size-small">Small (Icon View)</label>
</div>

<h6 class="mt-4 mb-3 pt-2 sidebar-setting">Sidebar Color</h6>

<div class="form-check sidebar-setting">
<input class="form-check-input" type="radio" name="sidebar-color"
id="sidebar-color-light" value="light" onchange="document.body.setAttribute('data-sidebar', 'light')">
<label class="form-check-label" for="sidebar-color-light">Light</label>
</div>
<div class="form-check sidebar-setting">
<input class="form-check-input" type="radio" name="sidebar-color"
id="sidebar-color-dark" value="dark" onchange="document.body.setAttribute('data-sidebar', 'dark')">
<label class="form-check-label" for="sidebar-color-dark">Dark</label>
</div>
<div class="form-check sidebar-setting">
<input class="form-check-input" type="radio" name="sidebar-color"
id="sidebar-color-brand" value="brand" onchange="document.body.setAttribute('data-sidebar', 'brand')">
<label class="form-check-label" for="sidebar-color-brand">Brand</label>
</div>

<h6 class="mt-4 mb-3 pt-2">Direction</h6>

</div>

</div> 
</div>

<div class="rightbar-overlay"></div>

<script src="assets/libs/jquery/jquery.min.js"></script>
<script src="assets/libs/bootstrap/js/bootstrap.bundle.min.js"></script>
<script src="assets/libs/metismenu/metisMenu.min.js"></script>
<script src="assets/libs/simplebar/simplebar.min.js"></script>
<script src="assets/libs/node-waves/waves.min.js"></script>
<script src="assets/libs/feather-icons/feather.min.js"></script>

<script src="assets/libs/pace-js/pace.min.js"></script>

<script src="assets/libs/datatables.net/js/jquery.dataTables.min.js"></script>
<script src="assets/libs/datatables.net-bs4/js/dataTables.bootstrap4.min.js"></script>

<script src="assets/libs/datatables.net-buttons/js/dataTables.buttons.min.js"></script>
<script src="assets/libs/datatables.net-buttons-bs4/js/buttons.bootstrap4.min.js"></script>
<script src="assets/libs/jszip/jszip.min.js"></script>
<script src="assets/libs/pdfmake/build/pdfmake.min.js"></script>
<script src="assets/libs/pdfmake/build/vfs_fonts.js"></script>
<script src="assets/libs/datatables.net-buttons/js/buttons.html5.min.js"></script>
<script src="assets/libs/datatables.net-buttons/js/buttons.print.min.js"></script>
<script src="assets/libs/datatables.net-buttons/js/buttons.colVis.min.js"></script>

<script src="assets/libs/datatables.net-responsive/js/dataTables.responsive.min.js"></script>
<script src="assets/libs/datatables.net-responsive-bs4/js/responsive.bootstrap4.min.js"></script>
        <script src="assets/libs/sweetalert2/sweetalert2.min.js"></script>

<script src="assets/js/pages/datatables.init.js"></script>

myModal.addEventListener('shown.bs.modal', function () {
myInput.focus()
})
</script>

</body>
</html>

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: student-attendance-class.php

Server Info

System Features

User Info