public function getAllAsObject($restriction = '')
{
$sql = "SELECT * \n\t\t\t FROM lehrer \n\t\t\t WHERE 1=1 ";
$sql .= $restriction . ";";
try {
$result = mysql_query($sql);
if (!$result) {
throw new MysqlException();
}
$lehrers = array();
while ($row = mysql_fetch_assoc($result)) {
$l = new Lehrer();
$l->setId($row['lehrer_id']);
$l->setUser_id($row['user_id']);
$l->setVorname($row['vorname']);
$l->setNachname($row['nachname']);
$l->setAktiv($row['aktiv']);
$lehrers[$l->getId()] = $l;
}
} catch (MysqlException $e) {
Html::showAll($e);
}
return $lehrers;
}
