mirror of
https://github.com/janunger/rheinwerk-video-training.git
synced 2024-12-22 12:43:42 +01:00
40 lines
735 B
PHP
40 lines
735 B
PHP
|
<?php
|
||
|
|
|
||
|
|
$pdo = new PDO(
|
||
|
|
'mysql:dbname=mediathek;host=localhost',
|
||
|
|
'root',
|
||
|
|
'root',
|
||
|
|
[
|
||
|
|
PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8"
|
||
|
|
]
|
||
|
|
);
|
||
|
|
|
||
|
|
$statement = $pdo->query("SELECT * FROM cds ORDER BY name ASC");
|
||
|
|
|
||
|
|
?>
|
||
|
|
<!DOCTYPE html>
|
||
|
|
<html lang="en">
|
||
|
|
<head>
|
||
|
|
<meta charset="UTF-8">
|
||
|
|
<title>Mediathek</title>
|
||
|
|
</head>
|
||
|
|
<body>
|
||
|
|
|
||
|
|
<h1>CDs</h1>
|
||
|
|
|
||
|
|
<table>
|
||
|
|
<tr>
|
||
|
|
<th>Name</th>
|
||
|
|
<th>Erscheinungsjahr</th>
|
||
|
|
</tr>
|
||
|
|
<?php while ($datensatz = $statement->fetch(PDO::FETCH_ASSOC)) : ?>
|
||
|
|
<tr>
|
||
|
|
<td><?= htmlspecialchars($datensatz['name']); ?></td>
|
||
|
|
<td><?= htmlspecialchars($datensatz['erscheinungsjahr']); ?></td>
|
||
|
|
</tr>
|
||
|
|
<?php endwhile; ?>
|
||
|
|
</table>
|
||
|
|
|
||
|
|
</body>
|
||
|
|
</html>
|