index.php
<?php
try {
$pdo = new PDO('mysql:host=localhost;dbname=db이름','root','db비번');
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$sql = 'SELECT `joketext` FROM `joke`';
$result = $pdo->query($sql);
while ($row = $result->fetch()) {
$jokes[] = $row['joketext'];
}
$title = '유머 글 목록';
$output = '';
foreach ($jokes as $joke) {
$output .= '<blockquote>';
$output .= '<p>';
$output .= $joke;
$output .= '</p>';
$output .= '</blockquote>';
}
}
catch (PDOException $e) {
$title = '오류가 발생했습니다';
$output = '데이터베이스 오류: ' . $e->getMessage() . ', 위치: ' .
$e->getFile() . ':' . $e->getLine();
}
include __DIR__ . '/../templates/layout.html.php';
layout.html.php
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<link rel="stylesheet" href="jokes.css">
<title><?=$title?></title>
</head>
<body>
<header>
<h1>인터넷 유머 세상</h1>
</header>
<nav>
<ul>
<li><a href="index.php">Home</a></li>
<li><a href="jokes.php">유머 글 목록</a></li>
</ul>
</nav>
<main>
<?=$output?>
</main>
<footer>
© IJDB 2017
</footer>
</body>
</html>
댓글