In other words, instead of this:
$select= $this->db->select()->from(
'runz_miles', 'EMPL_NO')->where('empl_no = ?', 31713);
$this->view->result = $this->db->fetchAll($sql);
$paginator = Zend_Paginator::factory($this->view->result);
Do this:
$select= $this->db->select()->from(
'runz_miles', 'EMPL_NO')->where('empl_no = ?', 31713);
$paginator = Zend_Paginator::factory($select);
Hope that helps,
-Matt
On Wed, Oct 1, 2008 at 9:17 AM, 411161 <[EMAIL PROTECTED]> wrote:
>
> I don't understand Matt. Could you provide an example?
>
> > controller:
> > public function paginateAction() {
> >
> > $select= $this->db->select()->from( 'runz_miles',
> > 'EMPL_NO')->where('empl_no = ?', 31713);
>
> > $this->view->result = $this->db->fetchAll($sql);
> > $paginator = Zend_Paginator::factory($this->view->result);
> > $paginator->setCurrentPageNumber(15);
> > $this->view->paginator = $paginator;
> > }
>
> Everytime I clock on a link it will come back to this action. Right? SO
> what
> prevents it from not calling the sql again?
>
>
> Matthew Ratzloff wrote:
> >
> > Use a Zend_Db_Select object for your query and pass the instance to
> > factory(). If that doesn't suit your needs for some reason, you can
> > easily
> > write your own adapter by implementing Zend_Paginator_Adapter_Interface
> or
> > extending Zend_Paginator_Adapter_DbSelect.
> > Hope that helps,
> >
> > -Matt
> >
> > On Tue, Sep 30, 2008 at 8:13 AM, 411161 <[EMAIL PROTECTED]> wrote:
> >
> >>
> >> Thanks. For some reason, I must have missed all that when I first looked
> >> at
> >> the reference guide.
> >>
> >> So what I have done now is, changed my view to add the following:
> >> <?= $this->paginationControl($this->paginator2, 'Sliding', 'p.phtml');
> ?>
> >>
> >> And in the p.phtml I have added the code from
> >> http://framework.zend.com/manual/en/zend.paginator.usage.html
> >> under the heading: Item pagination
> >>
> >> What I am still unsure of is how I can not go to the db each time I
> click
> >> one of my links(first, last). I can't seem to find that in the
> >> documentation. Not sure if this is where sessions come in or what. But I
> >> was
> >> hoping to see an example.
> >>
> >>
> >>
> >> 411161 wrote:
> >> >
> >> > I have it working, but I am not sure how to create links for next,
> >> last,
> >> > first, previous, numbers, etc.. I am also not sure how to handle links
> >> in
> >> > my controller.
> >> > This is what I have so far."
> >> >
> >> > controller:
> >> > public function paginateAction() {
> >> >
> >> > $sql = 'SELECT * FROM runz_miles WHERE empl_no = 31713';
> >> > $this->view->result = $this->db->fetchAll($sql);
> >> > $paginator =
> >> Zend_Paginator::factory($this->view->result);
> >> > $paginator->setCurrentPageNumber(15);
> >> > $this->view->paginator = $paginator;
> >> > }
> >> >
> >> > in my view I have:
> >> > <table>
> >> > <?
> >> > foreach($this->paginator as $key => $row){
> >> >
> >> > echo "<tr><td>" .$row['EMPL_NO']
> >> . "</td>\n";
> >> > echo "<td>" .$row['PRISM_ORG_CODE']
> >> . "</td></tr>\n";
> >> > }
> >> > ?>
> >> > </table>
> >> >
> >> > How do I create the links and I how do I handle the action so that it
> >> will
> >> > not try and call the sql again?
> >> >
> >>
> >> --
> >> View this message in context:
> >>
> http://www.nabble.com/Looking-for-a-complete-Complete-Zend_Paginator-example-tp19731530p19744120.html
> >> Sent from the Zend Framework mailing list archive at Nabble.com.
> >>
> >>
> >
> >
>
> --
> View this message in context:
> http://www.nabble.com/Looking-for-a-complete-Complete-Zend_Paginator-example-tp19731530p19764012.html
> Sent from the Zend Framework mailing list archive at Nabble.com.
>
>
