mysql salt bcrypt_php mysql bcrypt和密码不匹配

我无法安全地验证用户名和密码。在检查数据库中是否存在电子邮件地址后,我会检查输入的密码是否也与数据库中的密码匹配,但我的密码没有验证。

这是我的

用户登录.php

文件:

require_once "../include/Constants.php";

$conn = new mysqli(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);

if($_SERVER['REQUEST_METHOD']=='POST')

{

$username = $_POST['username'];

$password = $_POST['password'];

//filter this variable for security

$password = strip_tags(mysqli_real_escape_string($conn, trim($password)));

$query = "SELECT * FROM students WHERE s_id = '".$username."' ";

$tbl = mysqli_query($conn, $query);

if(mysqli_num_rows($tbl)>0)

{

//when email is matched it also need to verify the password

$row = mysqli_fetch_array($tbl);

$password_hash = $row['password'];

if(password_verify($password, $password_hash))

{

echo "success";

}

else

{

echo "failed login"."
";

echo $password_hash."
";

echo $password;

}

}

else

{

echo "email failed";

}

出于某种原因,用bcrypt加密的密码和密码不匹配。我找不到我做错了什么。如果您对解决方案有一些建议,请提供帮助。谢谢!