Welcome, 🎉 |
Logout |
Change Password
📊 School Enrolment Summary ( - )
Total Males
Total Females
Total Enrollment
🏫 Enrollment Summary Per Class ()
prepare("SELECT SEX, COUNT(*) as count FROM STUDENTS GROUP BY SEX");
$stmt->execute([$class, $term, $currentYear]);
$data = $stmt->fetchAll(PDO::FETCH_KEY_PAIR);
$male = $data['M'] ?? 0;
$female = $data['F'] ?? 0;
$total = $male + $female;
$bgColor = $classColors[$colorIndex % count($classColors)];
$colorIndex++;
?>
Class
♂ Boys:
♀ Girls:
👥 Total:
🧪 Midterm Results Analysis ()
prepare("SELECT DIVISION, COUNT(*) as count FROM midterm_results WHERE CLASS = ? AND TERM = ? AND YEAR(RECORD_DATE) = ? GROUP BY DIVISION");
$stmt->execute([$class, $term, $currentYear]);
$results = $stmt->fetchAll(PDO::FETCH_KEY_PAIR);
?>
Class
Division :
📚 End of Term Results Analysis ()
prepare("SELECT DIVISION, COUNT(*) as count FROM RESULTS WHERE CLASS = ? AND TERM = ? AND YEAR(RECORD_DATE) = ? GROUP BY DIVISION");
$stmt->execute([$class, $term, $currentYear]);
$results = $stmt->fetchAll(PDO::FETCH_KEY_PAIR);
?>
Class
Division :