list items per page and pagination

Hi Igor,

So to clarify, one your first page, you want to display 20 items, and then you want to display 10 items on each page after. Is that right?

One options would be, instead of using perPage, use the limit and offset options.

For example, if $_REQUEST['page'] = 1 or has no value, you would use:
offset => 0,
limit => 20

If the page is greater than 1, you would use
offset => $page * 10,
limit => 10,

Hope this helps get you started.

no no, 20 items on every page. First ten with more detail, and other ten with just title. But on second page, first ten with more detail should be the one that were just title on previous page.

Hi Igor,

Sure, you will have to use the offset & limit method. You can set your offset variable like this:

$page = intval(@$_REQUEST['page']);
$offset = (($page - 1) * 10) - 1;
if ($offset < 0) { $offset = 0;}

list ($articleRecords, $articleMetaData) = getRecords(array(
'tableName' => 'articles',
'allowSearch' => false,
'offset' => $offset,
'limit' => 20,
));

The one issue here is that if you look at the metaData variable, you won't have the page numbers and prevPageLink/nextPageLink automatically generated for you. You will have access to totalRecords, pageResultsStart, and pageResultsEnd. You'll have to manually create your links that include the page numbers.

Hope this helps get you started.