I am using the following code WITHOUT using fetchAll() .. am I doing it
right?
======================================================
$select = $this->select();
$select->from($this, $cols);
if ($where) {
$select->where($where);
}
if ($order) {
$select->order($order);
}
Zend_Loader::loadClass('Zend_Paginator');
$objPaginator = Zend_Paginator::factory($select);
==========================================================
Please correct me where I am wrong.
Thanks
Ashish Sharma
Matthew Ratzloff wrote:
>
> print_r() will not work.
> You should not fetch the rows. You should pass the Select object directly
> to the Paginator's factory() method. It only selects the rows necessary.
>
> -Matt
>
> On Thu, Oct 23, 2008 at 6:31 AM, ashish.sharma <
> [EMAIL PROTECTED]> wrote:
>
>>
>> Nothing seems to be working.
>>
>> Used the code snippet but when I "print_r()" he paginator then I am not
>> able
>> to see the total number of records, total pages formed etc.
>>
>> Also, I m not sure whether use of fetchAll is appropriate or not. What is
>> the use of fetching all the records? Can't we do something like .. just
>> fetch the rows to be displayed and the count(*) of the query to get the
>> total records.
>>
>> Kindly advice!
>>
>> Ashish Sharma
>> TL R&D
>>
>>
>>
>> 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-tp19731530p20131009.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-tp19731530p20144017.html
Sent from the Zend Framework mailing list archive at Nabble.com.
