Pagination Not working

Permalink July 07, 2011 at 6:07 PM

Working on a new package, and pagination seems to display all the items on one page even though I've specified a limit lower than the number that appear. Controller code:

public function view($page=0){
   $sql="SELECT COUNT(email) FROM tableName";
   $total=$db->query($sql);
   $total=str_replace('COUNT(email)','', $total);   
        $query = "SELECT * FROM tableName "; 
       $rows = $db->getAll($query);
   $paginator->init(intval($page), $total, View::url('/invite_list'), 10);
        $this->set('rows', $rows);
}

I feel like it has something to do with the page number, but I really don't know, but maybe i'm supposed to have something in view? Right now all I have in view related to paging is

if($paginator && strlen($paginator->getPages())>0){ ?>    
       <div  class="pagination">
          <div class="pageLeft"><?php echo $paginator->getPrevious()?></div>
          <div class="pageRight"><?php echo $paginator->getNext()?></div>
          <?php echo $paginator->getPages()?>
       </div>      
   <? } ?>

So far I've been going off the log dashboard page to get this btw.

12345j replied on Jul 8, 2011 at 12:07 pm Permalink Reply

bump

Post Reply

Delete Post

You are allowed to delete your post for 5 minutes after it's posted.

Delete

Mark Post as Spam

Are you sure you would like to mark this post as spam?

Mark as Spam

Destroy Spammer

This script will report this post as spam and add a permanent IP ban for this user, type "DESTROY" below to continue.

DESTROY SPAMMER

Sign In?

You must have a user account and be signed to perform this action.

This website stores cookies on your computer. These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media. To find out more about the cookies we use, see our Privacy Policy.

Forums

Developing (v7+)