/** * @param int $userId * @return UserProfileViewModel * @throws \Exception */ public function getUserInfo(int $userId) : UserProfileViewModel { $db = Database::getInstance('app'); $result = $db->prepare("SELECT id, username, password, fullname FROM users WHERE id = ?"); $result->execute([$userId]); $userRow = $result->fetch(); $user = new UserProfileViewModel(); $user->setId($userRow["id"])->setUsername($userRow["username"])->setFullName($userRow["fullname"]); return $user; }