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;
}
