一覧へ戻る
select.php
<?php
require_once __DIR__ . '/dbconnect.php';
$sql = 'SELECT id, name, size, memo FROM animal ORDER BY id';
$stmt = $dbh->query($sql);
$animals = $stmt->fetchAll();
?>
<!DOCTYPE html>
<html lang="ja">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<title>データ一覧 PDO版</title>
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.8/dist/css/bootstrap.min.css" rel="stylesheet">
</head>
<body>
<div class="container my-4">
<h1>データ一覧</h1>
<p><a href="index.html">トップページへ戻る</a></p>
<table class="table table-bordered table-striped">
<thead>
<tr><th>id</th><th>name</th><th>size</th><th>memo</th></tr>
</thead>
<tbody>
<?php foreach ($animals as $animal): ?>
<tr>
<td><?= h((string)$animal['id']) ?></td>
<td><?= h($animal['name']) ?></td>
<td><?= h((string)$animal['size']) ?></td>
<td><?= h($animal['memo']) ?></td>
</tr>
<?php endforeach; ?>
</tbody>
</table>
</div>
</body>
</html>