alert('Please login before accessing');"; session_destroy(); } if(isset($_GET['logout']) && $_GET['logout'] == 'true'){ session_destroy(); header('location:index.php'); exit(); } } ?> DFPPI Data Bank
DFPPI Data Bank
Employee ID


Password


"; $_SESSION["isPriv"] = true; }else if ($usr == $reg_user && $pass == $usr){ echo ""; $_SESSION["privilege"] = "All"; $_SESSION['isLogin'] = true; }else{ $pass = md5($pass); $find_q = "SELECT fn,ln FROM users WHERE id_num = '{$usr}' AND pw = '{$pass}' AND stat = 'Enabled'"; /*successful login*/ $set = mysqli_query($link,$find_q); if(mysqli_num_rows($set) == 1){ $var = mysqli_fetch_assoc($set); $_SESSION["first_name"] = $var["fn"]; $_SESSION["last_name"] = $var["ln"]; $_SESSION['isLogin'] = true; $find_f = "SELECT f_id,f_department FROM faculty WHERE f_firstName = '{$_SESSION['first_name']}' AND f_lastName = '{$_SESSION['last_name']}' AND f_status = 'Okay'"; $gd = mysqli_fetch_array(mysqli_query(mysqli_connect("localhost","root","","2101_final_project"),$find_f)); /*privilege will get user's department class*/ $_SESSION["MAIN-USER-ID"] = $gd[0]; $_SESSION["privilege"] = $gd[1]; $_SESSION["FLAG_VALUE"]++; /* echo $_SESSION["sex"]; echo "

Hello {$_SESSION["first_name"]} {$_SESSION["last_name"]}

"; */ echo ""; }else{ echo ""; echo ""; } } }else{ echo "(NOT)Database error connection"; } } ?>