<!DOCTYPE html>
<html lang="de">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Datenbankausgabe</title>
<link rel="stylesheet" href="style.css">
</head>
<body>
<table>
<tr>
<th>Klausur_ID</th>
<th>Datum</th>
<th>Thema</th>
<th>Lernfeld</th>
<th>Fachlehrer</th>
<th>K_ID</th>
</tr>
<?php
$neuKlausur = array();
$neuKlausur["Datum"] = $_GET["Datum"];
$neuKlausur["Thema"] = $_GET["Thema"];
$neuKlausur["Lernfeld"] = $_GET["Lernfeld"];
$neuKlausur["Fachlehrer"] = $_GET["Fachlehrer"];
$neuKlausur["K_ID"] = $_GET["K_ID"];
require_once("db_verbindung.php");
$statement = $pdo->prepare("INSERT INTO Klausur (Klausur_ID, Datum, Thema, Lernfeld, Fachlehrer, K_ID)
VALUES (NULL, :Datum, :Thema, :Lernfeld, :Fachlehrer, :K_ID)");
$statement->execute($neuKlausur);
$sql = 'SELECT * FROM Klausur';
foreach ($pdo->query($sql) as $row) {
echo'<tr><td>'. $row['Klausur_ID']
.'</td><td>'. $row['Datum']
.'</td><td>'. $row['Thema']
.'</td><td>'. $row['Lernfeld']
.'</td><td>'. $row['Fachlehrer']
.'</td><td>'. $row['K_ID']
.'</td></tr>';
}
echo "</table>";
?>
</body>
</html>
