Password имеет тип "Password_hash" < /p>
Код: Выделить всё
public function login(string $email, string $password){
$user = self::fetchLoginCredentials($email);
if(!$user){
return false;
}
if(password_verify($password, $user['password'])){
return $user;
}
return false;
}
public function fetchLoginCredentials(string $email){
$sql = "SELECT u.id, u.firstname, u.lastname, u.email, u.password,
r.name as role, i.filename as image_name, i.alt as image_alt
FROM users as u
JOIN roles as r on u.role_id = r.id
LEFT JOIN images as i on profile_pic_id = i.id
WHERE email = ?";
try{
return $this->db->sql_execute($sql, [$email])->fetch_assoc();
} catch (\Exception $e){
return $e;
}
}
Подробнее здесь: https://stackoverflow.com/questions/795 ... h-in-phpmy
Мобильная версия