Question on the request in the construction of the pagination

Question

Question on the request in the construction of the pagination

abasov90 Jul '13

Created Jul '13	Last Reply Jul '13	Replies 0	Views 596	Votes 1

abasov90 11.9k

Jul '13

$users = Users::find(array(
            "order" => "id"
));

$paginator = new \Phalcon\Paginator\Adapter\Model(
            array(
                "data" => $users,
                "limit"=> 10,
                "page" => $currentPage
            )
        );

A query of the form:

```sql
SELECT `users`.`id`, `users`.`role`, `users`.`firstname`, `users`.`lastname`, `users`.`email`, `users`.`birthday`, `users`.`sex`, `users`.`username`, `users`.`password`, `users`.`logins`, `users`.`last_login` FROM `users` ORDER BY `users`.`id`

That is no limit to automatically request does not exhibit. Do I need to put in your hand limit? If I have 100,000 users in the database...

1

abasov90 · Answer 1 · 2013-07-20T05:36:50-07:00

$builder = $this->modelsManager->createBuilder()
            ->from('Phcms\Common\Models\Users')
            ->orderBy('id');

        $paginator = new \Phalcon\Paginator\Adapter\QueryBuilder(array(
            "builder" => $builder,
            "limit"=> 10,
            "page" => 1
        ));

:((

Soufiane Ghzal · Answer 2 · 2013-07-20T12:59:12-07:00

You may use "edit" function of the forum... ;)

All is there : https://docs.phalcon.io/en/latest/reference/pagination.html

Limit means, how much user you want per page. Then if you have 100 000 users in your DB you will have 10 000 pages