getMessage());
}
$tnummer = 5;
$sql = "SELECT * FROM teilnehmer WHERE tnummer= :tnummer";
$pdo->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
if ($stmt = $pdo->prepare($sql)) {
$stmt->bindParam(':tnummer',$tnummer);
$stmt->execute();
while ($zeile = $stmt->fetch(PDO::FETCH_ASSOC)) {
echo "Teilnehmernummer: " .$zeile ['tnummer'] . "
";
echo "Name: " .$zeile ['name'] . "
";
echo "Vorname " .$zeile ['vname'] . "
";
echo "Ort: " .$zeile ['ort'] . "
";
}
}
?>