public function getAllAsObject($restriction = '') { $sql = "SELECT * \n\t\t\t FROM schueler \n\t\t\t WHERE 1=1 "; $sql .= $restriction . " "; $sql .= " ORDER BY nachname;"; try { $result = mysql_query($sql); if (!$result) { throw new MysqlException(); } $schuelers = array(); while ($row = mysql_fetch_assoc($result)) { $s = new Schueler(); $s->setId($row['schueler_id']); $s->setVorname($row['vorname']); $s->setNachname($row['nachname']); $s->setUser_id($row['user_id']); $s->setAktiv($row['aktiv']); $s->setKlasse_id($row['klasse_id']); $s->setBeschreibung($row['beschreibung']); $schuelers[$s->getId()] = $s; } } catch (MysqlException $e) { Html::showAll($e); } return $schuelers; }