pagination problem

Question

pagination problem

geass Oct '13

Created Oct '13	Last Reply May '14	Replies 3	Views 2526	Votes 1

geass 39.3k

Oct '13

when i want to paginate from query builder i got an error on below

Fatal error: Phalcon\Paginator\Adapter\QueryBuilder::getPaginate() [<a href='phalcon\paginator\adapter\querybuilder.getpaginate'>phalcon\paginator\adapter\querybuilder.getpaginate</a>]: Call to undefined method limit() on class Phalcon\Mvc\Model\Resultset\Simple in C:\wamp\www\popsbuy\app\controllers\OrdersController.php on line 65

My Code:

$orders = $order->getUserOrders(); 

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

// Get the paginated results
$page = $paginator->getPaginate();

1

geass · Answer 1 · 2013-10-29T07:07:01-07:00

İ solve the problem , its cuz of after createBuilder i add execute()

Thanks

Now another problem i want to learn is , when pagination is there any feature about get page numbers ?

i mean in codeigniter etc we can set the page numbers and when add it on page it is:

<<back 1 2 3 ... 8 9 10 next>>

Can i do that ?

Phalcon · Answer 2 · 2013-10-29T13:19:22-07:00

Phalcon
98.9k

Oct '13

The paginator does not have a feature like the one you are describing.

Maxim Borzov · Answer 3 · 2013-11-25T11:51:58-07:00

I use this simple method in Volt:

<ul class="pager">
    {% for index in 1..page.total_pages %}
        <li>{{ link_to("/list?page=" ~ index, index) }}</li>
    {% endfor %}
</ul>

Londomloto · Answer 4 · 2014-05-26T05:45:01-07:00

how to achieve pagination feature like displaying information (ex: display 5 to 10 from 100 rows). thx. I can't get totals based on conditions and limit. (in mysql: select SQL_CALC_FOUND_ROWS a, b from c where name like 'a%' limit 10)