从数据库获取用户和加密密码

Question

i got the following code:

    public function getUserByNameAndPassword($name, $password) {

    $stmt = $this->conn->prepare("SELECT salt FROM `users` WHERE name = ?");
    $stmt->bind_param("s", $name);
    if ($stmt->execute()) {
            $stmt->store_result();
            $salt = $stmt->get_result();
            } 
    $encryptedpassword = $this->checkhashSSHA($salt,$password);

    $stmt = $this->conn->prepare("SELECT * FROM `users` WHERE name = ? AND encrypted_password = ?");
    $stmt->bind_param("ss", $name, $encryptedpassword);
            if ($stmt->execute()) {
                $user = $stmt->get_result()->fetch_assoc();
                $stmt->close();
                return $user;
            } 
            else {
                return false;
        }

}

And the following constructor:

    // constructor
function __construct() {
    require_once 'DB_Connect.php';
    // connecting to database
    $db = new Db_Connect();
    $this->conn = $db->connect();
}

I'm trying to get user from datebase but it is not working at all, i already tried many things, checked my syntax multiple times but i can't find my mistake. Anybody has an idea?

Edit: Changed code and added log but the log doesent report anything.