StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POZend Paginator: Show pagination links without loading(NON-DB) data
primarykey
Id
20834823
data
AcceptedAnswerId
20901010
AnswerCount
1
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2013-12-30T06:59:29.707
FavoriteCount
0
LastActivityDate
2014-01-03T10:02:19.730
LastEditDate
2013-12-30T12:20:42.053
LastEditorUserId
582603
OwnerUserId
582603
ParentId
0
PostTypeId
1
Score
1
ViewCount
468
LastEditorDisplayName
text
Body
I am using a service which fetches results and total number of results present for the filters in one shot. Elaborating more, suppose there are total 100,000 records and I am showing 25 records on one page. I have an array having: <pre><code>$myarr = array('totalCount' => 100000, 'results' => array(...data...)); </code></pre> This data is limited to 25 records in one go. PROBLEM : When sending this data to zend_paginator it's showing only 1 page(anchor) with prev[disabled] & next[disabled]. According to code its working fine but how to show other paginating anchors[2,3,4,5,6,7,8,9] etc. as I know total counts of data. I researched long for this but every where solutions are for DB queries and I don't get this result from DB, its from a service resulting in XML format which is converted to an array. <pre><code>$paginator = new Zend_Paginator(new Zend_Paginator_Adapter_Array($myarr ['results'])); $paginator->setItemCountPerPage(25); $paginator->setPageRange(10); $paginator->setCurrentPageNumber(1); </code></pre> How can I send total count so that it creates other paginating links without loading all data as I received a Memory Exhaust fatal error because of loading 100,000 records & it also looks unoptimized way of fetching all records every time for showing just 25 records when I have TOTAL COUNT in every service request. pagination.phtml: <pre><code><div class="pagination" >  <?php if (isset($this->previous)): ?> <a href="javascript:void(0)" onclick='fetchPaginationData("<?php echo $this->divid;?>","<?php echo $this->url(array('page' => $this->firstPageInRange -1)); ?>")'>Prev</a> <?php else: ?> Prev <?php endif; ?>  <?php foreach ($this->pagesInRange as $page): ?> <?php if ($page != $this->current): ?> <a href="javascript:void(0);" onclick='fetchPaginationData("<?php echo $this->divid;?>","<?php echo $this->url(array('page' => $page)); ?>")' ><?php echo $page; ?></a> <?php else: ?> <?php echo $page; ?> <?php endif; ?> <?php endforeach; ?>  <?php if (isset($this->next)): ?> <a href="javascript:void(0);" onclick='fetchPaginationData("<?php echo $this->divid;?>","<?php echo $this->url(array('page' => $this->lastPageInRange +1)); ?>")'>Next &gt;</a> <?php else: ?> Next <?php endif; ?> </code></pre> 
Tags
<php><zend-framework><pagination><zend-paginator>
Title
Zend Paginator: Show pagination links without loading(NON-DB) data
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USAakash Sahai
UserOwnerUserId
1. USAakash Sahai
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. COI dont have a proper solution for this issue. But there is definitely a workaround. You can provide the user with a `Previous` and `Next` button for pagination.
 singulars
 PostPostId
 POZend Paginator: Show pagination links without loading(NON-DB) data
 UserUserId
 USNandakumar V

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.