real_escape_string(trim($_POST['session_id'])); $cn=$conn->real_escape_string(trim($_POST['class_name'])); $nl=intval($_POST['numeric_level']); $sec=$conn->real_escape_string(trim($_POST['section'])); $ct=$conn->real_escape_string(trim($_POST['class_teacher'])); $conn->query("INSERT INTO result_classes (session_id,class_name,numeric_level,section,class_teacher) VALUES ($sess,'$cn',$nl,'$sec','$ct')"); if($conn->affected_rows>0) $msg="Class added!"; else $err=$conn->error; } if (isset($_GET['del'])) { $conn->query("DELETE FROM result_classes WHERE id=".intval($_GET['del'])); $msg="Deleted."; } $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"); $sessions = $conn->query("SELECT * FROM result_sessions ORDER BY is_active DESC,id DESC"); $class_names=[0=>'Nursery',1=>'LKG',2=>'UKG',3=>'Class 1',4=>'Class 2',5=>'Class 3',6=>'Class 4',7=>'Class 5',8=>'Class 6',9=>'Class 7',10=>'Class 8']; ?> Classes | Result

Classes & Sections

fetch_assoc()): $i++; $sc=$conn->query("SELECT COUNT(*) as n FROM result_students WHERE class_id={$c['id']}")->fetch_assoc()['n']; ?>
#SessionClassLevelSectionClass TeacherStudentsActions
Section Students