PHP とりあえず全件出力

PHP_切り出し PHP PHP_とりあえず

index.php

-----

<?php

define('DB_HOST', 'localhost');
define('DB_USER', 'dbuser');
define('DB_PASSWORD', 'U8df76d');
define('DB_NAME', 'dotinstall_paging_php');

ini_set('display_errors', 1);

try {
$dbh = new PDO
('mysql:host='. DB_HOST. ';dbname='. DB_NAME,DB_USER,DB_PASSWORD);
} catch (PDOException $e){
echo $e->getMessage();
exit;
}

// 全件抽出
$sql = "select * from comments";
$comments = array();
foreach($dbh->query($sql) as $row) {
array_push($comments, $row);
}

//var_dump($comments);

?>

<!DOCTYPE html>
<html lang="ja">
<head>
<meta charset="utf-8">
<title>コメント一覧</title>
</head>

<body>
<h1>コメント一覧</h1>
<?php foreach ($comments as $come): ?>
<li><?php echo htmlspecialchars($come['comment'],ENT_QUOTES, 'UTF-8'); ?></li>
<?php endforeach; ?>
</body>
</html>