php mysql注册登录失败_简单的PHP / MySQL用户注册工作，但不能用用户名登录

我正在研究一个简单的用户登录系统，以在我自己的机器上进行练习。

我有一个用户名，密码和电子邮件的MySQL表用户。我能够通过以下方式注册新用户：

//short variable names:

$email = $_POST['email'];

$username = $_POST['username'];

$password = $_POST['password'];

$password2 = $_POST['password2'];

session_start();

//attempt to register

register($username, $email, $password);我创建了这个函数来输入数据库它使用以下函数：

function register($username, $email, $password){

//register new person with db

//return true or error

//connect to db

$db = db_connect();

//check if username is unique

$result = $db->query("SELECT * from user where username = '".$username."'");

if(!$result){

throw new Exception('Could not execute query');

}

if($result->num_rows>0){

throw new Exception('That username is taken - go back and choose another one.');

}

//if ok, put in db

$result = $db->query("INSERT into user values

('".$username."', sha1('".$password."'), '".$email."')");

if(!$result){

throw new Exception('Could not register you in database - Please try again later.');

}

return true;}

然后我注册了变量

//register session variable

$_SESSION['valid_user'] = $username;

echo 'Your registration was successful. Go to the members page to start setting up your profile!';当我尝试使用用户名和密码登录时，此处不起作用的是登录代码：

function login($username, $password){

//check username and password with db

$db = db_connect();

//check if username unique

$result = $db->query("SELECT * FROM user where username = '".$username."' and password = sha1('".$password."')");

if(!$result){

throw new Exception('Could not log you in.');

}

if($result->num_rows > 0){

return true;

} else {

throw new Exception('Could not log you in.');

}

}我知道这不是安全的，只是在我的机器上练习，所以我可以向上移动，有没有人有任何解释？密码在db中注册为sha1 varchar，我认为这就是我没有这样做的原因？

谢谢您的帮助