How to page using FluentPDO

[klebinhopk]

Is it possible to create a paging function in a query with FluentPDO today?

For example:

[adam-buckley]

There's no (as far as I know) paginate helper functions in Fluent, the way we achieve pagination is to use the offset and limit functions, which is how you'd do it when writing SQL:

// $page must be 1 or larger
$your_fluent_query->offset(($page - 1) * $page_size)->limit($page_size)->fetchAll();