alert('Please login before accessing');";
session_destroy();
}
if(isset($_GET['logout']) && $_GET['logout'] == 'true'){
session_destroy();
header('location:index.php');
exit();
}
}
?>
DFPPI Data Bank
";
$_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";
}
}
?>