我正在写一个注册脚本,用户密码是这样加密的
$pword = hash('sha512', $_POST['password']);登录时,我使用相同的post脚本加密密码,然后在数据库中查找匹配项
$result = mysql_query("SELECT * FROM $table WHERE email = '$email' AND password = '$pword'
");
if(mysql_num_rows($result))
{
//do something
$return['error'] = false;
$return['msg'] = 'Logging In.';
}
else
{
// Invalid username/password
$return['error'] = true;
$return['msg'] = 'Wrong Email Or Password Try Again';
}问题是我一直收到一条错误消息,好像密码不匹配。
我把它改成了这个脚本
$query_wins ="SELECT * FROM `users` WHERE `email` = \"$email\" AND `password`=\"$pword\" AND `active`='Y'";
$result=mysql_query($query_wins) or die(mysql_error());
$result= mysql_query($query_wins);
$row = mysql_fetch_array($result);
$memid= $row['id'];
if($memid==""){
$return['error'] = true;
$return['msg'] = 'Wrong Email Or Password Try Again';
}现在它只给我一个“错误的电子邮件或密码错误”。
发布于 2011-11-23 02:05:20
要检查的事项:
if(mysql_num_rows($result) > 0)查看是否得到结果https://stackoverflow.com/questions/8230771
复制相似问题