query("SELECT * FROM classes ORDER BY class_name ASC"); $subjects = $conn->query("SELECT * FROM subjects ORDER BY subject_name ASC"); /* ================= KEEP VALUES ================= */ $class_id = $_GET['class_id'] ?? ''; $subject_id = $_GET['subject_id'] ?? ''; // Term and session are fetched from DB (set via Settings page) $active_term_row = $conn->query("SELECT name FROM terms WHERE is_active = 1 LIMIT 1")->fetch_assoc(); $active_session_row = $conn->query("SELECT name FROM sessions WHERE is_active = 1 LIMIT 1")->fetch_assoc(); $term = $active_term_row ? $active_term_row['name'] : ''; $session = $active_session_row ? $active_session_row['name'] : ''; /* ================= LOAD QUESTIONS ================= */ $questions = []; $class_name = ""; $subject_name = ""; if(isset($_GET['load'])){ $stmt = $conn->prepare(" SELECT q.*, c.class_name, s.subject_name, qi.image_name FROM questions q JOIN classes c ON q.class_id = c.id JOIN subjects s ON q.subject_id = s.id LEFT JOIN question_images qi ON qi.question_id = q.id AND qi.id = ( SELECT MAX(id) FROM question_images WHERE question_id = q.id ) WHERE q.class_id = ? AND q.subject_id = ? AND q.term = ? AND q.session = ? "); $stmt->bind_param("iiss", $class_id, $subject_id, $term, $session); $stmt->execute(); $result = $stmt->get_result(); while($row = $result->fetch_assoc()){ $questions[] = $row; } if(count($questions) > 0){ $class_name = $questions[0]['class_name']; $subject_name = $questions[0]['subject_name']; } } /* ================= AUTO SIZE TIER ================= */ /* Based on question count, assign a tier that drives font sizes on screen AND on the A4 print output. Tier 1 (1-5) : very large — few questions, big readable text Tier 2 (6-10) : large — comfortable reading size Tier 3 (11-15) : medium — default balanced size Tier 4 (16-20) : small — compact to fit A4 Tier 5 (21+) : very small — maximum compression for A4 */ $qCount = count($questions); if ($qCount <= 5) { $sizeTier = 'tier1'; } elseif ($qCount <= 10) { $sizeTier = 'tier2'; } elseif ($qCount <= 15) { $sizeTier = 'tier3'; } elseif ($qCount <= 20) { $sizeTier = 'tier4'; } else { $sizeTier = 'tier5'; } ?> View Questions

Load Examination Questions

📅 Term:  •  🗓️ Session:
⚠️ No active term or session set. Please update in Settings.
0): ?>
❀ ❀ ❀
❀ ❀ ❀
School Logo

ALBAYAN ACADEMY NURSERY & PRIMARY SCHOOL SHENDAM

Tudun Wada Shendam, Plateau State, Nigeria.

Class:
Subject:
Term:
Session:
Adm No: ________________
EXAMINATION QUESTIONS
Instruction:
.
.
Question Image
.
.
.
.
Essay answer space, write here
★ Printed by Albayan Academy Nur & Pri School ICT Center — Shendam ★