使用PDO MySQL -SQLSTATE[42000]进行PHP搜索和分页:语法错误

<?php
// PDO连接配置
$host = 'localhost';
$dbname = 'database';
$username = 'username';
$password = 'password';

// 创建PDO实例
try {
    $pdo = new PDO("mysql:host=$host;dbname=$dbname", $username, $password);
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch (PDOException $e) {
    echo "数据库连接失败：" . $e->getMessage();
    exit();
}

// 搜索关键词
$keyword = $_GET['keyword'];

// 查询总记录数
$stmt = $pdo->prepare("SELECT COUNT(*) FROM table WHERE column LIKE :keyword");
$stmt->bindValue(':keyword', "%$keyword%", PDO::PARAM_STR);
$stmt->execute();
$totalRows = $stmt->fetchColumn();

// 分页参数
$perPage = 10;
$totalPages = ceil($totalRows / $perPage);
$page = isset($_GET['page']) ? intval($_GET['page']) : 1;
$offset = ($page - 1) * $perPage;

// 查询数据
$stmt = $pdo->prepare("SELECT * FROM table WHERE column LIKE :keyword LIMIT :offset, :perPage");
$stmt->bindValue(':keyword', "%$keyword%", PDO::PARAM_STR);
$stmt->bindValue(':offset', $offset, PDO::PARAM_INT);
$stmt->bindValue(':perPage', $perPage, PDO::PARAM_INT);
$stmt->execute();
$results = $stmt->fetchAll(PDO::FETCH_ASSOC);

// 输出搜索结果
foreach ($results as $row) {
    echo $row['column'];
    // 其他字段...
}

// 输出分页链接
for ($i = 1; $i <= $totalPages; $i++) {
    echo "<a href='?keyword=$keyword&page=$i'>$i</a> ";
}
?>