/** * Gets all inactive Users and returns an array of Userobjects * @return array */ public function getAllInactiveUsers() { $sql = new Sql($this->dbAdapter); $select = $sql->select('tbluser'); $select->where('freigeschaltet = 0')->order('timestamp ASC'); $stmt = $sql->prepareStatementForSqlObject($select); $result = $stmt->execute(); if ($result instanceof ResultInterface && $result->isQueryResult() && $result->getAffectedRows()) { $array = array(); $user = new User(); $user->exchangeArray($result->current()); array_push($array, $user); // Minus 1 Because we already pushed 1 UserObject into the Array for ($count = $result->count() - 1; $count > 0; $count--) { $user = new User(); $user->exchangeArray($result->next()); array_push($array, $user); } return $array; } }
/** * Get current User as Object * @param int $id * @return User */ protected function getUser($id) { $sql = new Sql($this->dbAdapter); $select = $sql->select('tbluser'); $select->where(array('id = ?' => $id)); $stmt = $sql->prepareStatementForSqlObject($select); $result = $stmt->execute(); $user = new User(); $user->exchangeArray($result->current()); return $user; }