LMI Login Verification

get_row($wpdb->prepare(
”
SELECT EmpID, UserID, UserType
FROM wp_useraccount
WHERE UserName = %s
AND BINARY UserPassword = %s
AND Status = %s
“,
$username,
$password,
“Active”
));

if($users != null){
// Admin Log in
if(($users->UserType) == “Admin”){
$_SESSION[‘admin’] = $users->EmpID;
$_SESSION[‘logged’] = $users->EmpID;
$_SESSION[‘userID’] = $users->UserID;
header(“Location: http://localhost/wp-tesdaregion10/lmi-admin”);
exit;
//Normal Users Log in
}else{
$_SESSION[‘logged’] = $users->EmpID;
$_SESSION[‘userID’] = $users->UserID;
header(“Location: http://localhost/wp-tesdaregion10/labormarketinfo”);
exit;
}
} else {
echo “Invalid password or username. “;
$redirectLink = “http://localhost/wp-tesdaregion10/employerlogin”;
echo “Try again.“;
}

?>