public function loadByID($userID) { global $DB; $stat = $DB->prepare("SELECT user_account_information.* FROM user_account_information WHERE id =:id"); $stat->execute(array('id' => $userID)); if ($stat->rowCount() > 0) { $user = new UserAccountModel(); $user->setFromDataBaseRow($stat->fetch()); return $user; } }
public function loadByOwnerOfCuratedList(CuratedListModel $curatedList) { global $DB; $stat = $DB->prepare("SELECT user_account_information.* FROM user_account_information " . " JOIN user_in_curated_list_information ON user_in_curated_list_information.user_account_id = user_account_information.id " . "WHERE user_in_curated_list_information.curated_list_id = :id AND user_in_curated_list_information.is_owner = 't'"); $stat->execute(array('id' => $curatedList->getId())); if ($stat->rowCount() > 0) { $user = new UserAccountModel(); $user->setFromDataBaseRow($stat->fetch()); return $user; } }
public function fetchAll() { $this->buildStart(); $this->build(); $this->buildStat(); $results = array(); while ($data = $this->stat->fetch()) { $event = new UserAccountModel(); $event->setFromDataBaseRow($data); $results[] = $event; } return $results; }