real_escape_string(trim($_POST['teacher_name']));
$mm=intval($_POST['max_marks']); $pm=intval($_POST['pass_marks']);
$conn->query("INSERT IGNORE INTO result_class_subject (class_id,subject_id,teacher_name,max_marks,pass_marks) VALUES ($cid,$sid,'$tc',$mm,$pm)");
if($conn->affected_rows>0) $msg="Mapping added!"; else $err="Already exists or error: ".$conn->error;
}
if ($_POST['action']??''=='bulk') {
$cid=intval($_POST['class_id']);
$sids=$_POST['subject_ids']??[];
foreach($sids as $sid) {
$sid=intval($sid);
$conn->query("INSERT IGNORE INTO result_class_subject (class_id,subject_id,max_marks,pass_marks) VALUES ($cid,$sid,100,33)");
}
$msg="Bulk mapping done!";
}
if (isset($_GET['del'])) { $conn->query("DELETE FROM result_class_subject WHERE id=".intval($_GET['del'])); $msg="Deleted."; }
$filter_class=intval($_GET['class_id']??0);
$where=$filter_class?"WHERE cs.class_id=$filter_class":"";
$mappings=$conn->query("SELECT cs.*,c.class_name,c.section,s.subject_name,s.grading_type,s.is_scholastic FROM result_class_subject cs JOIN result_classes c ON cs.class_id=c.id JOIN result_subjects s ON cs.subject_id=s.id $where ORDER BY c.numeric_level,c.section,s.subject_name");
$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");
$subjects=$conn->query("SELECT * FROM result_subjects WHERE is_active=1 ORDER BY is_scholastic DESC,subject_name");
?>
Class-Subject Map | Result