<?php require_once '../../config/db.php'; $date = $_POST['date'] ?? date('Y-m-d'); $class_id = $_POST['class_id']; $statuses = $_POST['status']; // array student_id => 'present'|'absent' $pdo->beginTransaction(); $del = $pdo->prepare('DELETE FROM attendance WHERE class_id=? AND date=?'); $del->execute([$class_id, $date]); $ins = $pdo->prepare('INSERT INTO attendance (student_id,class_id,date,status) VALUES (?,?,?,?)'); foreach($statuses as $sid=>$st) $ins->execute([$sid, $class_id, $date, $st]);
The School Management System has the following features:
– Daily student attendance.
// marksheet.php $student_id = $_GET['student_id']; $exam = $_GET['exam_type'];
<?php require_once '../../config/db.php'; $date = $_POST['date'] ?? date('Y-m-d'); $class_id = $_POST['class_id']; $statuses = $_POST['status']; // array student_id => 'present'|'absent' $pdo->beginTransaction(); $del = $pdo->prepare('DELETE FROM attendance WHERE class_id=? AND date=?'); $del->execute([$class_id, $date]); $ins = $pdo->prepare('INSERT INTO attendance (student_id,class_id,date,status) VALUES (?,?,?,?)'); foreach($statuses as $sid=>$st) $ins->execute([$sid, $class_id, $date, $st]);
The School Management System has the following features: school management system project with source code in php
– Daily student attendance.
// marksheet.php $student_id = $_GET['student_id']; $exam = $_GET['exam_type']; ?php require_once '../../config/db.php'