Working great now, Andras! Thank you for the help. Now I just need to get
it working as an element.
{c}
On Fri, Jan 13, 2012 at 3:21 AM, Andras Kende <[email protected]> wrote:
>
> looks like you are doing a find not paginate, try something like this:
>
> > public function news() {
> > $this->set('posts', $this->paginate ('Post'));
> > }
>
>
> or :
>
> public function news() {
> $this->paginate = array(
> 'limit' => 10,
> 'order' => array('Post.title' => 'ASC'),
> );
> $posts = $this->paginate('Post');
> $this->set(compact('posts'));
> }
>
> also no need to load Paginator helper here:
> > public $helpers = array('Html', 'Form', 'Paginator');
>
> The paginator will load that for you automatically.
>
>
> Andras Kende
> http://www.kende.com
>
> On Jan 12, 2012, at 6:10 PM, Chooch Schubert wrote:
>
> > I have followed the 2.0 book to add pagination to a controller/view. I
> > get the paginate controls and they are rendering correctly (they
> > *think* I'm doing things like next page and sort when I click on the
> > links since they change their counts and links) however the data
> > returned isn't paginated.
> >
> > I should only be seeing 10 posts, but I am getting all posts in the
> > database (about 30) no matter what I click on.
> >
> > Any pointers?
> >
> > The code in the PostsController.php looks like:
> > <?php
> > class PostsController extends AppController {
> > public $name = 'Posts';
> > public $helpers = array('Html', 'Form', 'Paginator');
> > public $components = array('Session');
> >
> > public $paginate = array(
> > 'limit' => 5,
> > 'order' => array(
> > 'Post.title' => 'asc'
> > )
> > );
> >
> > public function news() {
> > $this->paginate ('Post');
> > $this->set('posts', $this->Post->find('all'));
> > }
> >
> > The code in the view looks like:
> > <table>
> > <tr>
> > <th width=25%><?php echo $this->Paginator->sort('title',
> > 'Title'); ?></th>
> > <th><?php echo $this->Paginator->sort('body', 'Content'); ?></
> > th>
> > </tr>
> > <?php foreach ($posts as $post): ?>
> > <tr>
> > <td><?php echo $post['Post']['title']; ?> </td>
> > <td><?php echo $post['Post']['body']; ?> </td>
> > </tr>
> > <?php endforeach; ?>
> > </table>
> >
> > <?php
> > // Shows the page numbers
> > echo $this->Paginator->numbers();
> >
> > // Shows the next and previous links
> > echo $this->Paginator->prev('« Previous', null, null, array('class' =>
> > 'disabled'));
> > echo $this->Paginator->next('Next »', null, null, array('class' =>
> > 'disabled'));
> >
> > // prints X of Y, where X is current page and Y is number of pages
> > echo $this->Paginator->counter();
> > ?>
> >
> > --
> > Our newest site for the community: CakePHP Video Tutorials
> http://tv.cakephp.org
> > Check out the new CakePHP Questions site http://ask.cakephp.org and
> help others with their CakePHP related questions.
> >
> >
> > To unsubscribe from this group, send email to
> > [email protected] For more options, visit this
> group at http://groups.google.com/group/cake-php
>
> --
> Our newest site for the community: CakePHP Video Tutorials
> http://tv.cakephp.org
> Check out the new CakePHP Questions site http://ask.cakephp.org and help
> others with their CakePHP related questions.
>
>
> To unsubscribe from this group, send email to
> [email protected] For more options, visit this group
> at http://groups.google.com/group/cake-php
>
--
Our newest site for the community: CakePHP Video Tutorials
http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others
with their CakePHP related questions.
To unsubscribe from this group, send email to
[email protected] For more options, visit this group at
http://groups.google.com/group/cake-php
