tabelle ." WHERE tnummer=:tnummer"; if ($stmt = $pdo -> prepare($sql)) { $stmt->bindParam(':tnummer', $id); $stmt -> execute(); return($stmt->fetch(PDO::FETCH_ASSOC)); } return(false); } public function loeschen($id) { require("db.inc.php"); $sql = "DELETE FROM " .$this->tabelle ." WHERE tnummer = :tnummer"; if ($stmt = $pdo -> prepare($sql)) { $stmt->bindParam(':tnummer', $id); $stmt -> execute(); } } public function anlegen() { require("db.inc.php"); $tnummer = NULL; $name = $_POST["name"]; $vname = $_POST["vname"]; $plz = $_POST["plz"]; $ort = $_POST["ort"]; $strasse = $_POST["strasse"]; $hausnr = $_POST["hausnr"]; $telefon1 = $_POST["telefon1"]; $telefon2 = $_POST["telefon2"]; $email = $_POST["email"]; /* $sql = "INSERT INTO " .$this->tabelle ." ( tnummer, name, vname, plz, ort, strasse, hausnr, telefon1, telefon2, email) VALUES ( :tnummer, :name, :vname, :plz, :ort, :strasse, :hausnr, :telefon1, :telefon2, :email)"; if ($stmt = $pdo -> prepare($sql)) { $param = array( ':tnummer' => $tnummer, ':name' => $name, ':vname'=>$vname, ':plz'=>$plz, ':ort'=>$ort, ':strasse'=>$strasse, ':hausnr'=>$hausnr, ':telefon1'=>$telefon1, ':telefon2'=>$telefon2, ':email'=> $email); */ $sql = "INSERT INTO " .$this->tabelle ." ( tnummer, name, vname, plz, ort, strasse, hausnr, telefon1, telefon2, email) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"; if ($stmt = $pdo -> prepare($sql)) { $param = array($tnummer, $name, $vname, $plz, $ort, $strasse, $hausnr, $telefon1, $telefon2, $email); if($stmt -> execute($param)) { echo "

Datensatz erfolgreich gespeichert!

\n"; } else { echo "

Fehler beim Speichern!

\n"; } } } public function bearbeiten() { require("db.inc.php"); $tnummer = $_POST["mode"]; $name = $_POST["name"]; $vname = $_POST["vname"]; $plz = $_POST["plz"]; $ort = $_POST["ort"]; $strasse = $_POST["strasse"]; $hausnr = $_POST["hausnr"]; $telefon1 = $_POST["telefon1"]; $telefon2 = $_POST["telefon2"]; $email = $_POST["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 tnummer = :tnummer"; if ($stmt = $pdo -> prepare($sql)) { $param = array( ':tnummer' => $tnummer, ':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 lesenAlleDaten() { $sql = "SELECT tnummer, name, vname, plz, ort, strasse, hausnr, telefon1, telefon2, email FROM " .$this->tabelle ." ORDER BY name"; $this->baueTeilnehmerTabelle($sql); } /*public function suchen() { $sql = "SELECT tnummer, name, vname, plz, ort, strasse, hausnr, telefon1, telefon2, email FROM " .$this->tabelle ." WHERE"; $count = 0; foreach($_POST As $feld => $wert) { if(!empty($wert)) { if($count > 0) { $sql = $sql ." AND "; } $count += 1; $sql = $sql ." " .$feld ." LIKE '%" .$wert ."%'"; } } $sql = $sql ." ORDER BY name"; $this->baueTeilnehmerTabelle($sql); } */ public function suchen() { $sql = "SELECT tnummer, name, vname, plz, ort, strasse, hausnr, telefon1, telefon2, email FROM $this->tabelle WHERE"; $count = 0; foreach ($_POST as $index => $wert) { if (!empty($wert)) { if ($count > 0) { $sql .= " AND "; } $count++; $sql .= " $index LIKE '%".$wert."%'"; } } $sql .= "ORDER BY tnummer"; //echo $sql; $this->baueteilnehmertabelle($sql); } private function baueTeilnehmerTabelle($sql) { require_once("db.inc.php"); if ($stmt = $pdo -> prepare($sql)) { $stmt -> execute(); echo "\n\t"; echo ""; echo "\n\t"; $count = 0; while ($z = $stmt -> fetch()) { //echo "

", print_r($z), "

"; $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['tnummer']) ."	" . 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"; } } } ?>