如何在php中组合分页和过滤？

$sql = "SELECT * FROM table_name WHERE 1=1";
if (!empty($keyword)) {
    $sql .= " AND column_name LIKE '%$keyword%'";
}
if (!empty($category)) {
    $sql .= " AND category = '$category'";
}
// 其他过滤条件的拼接

$totalRecords = mysqli_num_rows($result);

$perPage = 10; // 每页显示的记录数
$currentpage = isset($_GET['page']) ? $_GET['page'] : 1; // 当前页码，默认为第一页

$totalPages = ceil($totalRecords / $perPage); // 总页数
$startFrom = ($currentpage - 1) * $perPage; // 起始记录位置

$sql .= " LIMIT $startFrom, $perPage";

$result = mysqli_query($conn, $sql);

$pagination = '';
if ($totalPages > 1) {
    $pagination .= '<ul class="pagination">';
    for ($i = 1; $i <= $totalPages; $i++) {
        if ($i == $currentpage) {
            $pagination .= '<li class="active"><a href="#">' . $i . '</a></li>';
        } else {
            $pagination .= '<li><a href="?page=' . $i . '">' . $i . '</a></li>';
        }
    }
    $pagination .= '</ul>';
}
echo $pagination;