<?php

$navbar_profile= mysqli_connect('localhost','pacssvmc','qPAuVjM#36q)65','pacssvmc_profile');
    if(!$navbar_profile){
        echo 'Connection Error : ' . mysqli_connect_error()  ;
      }
      

if(isset($_POST['selsection'])){
    $_SESSION['section']=$_POST['secselect'];
}else{
    $_SESSION['section']='A';
}

//profile redirection

if(isset($_POST['overallyr'])){
        header('Location:../admin/student1.php');
}
if(isset($_POST['1styr'])){
      $_SESSION["yr"]='1st_yr';
        header('Location:../admin/student2.php');
}
if(isset($_POST['2ndyr'])){
      $_SESSION["yr"]='2nd_yr';
        header('Location:../admin/student2.php');
}
if(isset($_POST['3rdyr'])){
      $_SESSION["yr"]='3rd_yr';
        header('Location:../admin/student2.php');
}
if(isset($_POST['4thyr'])){
      $_SESSION["yr"]='4th_yr';
        header('Location:../admin/student2.php');
}

//attendance redirection

if(isset($_POST['att_1styr'])){
     $_SESSION["yr"]='1st_yr';
     header('Location:../php/attendance_2ndyr.php');
}
if(isset($_POST['att_2ndyr'])){
     $_SESSION["yr"]='2nd_yr';
        header('Location:../php/attendance_2ndyr.php');
}
if(isset($_POST['att_3rdyr'])){
     $_SESSION["yr"]='3rd_yr';
        header('Location:../php/attendance_2ndyr.php');
}
if(isset($_POST['att_4thyr'])){
     $_SESSION["yr"]='4th_yr';
        header('Location:../php/attendance_2ndyr.php');
}

//marklist redirection
if (isset($_POST['hod'])) {
    
    $_SESSION["position"] = "hod";
    header("location: ../marklist/examslist.php ");    
}
if (isset($_POST['mentor'])) {
    
    $_SESSION["position"] = "mentor";
    header("location: ../marklist/examslist.php ");    
}
if (isset($_POST['class_advisor'])) {
    
    $_SESSION["position"] = "classadvisor";
    header("location: ../marklist/examslist.php ");    
}
if (isset($_POST['subject'])) {
    
    $_SESSION["position"] = "subject";
    header("location: ../marklist/examslist.php ");    
}

$yr=$_SESSION["yr"];
$sqlsem="SELECT ssem,sbat FROM userregistration WHERE syear='$yr'";
$resultsem=mysqli_query($navbar_profile,$sqlsem);
$semarray = mysqli_fetch_all($resultsem,MYSQLI_ASSOC); 
$_SESSION['sem']=$semarray[0]['ssem']; 
$_SESSION['bat']=$semarray[0]['sbat']; 
?>