php登录 oc,用PHP创建登录系统

有人可以帮帮我吗？我的用户名是Blimeo,我的密码是“密码”,但是当我输入我的凭据时,它说“拒绝访问”就像我告诉它的那样.我100％确定我正确配置了mySQL数据库.

echo sha1('Blimeo');

if (isset($_REQUEST['attempt'])) {

$link = mysql_connect('localhost', 'root', 'password') or die('Could not connect to database');

$user = mysql_real_escape_string($_POST['user']);

$password = sha1(mysql_real_escape_string($_POST['password']));

mysql_select_db('test_users');

$query = mysql_query(

"SELECT user

FROM users

WHERE user = '$user'

AND password = '$password'

") or die(mysql_error());

mysql_fetch_array($query);

$total = mysql_num_rows($query);

if ($total > 0) {

session_start();

$_SESSION['user'] = 'blah';

header('location: dashboard.php');

}

else {

echo '
Access denied!';

}

}

?>

Enter your username:

Enter your password: