Untitled

<?php
require_once('lib.php');
$dbh = connect_db('test');

// 検索文字列
$query = "";
if(array_key_exists('query', $_GET)) {
    $query = $_GET['query'];
}
// ページ番号
$page = 0;
if(array_key_exists('page', $_GET) && is_numeric($_GET['page'])) {
    $page = $_GET['page'];
}

$stmt = $dbh->prepare("
    SELECT id, created_at, message
    FROM messages
    WHERE message LIKE :like
    ORDER BY created_at DESC
    LIMIT :page, 10");
$stmt->bindValue(':page', $page * 10,     PDO::PARAM_INT);
$stmt->bindValue(':like', '%'.$query.'%', PDO::PARAM_STR);
$stmt->execute();
// $stmt->execute(array(
//     ':page' => $page,
//     ':like' => '%'.$query.'%'
// ));

$results = $stmt->fetchAll(PDO::FETCH_ASSOC);

?><!DOCTYPE html>
<head>
<meta charset="utf-8">
</head>
<body>
    <h1>簡単掲示板</h1>
    <form method="post" action="submit.php">
        <input type="text" name="message" size="30">
        <button>投稿</button>
    </form>
    <hr>
    <form method="get" action="message.php">
        <input type="text" name="query" size="30" value="<?= $query ?>">
        <button>メッセージを検索</button>
    </form>
    <hr>
    <?php foreach($results as $result) : ?>
    <div>
        <b>[<?= $result['id'] ?>]</b><span><?= $result['message'] ?></span> at <span><?= $result['created_at'] ?></span>
    </div>
    <?php endforeach; ?>
    <a href="message.php?page=<?= $page+1 ?>"><button>次の10件</button></a>
    <hr>
    <form method="post" action="delete_message.php">
        <input type="number" name="id" size="4">
        <button>指定したIDのメッセージを削除</button>
    </form>
</body>
</html>