public static function getById($id) { /** * @var $userdb \PDO */ global $userdb; $stmt = $userdb->prepare("SELECT `id`, `name`, `username`, `email`, `password` FROM jos_users WHERE `id` = :user_id"); $stmt->bindParam(':user_id', $id); $stmt->execute(); $userData = $stmt->fetch(\PDO::FETCH_ASSOC); $user = new self(); $user->setIsNew(false); $user->setId($userData['id']); $user->setName($userData['name']); $user->setUsername($userData['username']); $user->setEmail($userData['email']); $user->setPasswordHash($userData['password']); return $user; }