real_escape_string(trim($_POST['activity_name']));
$grade=$conn->real_escape_string(trim($_POST['grade']));
$conn->query("INSERT INTO result_coscholastic (student_id,term_id,activity_name,grade) VALUES ($sid,$tid,'$act','$grade') ON DUPLICATE KEY UPDATE grade='$grade'");
echo json_encode(['success'=>true]); exit;
}
$sel_class=intval($_GET['class_id']??0); $sel_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=[]; $coscho_map=[];
$activities=['Art Education','Health & Phys. Ed.','Work Education','Discipline & Conduct'];
$grades_opts=['A+','A','B','C','D'];
if($sel_class&&$sel_term){
$sr=$conn->query("SELECT id,first_name,last_name,roll_no FROM result_students WHERE class_id=$sel_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'));
$cr=$conn->query("SELECT * FROM result_coscholastic WHERE student_id IN($sids) AND term_id=$sel_term");
while($c=$cr->fetch_assoc()) $coscho_map[$c['student_id']][$c['activity_name']]=$c['grade'];
}
}
?>
Co-Scholastic | Result