connect_error > 0) {
die('Could not connect: ' . $con->connect_error);
exit(); // you should redirect to some form of error page !!!!
}
// or by using prepared statements
$sqlcmd = "SELECT CAST(LoginID as CHAR) as LoginID, LoginUsername
from loginAccounts
WHERE LoginUsername = ? and LoginPassword = ?";
$sql = $con->prepare($sqlcmd);
$sql->bind_param("ss", $LoginUsername, $LoginPassword);
$sql->execute();
$sql->bind_result($LoginID, $LoginUsername);
$sql->store_result();
$sql->fetch();
// check if we have only 1 record
if ($sql->affected_rows == 0)
$errormsg = "Username/Password incorrect";
else {
// check if we have > 1 record
if ($sql->affected_rows > 1)
$errormsg = "Error: 0x123fe1abc has occurred. Contact Administrator";
else {
// redirect to the dashboard
header('Location: http://localhost/databaseAssignment/dashboard/index.php');
exit();
}
}
}
?>
Signin To Rentals V1.0