Monday, November 19, 2012

Re: Pagination

What you are looking for is the following.  

$this->set('posts', $this->paginate(array('Post', "Post.category_id = $categoryId"));


On Mon, Nov 19, 2012 at 3:32 PM, Paul Willis <paul.willis@me.com> wrote:
I'm not paging categories I'm trying to page posts that belong to a particular category

PW


On 19 Nov 2012, at 21:15, Andras Kende <andras@kende.com> wrote:

>
> something like this should work:
>
>       public function category($id = null) {
>               $this->paginate = array(
>                       'conditions' => array(
>                               'Category.id' => $id
>                       )
>               );
>               $posts = $this->Post->Category->paginate('Category');
>               //print_r($posts);  // to test here ...
>               $this->set(compact('posts'));
>       }
>
> But since you paginating categories it may be better to do this from the categories controller..
>
> Andras Kende
> http:///www.kende.com
>
> On Nov 19, 2012, at 12:57 PM, Paul Willis <paul.willis@me.com> wrote:
>
>> In my PostsController.php I have a function to find all the posts from a category…
>>
>>      public function category($id = null) {
>>              $this->set('posts', $this->Post->Category->find('first', array(
>>                      'conditions' => array(
>>                              'Category.id' => $id
>>                      )
>>              )));
>>      }
>>
>>
>> This works fine and all my posts for the particular category are returned.
>>
>> However I obviously get every post in that category and so now I would like to use paginate but I'm not sure how to add it to the above function.
>>
>> PW
>>
>> --
>> Like Us on FaceBook https://www.facebook.com/CakePHP
>> Find us on Twitter http://twitter.com/CakePHP
>>
>> ---
>> You received this message because you are subscribed to the Google Groups "CakePHP" group.
>> To post to this group, send email to cake-php@googlegroups.com.
>> To unsubscribe from this group, send email to cake-php+unsubscribe@googlegroups.com.
>> Visit this group at http://groups.google.com/group/cake-php?hl=en.
>>
>>
>
> --
> Like Us on FaceBook https://www.facebook.com/CakePHP
> Find us on Twitter http://twitter.com/CakePHP
>
> ---
> You received this message because you are subscribed to the Google Groups "CakePHP" group.
> To post to this group, send email to cake-php@googlegroups.com.
> To unsubscribe from this group, send email to cake-php+unsubscribe@googlegroups.com.
> Visit this group at http://groups.google.com/group/cake-php?hl=en.
>
>

--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP

---
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com.
To unsubscribe from this group, send email to cake-php+unsubscribe@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en.



--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
 
---
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com.
To unsubscribe from this group, send email to cake-php+unsubscribe@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en.
 
 

No comments: