real_escape_string(trim($_POST['session_name']));
$sd=$_POST['start_date']; $ed=$_POST['end_date'];
$ia=isset($_POST['is_active'])?1:0;
if($ia) $conn->query("UPDATE result_sessions SET is_active=0");
$conn->query("INSERT INTO result_sessions (session_name,start_date,end_date,is_active) VALUES ('$sn','$sd','$ed',$ia)");
if($conn->affected_rows>0) $msg="Session added!"; else $err=$conn->error;
}
if ($_POST['action']??''=='activate') {
$id=intval($_POST['id']);
$conn->query("UPDATE result_sessions SET is_active=0");
$conn->query("UPDATE result_sessions SET is_active=1 WHERE id=$id");
$msg="Session activated!";
}
if (isset($_GET['del'])) { $conn->query("DELETE FROM result_sessions WHERE id=".intval($_GET['del'])); $msg="Deleted."; }
$sessions = $conn->query("SELECT * FROM result_sessions ORDER BY id DESC");
$_inc_sidebar=true;
?>
Sessions | Result