real_escape_string(trim($_POST['subject_name']));
$sc=$conn->real_escape_string(trim($_POST['subject_code']));
$gt=$conn->real_escape_string($_POST['grading_type']);
$af=intval($_POST['applicable_from']); $at=intval($_POST['applicable_to']);
$is=isset($_POST['is_scholastic'])?1:0;
$conn->query("INSERT INTO result_subjects (subject_name,subject_code,grading_type,applicable_from,applicable_to,is_scholastic) VALUES ('$sn','$sc','$gt',$af,$at,$is)");
if($conn->affected_rows>0) $msg="Subject added!"; else $err=$conn->error;
}
if ($_POST['action']??''=='toggle') {
$id=intval($_POST['id']); $ia=intval($_POST['is_active']);
$conn->query("UPDATE result_subjects SET is_active=".($ia?0:1)." WHERE id=$id");
$msg="Updated.";
}
if (isset($_GET['del'])) { $conn->query("DELETE FROM result_subjects WHERE id=".intval($_GET['del'])); $msg="Deleted."; }
$subjects=$conn->query("SELECT * FROM result_subjects ORDER BY is_scholastic DESC,applicable_from,subject_name");
$lvls=[0=>'Nursery',1=>'LKG',2=>'UKG',3=>'Cls1',4=>'Cls2',5=>'Cls3',6=>'Cls4',7=>'Cls5',8=>'Cls6',9=>'Cls7',10=>'Cls8'];
?>
Subjects | Result