Pagination in PHQL query

Question

Pagination in PHQL query

Sergey Mukhin Dec '19

Created Dec '19	Last Reply Feb '20	Replies 1	Views 247	Votes 0

Sergey Mukhin 4.2k

Dec '19

Hi, I need to use PHQL query, but I also want to use pagination.

example

$phql = "SELECT p.*  FROM Models\Products AS p ";
$products = \Phalcon\DI::getDefault()->get('modelsManager')->createQuery($phql);

doesn't work like that

$paginator = new Phalcon\Paginator\Adapter\QueryBuilder (
            [
                'builder' => $productsData,
                'limit'   => $limit,
                'page'    => $page,
            ]
        );

Is it possible? any thoughts?

Tomasz Zadora · Answer 1 · 2019-12-09T02:58:11-07:00

AFAIK this:

$products = \Phalcon\DI::getDefault()->get('modelsManager')->createQuery($phql);

is creating object of Query class not QueryBuilder class which is needed by Paginator, You need to execute createBuilder method on modelsManager.

Sergey Mukhin · Answer 2 · 2019-12-09T03:06:26-07:00

I just used a query using createBuilder(). But now I need an analog pagination for createQuery(). therefore I ask whether this is possible?

AFAIK this:
$products = \Phalcon\DI::getDefault()->get('modelsManager')->createQuery($phql);
is creating object of Query class not QueryBuilder class which is needed by Paginator, You need to execute createBuilder method on modelsManager.