StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
12744618
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2012-10-05T10:48:18.457
FavoriteCount
0
LastActivityDate
2012-10-05T10:48:18.457
LastEditDate
LastEditorUserId
0
OwnerUserId
1145086
ParentId
12725557
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
text
Body
I noticed you set <code>index.phtml</code> as your default view partial, to misquote a quote ... I don't think that method does what you think it does. At least in the beginning I suggest you specify everything. Specify the select(), specify the adapter, create a new paginator. Later you can take the short cuts. <pre><code>public function indexAction(){ $params = array('host' =>'localhost', 'username' =>'root', 'password' =>'', 'dbname' =>'test' ); $db = new Zend_Db_Adapter_Pdo_Mysql($params); $select = $db->select()->from('tableviewdemo'); //specify paginator adapter $adapter = new Zend_Paginator_Adapter_DbTableSelect($select); //instantiate the paginator $paginator = new Zend_Paginator($adapter); //if you really have to use the factory, don't forget the string for the adapter. //The paginator should work without the string, but may not work as expected. //$paginator = Zend_Paginator::factory($select, 'DbTableSelect'); $paginator->setCurrentPageNumber($this->_getParam('page', 1)); $paginator->setItemCountPerPage(10); //assign paginator to the view $this->view->paginator=$paginator; } </code></pre> A note on adapters. The biggest apparent difference between the adapters <code>Zend_Paginator_Adapter_DbTable</code> and <code>Zend_Paginator_Adapter_DbTableSelect</code> is that DbTable returns an aray will use the array notation <code>$item['name']</code> and DbTableSelect returns an object (rowset object) uses object notation `$item->name' so use the adapter appropriate to your needs. To get back to my original point. The default view partial does not refer the page you want displayed. It refers to the view partial that contains the controls for your paginator. Zend does not have a default implementation of pagination controls just an <a href="http://framework.zend.com/manual/1.12/en/zend.paginator.usage.html#zend.paginator.usage.rendering.example-controls" rel="nofollow">example</a>. Try this in your view. <pre><code>  <table border=1> <?php foreach ($this->paginator as $item) : ?> <tr> <td><?php echo $this->escape($item->id) ?></td> <td><?php echo $this->escape($item->name) ?></td> <td><?php echo $this->escape($item->city) ?></td> <td><?php echo $this->escape($item->state) ?></td> <td><?php echo $this->escape($item->date) ?></td> <td><?php echo $this->escape($item->zip) ?></td> </tr> </table> <?php endForeach ?> <?php echo $this->paginationControl($this->paginator,'Sliding','MyPaginatorControl.phtml'); ?> </code></pre> The paginator I typically use is very similar to the example in the manual, I call it in my view script (the default location for all partial views is <code>views/scripts</code>) : <pre><code><?php echo $this->paginationControl( //remember the third parameter is the controls partial $this->paginator, 'Sliding', '_paginatorControl.phtml' ) ?> </code></pre> Just in case someone needs it here is my basic control partial: <pre><code>//views/scripts/_paginatorControl.phtml. Yes. I just copy this file to where ever I need it. <?php if ($this->pageCount) : //you need to add each of the request parameters to url $params = Zend_Controller_Front::getInstance() ->getRequest()->getParams(); //remove the system parameters unset($params['module']); unset($params['controller']); unset($params['action']); ?> <div class="paginationControl"> <table> <tr> <td>  <?php if (isset($this->first)): ?> <a href="<?php echo $this->url(array_merge($params, array('page' => $this->first))) ?>"> &lt; First</a> <?php else : ?> &lt; First <?php endif ?> </td> <td class="space">|</td> <td>  <?php if (isset($this->previous)) : ?> <a href="<?php echo $this->url(array_merge($params, array('page' => $this->previous))) ?>"> &lt; Prev</a> <?php else : ?> &lt; Prev <?php endif ?> </td> <td>|  <?php foreach ($this->pagesInRange as $page): ?> <?php if ($page != $this->current) : ?> <a href="<?php echo $this->url(array_merge($params, array('page' => $page))) ?>"> <?php echo $page ?></a> | <?php else: ?> <?php echo $page ?> | <?php endif; endforeach; ?> </td> <td>  <?php if (isset($this->next)) : ?> <a href="<?php echo $this->url(array_merge($params, array('page' => $this->next))) ?>"> Next &gt;</a> <?php else : ?> Next &gt; <?php endif; ?> </td> <td class="space">|</td> <td>  <?php if (isset($this->last)): ?> <a href="<?php echo $this->url(array_merge($params, array('page' => $this->last))) ?>"> Last &gt;</a> <?php else: ?> last &gt; <?php endif ?> </td> </tr> </table> </div> <?php endif; ?> </code></pre> I hope this helps.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POunexpected warning in zend pagination
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USRockyFord
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. This table or related slice is empty.

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.