Attendance | Result

$td) { echo json_encode(['success'=>false,'msg'=>'Attended > Total']); exit; } $conn->query("INSERT INTO result_attendance (student_id,term_id,total_days,attended_days) VALUES ($sid,$tid,$td,$ad) ON DUPLICATE KEY UPDATE total_days=$td,attended_days=$ad"); echo json_encode(['success'=>true]); exit; } $selected_class=intval($_GET['class_id']??0); $selected_term=intval($_GET['term_id']??0); $classes=$conn->query("SELECT rc.*,rs.session_name FROM result_classes rc JOIN result_sessions rs ON rc.session_id=rs.id ORDER BY rs.is_active DESC,rc.numeric_level,rc.section"); $terms=$conn->query("SELECT rt.*,rs.session_name FROM result_terms rt JOIN result_sessions rs ON rt.session_id=rs.id ORDER BY rs.is_active DESC,rt.display_order"); $students=[]; $att_map=[]; if($selected_class&&$selected_term){ $sr=$conn->query("SELECT id,first_name,last_name,roll_no,admission_no FROM result_students WHERE class_id=$selected_class AND is_active=1 ORDER BY roll_no,first_name"); while($s=$sr->fetch_assoc()) $students[]=$s; if(!empty($students)){ $sids=implode(',',array_column($students,'id')); $ar=$conn->query("SELECT * FROM result_attendance WHERE student_id IN($sids) AND term_id=$selected_term"); while($a=$ar->fetch_assoc()) $att_map[$a['student_id']]=$a; } } ?> Attendance | Result

Attendance — Students

Auto-save ON

$s): $a=$att_map[$s['id']]??['total_days'=>0,'attended_days'=>0]; $pct=($a['total_days']>0)?round($a['attended_days']/$a['total_days']*100,1):0; ?>

#	Student	Roll	Total Days	Days Present	% Attendance	Status
					%	=75): ?>Good=60): ?>AverageLow

No students in this class.

📅

Attendance Entry

Attendance — Students

Select class and term to enter attendance