我正在一个需要会员部分的网站上工作。因此,当用户注册一个新成员帐户时,我将保存用户名、随机盐和使用随机盐和用户密码的SHA512哈希密码,以便不将密码以明文形式保存在我的数据库中。
当用户登录时,我似乎遇到的问题是,当我从桌面使用网站与从移动浏览器(Android和IOS设备)使用网站时,SHA512 javascript函数返回不同的值。桌面看起来是正确的。
下面是我用来检查用户何时登录的PHP函数:
// login function, check email and password against the database.
function login($email, $password, $mysqli) {
// Using prepared statements means that SQL injection is not possible.
if ($stmt = $mysqli->prepare("SELECT id, username, password, salt
FROM members
WHERE email = ?
LIMIT 1")) {
$stmt->bind_param('s', $email); // Bind "$email" to parameter.
$stmt->execute(); // Execute the prepared query.
$stmt->store_result();
// get variables from result.
$stmt->bind_result($user_id, $username, $db_password, $salt);
$stmt->fetch();
// hash the password with the unique salt.
$password = hash('sha512', $password . $salt);
if ($stmt->num_rows == 1) {
// If the user exists we check if the account is locked
// from too many login attempts
if (checkbrute($user_id, $mysqli) == true) {
// Account is locked
// Send an email to user saying their account is locked
$_SESSION['temp'] = "account locked.";
return false;
} else {
// Check if the password in the database matches
// the password the user submitted.
if ($db_password == $password) {
// Password is correct!
// Get the user-agent string of the user.
$user_browser = $_SERVER['HTTP_USER_AGENT'];
// XSS protection as we might print this value
$user_id = preg_replace("/[^0-9]+/", "", $user_id);
$_SESSION['user_id'] = $user_id;
$_SESSION['temp'] = $user_browser;
// XSS protection as we might print this value
$username = preg_replace("/[^a-zA-Z0-9_'-]+/",
"",
$username);
$_SESSION['username'] = $username;
$_SESSION['login_string'] = hash('sha512',
$password . $user_browser);
// Login successful.
return true;
} else {
// Password is not correct
// We record this attempt in the database
$now = time();
$mysqli->query("INSERT INTO login_attempts(user_id, time)
VALUES ('$user_id', '$now')");
$_SESSION['temp'] = "Invalid password. ";// . $username . " " . $password . " " . $db_password;
return false;
}
}
} else {
$_SESSION['temp'] = "User not Found.";
// No user exists.
return false;
}
}
}
以下是我从相同的用户名/密码得到的SHA值:桌面(让我正确登录):091b2e6cda1e1ee4de89b1164703a238021fa6c092551cfea2c967051bd01f3992dbe160bbc25a14694f119a819b88534b21d0f7c8da9c80bb8c06a79f75074c
从我的Android手机(返回无效密码):20036264d5fccd56658e45364112ae0e3356878d84150aa817e049a288aa491b88fab9384df71a3aae7e3d0145acd3dc5608030961181b1bf8336e6019824daf
我使用的javascript SHA512函数可以在这里找到:http://pajhome.org.uk/crypt/md5
我认为这种异常是由于字符的表示。在不同的操作系统、浏览器和设备中,表示可能会有所不同。在计算摘要之前,请尝试将密码转换为通用格式,如UNICODE。
在php中可以使用utf8_encode()函数
function encode_utf8( s ) {
return unescape( encodeURIComponent( s ) );
}
function decode_utf8( s ) {
return decodeURIComponent( escape( s ) );
}