<?php
//위치: public/index.php
//index.php
try {
$pdo = new PDO('mysql:host=localhost;dbname=데이터베이스이름','root','DB비번');
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$sql = 'SELECT `컬럼이름` FROM `테이블이름`';
$result = $pdo->query($sql);
while ($row = $result->fetch()) {
$jokes[] = $row['컬럼이름'];
}
}
catch (PDOException $e) {
$output = '데이터베이스 서버에 접속할 수 없습니다: ' . $e->getMessage() . ', 위치: ' .
$e->getFile() . ':' . $e->getLine();
}
include __DIR__ . '/../templates/jokes.html.php';
<!--위치: templates/jokes.html.php
jokes.html.php
-->
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>유머 글 목록</title>
</head>
<body>
<?php if (isset($error)): ?>
<p>
<?php echo $error; ?>
</p>
<?php else: ?>
<?php foreach ($jokes as $joke): ?>
<blockquote>
<p>
<?php echo htmlspecialchars($joke, ENT_QUOTES, 'UTF-8') ?>
</p>
</blockquote>
<?php endforeach; ?>
<?php endif; ?>
</body>
</html>
댓글