public static function getByUserId($db, $userId)
{
$sql = "SELECT `username`, `password_hash`, `email` FROM user WHERE username = :username";
$sth = $db->prepare($sql);
$sth->execute([":username" => $userId]);
$result = $sth->fetchAll();
if (!empty($result)) {
$privUser = new PrivilegedUser();
$privUser->id = $userId;
$privUser->login = $result[0]['username'];
$privUser->password = $result[0]["password_hash"];
$privUser->email = $result[0]["email"];
$privUser->initRoles();
return $privUser;
} else {
return false;
}
}
