Example #1
0
 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;
 }