tabelle . " WHERE doznr = :doznr"; if ($stmt = $pdo->prepare ( $sql )) { $stmt->bindParam ( ':doznr', $id ); $stmt->execute (); } } public function anlegen($felder) { require ("db.inc.php"); $doznr = NULL; $name = $felder ["name"]; $vname = $felder ["vname"]; $plz = $felder ["plz"]; $ort = $felder ["ort"]; $strasse = $felder ["strasse"]; $hausnr = $felder ["hausnr"]; $telefon1 = $felder ["telefon1"]; $telefon2 = $felder ["telefon2"]; $email = $felder ["email"]; $sql = "INSERT INTO " . $this->tabelle . " (doznr, name, vname, plz, ort, strasse, hausnr, telefon1, telefon2, email) VALUES ( :doznr, :name, :vname, :plz, :ort, :strasse, :hausnr, :telefon1, :telefon2, :email)"; if ($stmt = $pdo->prepare ( $sql )) { $param = array ( ':doznr' => $doznr, ':name' => $name, ':vname' => $vname, ':plz' => $plz, ':ort' => $ort, ':strasse' => $strasse, ':hausnr' => $hausnr, ':telefon1' => $telefon1, ':telefon2' => $telefon2, ':email' => $email ); if ($stmt->execute ($param)) { echo "

Datensatz erfolgreich gespeichert!

\n"; } else { echo "

Fehler beim Speichern!

\n"; } } } public function bearbeiten($felder) { require ("db.inc.php"); $doznr = $felder ["mode"]; $name = $felder ["name"]; $vname = $felder ["vname"]; $plz = $felder ["plz"]; $ort = $felder ["ort"]; $strasse = $felder ["strasse"]; $hausnr = $felder ["hausnr"]; $telefon1 = $felder ["telefon1"]; $telefon2 = $felder ["telefon2"]; $email = $felder ["email"]; $sql = "UPDATE ". $this->tabelle . " SET name = :name, vname = :vname, plz = :plz, ort = :ort, strasse = :strasse, hausnr = :hausnr, telefon1 = :telefon1, telefon2 = :telefon2, email = :email WHERE doznr = :doznr"; if ($stmt = $pdo->prepare ( $sql )) { $param = array ( ':doznr' => $doznr, ':name' => $name, ':vname' => $vname, ':plz' => $plz, ':ort' => $ort, ':strasse' => $strasse, ':hausnr' => $hausnr, ':telefon1' => $telefon1, ':telefon2' => $telefon2, ':email' => $email); if ($stmt->execute ($param)) { echo "

Datensatz erfolgreich gespeichert!

\n"; } else { echo "

Fehler beim Speichern!

\n"; } } } public function lesenDatensatz($id) { require ("db.inc.php"); if ($stmt = $pdo->prepare ( "SELECT name, vname, plz, ort, strasse, hausnr, telefon1, telefon2, email FROM " . $this->tabelle . " WHERE doznr=:doznr" )) { $stmt->bindParam ( ':doznr', $id ); $stmt->execute (); return ($stmt ->fetch(PDO::FETCH_ASSOC)); } else { return false; } } public function lesenAlleDaten() { require_once ("db.inc.php"); if ($stmt = $pdo->prepare ( "SELECT doznr, name, vname, plz, ort, strasse, hausnr, telefon1, telefon2, email FROM " . $this->tabelle . " ORDER BY name" )) { $stmt->execute (); echo "\n\t"; echo ""; echo "\n\t"; $count = 0; while ( $z = $stmt->fetch () ) { $count += 1; $zebratyp = "ungerade"; echo "\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n"; } echo "\n

Nummer	Name	Vorname	Plz	Ort	Straße	Haus-Nr.	Telefon 1	Telefon 2	E-Mail	Bearbeiten
" . htmlspecialchars ( $z['doznr']) . "	" . htmlspecialchars ( $z['name']) . "	" . htmlspecialchars ( $z['vname'] ) . "	" . htmlspecialchars ( $z['plz']) . "	" . htmlspecialchars ( $z['ort'] ) . "	" . htmlspecialchars ( $z['strasse']) . "	" . htmlspecialchars ( $z['hausnr'] ) . "	" . htmlspecialchars ( $z['telefon1']) . "	" . htmlspecialchars ( $z['telefon2'] ) . "	" . htmlspecialchars ( $z['email'] ) . "	" . "bearbeiten" . "

\n"; } } } ?>