connect_error > 0) {
die('Could not connect: ' . $con->connect_error);
exit(); // directs to error page if something is wrong
}
// generate the login onto the page
$sqlcmd = "SELECT CAST(userid as CHAR) as userid, loginname, accesslevel
from users
WHERE username = '" . $username . "' and password = '" . $password . "'";
$sql = $con->prepare($sqlcmd);
$sql->execute();
$sql->bind_result($userid, $loginname, $accesslevel);
$sql->store_result();
$sql->fetch();
// Checks if password/username is correct, if not error message
if ($sql->affected_rows == 0)
$errormsg = "Username/Password incorrect please try again";
else {
if ($accesslevel == 1)
$errormsg = "Account is Locked, please try again";
else {
// if we get here its a good login
// check the access level 2 it will direct the user to the other page
if ($accesslevel == 2)
header('Location: http://localhost/gamerental/dashboard/index1.php');
else {
// if ait isnt 1 then it will direct them to the main page
header('Location: http://localhost/gamerental/dashboard/index.php');
exit();
}
}
}
}
?>
Sign in for Game Rental