Re: Pagination with HABTM?
Yep, doesn't seem to work as it returns all the posts.
On Monday, June 25, 2012 3:21:15 PM UTC+10, Борислав Събев wrote:
Have you tried configuring the paginator in your Controller with a limit
of 10:
public $paginate = array(
'limit' = 10,
'order' = array(
'Post.title' = 'asc'
)
);
On Monday, 25 June 2012 04:14:32 UTC+3, 42startups wrote:
Ah ok, so how would I paginate and limit results to 10?...
$this-loadModel('Tag', $id);
$tag = $this-Tag-read();
On Monday, June 25, 2012 6:11:55 AM UTC+10, JonStark wrote:
I find it easier to use LoadModel to display and sort posts from HABTM...
Le dimanche 24 juin 2012 10:40:04 UTC+2, 42startups a écrit :
Wow, CakePHP really hasn't got this problem sorted.
After hours of searching I came across the solution below (which may or
may not be outdated), but I'm having issues applying paginatior 'limit' =
10 or other ordering.
Any ideas what I'm missing?
My model:
public $hasAndBelongsToMany = array(
'Post' = array(
'className' = 'Post',
'joinTable' = 'tags_posts',
'foreignKey' = 'tag_id',
'associationForeignKey' = 'post_id',
'order' = array('Post.created DESC'),
'unique' = true
)
);
In my controller in view()
public function view($id) {
$this-Tag-bindModel(array('hasOne' = array('TagsPost')), false);
$this-set('tag', $this-paginate('Tag', array('TagsPost.tag_id' =
$id)));
}
In my view I then had to change:
foreach ($tag['Post'] as $post)
to
foreach ($tag[0]['Post'] as $post)
--
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
cake-php+unsubscr...@googlegroups.com For more options, visit this group at
http://groups.google.com/group/cake-php
Re: Pagination with HABTM?
Yes, I do it this way in my app:
$this-loadModel('Post');
$this-paginate = array('Post' = array('conditions' = //conditions ),
'limit' = '8', 'order' = array('Post.created' = 'desc')));
$data = $this-paginate('Post');
$this-set('posts', $data);
Hope it helped
Le lundi 25 juin 2012 03:14:32 UTC+2, 42startups a écrit :
Ah ok, so how would I paginate and limit results to 10?...
$this-loadModel('Tag', $id);
$tag = $this-Tag-read();
On Monday, June 25, 2012 6:11:55 AM UTC+10, JonStark wrote:
I find it easier to use LoadModel to display and sort posts from HABTM...
Le dimanche 24 juin 2012 10:40:04 UTC+2, 42startups a écrit :
Wow, CakePHP really hasn't got this problem sorted.
After hours of searching I came across the solution below (which may or
may not be outdated), but I'm having issues applying paginatior 'limit' =
10 or other ordering.
Any ideas what I'm missing?
My model:
public $hasAndBelongsToMany = array(
'Post' = array(
'className' = 'Post',
'joinTable' = 'tags_posts',
'foreignKey' = 'tag_id',
'associationForeignKey' = 'post_id',
'order' = array('Post.created DESC'),
'unique' = true
)
);
In my controller in view()
public function view($id) {
$this-Tag-bindModel(array('hasOne' = array('TagsPost')), false);
$this-set('tag', $this-paginate('Tag', array('TagsPost.tag_id' =
$id)));
}
In my view I then had to change:
foreach ($tag['Post'] as $post)
to
foreach ($tag[0]['Post'] as $post)
--
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
cake-php+unsubscr...@googlegroups.com For more options, visit this group at
http://groups.google.com/group/cake-php
Re: Pagination with HABTM?
I find it easier to use LoadModel to display and sort posts from HABTM...
Le dimanche 24 juin 2012 10:40:04 UTC+2, 42startups a écrit :
Wow, CakePHP really hasn't got this problem sorted.
After hours of searching I came across the solution below (which may or
may not be outdated), but I'm having issues applying paginatior 'limit' =
10 or other ordering.
Any ideas what I'm missing?
My model:
public $hasAndBelongsToMany = array(
'Post' = array(
'className' = 'Post',
'joinTable' = 'tags_posts',
'foreignKey' = 'tag_id',
'associationForeignKey' = 'post_id',
'order' = array('Post.created DESC'),
'unique' = true
)
);
In my controller in view()
public function view($id) {
$this-Tag-bindModel(array('hasOne' = array('TagsPost')), false);
$this-set('tag', $this-paginate('Tag', array('TagsPost.tag_id' =
$id)));
}
In my view I then had to change:
foreach ($tag['Post'] as $post)
to
foreach ($tag[0]['Post'] as $post)
--
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
cake-php+unsubscr...@googlegroups.com For more options, visit this group at
http://groups.google.com/group/cake-php
Re: Pagination with HABTM?
Ah ok, so how would I paginate and limit results to 10?...
$this-loadModel('Tag', $id);
$tag = $this-Tag-read();
On Monday, June 25, 2012 6:11:55 AM UTC+10, JonStark wrote:
I find it easier to use LoadModel to display and sort posts from HABTM...
Le dimanche 24 juin 2012 10:40:04 UTC+2, 42startups a écrit :
Wow, CakePHP really hasn't got this problem sorted.
After hours of searching I came across the solution below (which may or
may not be outdated), but I'm having issues applying paginatior 'limit' =
10 or other ordering.
Any ideas what I'm missing?
My model:
public $hasAndBelongsToMany = array(
'Post' = array(
'className' = 'Post',
'joinTable' = 'tags_posts',
'foreignKey' = 'tag_id',
'associationForeignKey' = 'post_id',
'order' = array('Post.created DESC'),
'unique' = true
)
);
In my controller in view()
public function view($id) {
$this-Tag-bindModel(array('hasOne' = array('TagsPost')), false);
$this-set('tag', $this-paginate('Tag', array('TagsPost.tag_id' =
$id)));
}
In my view I then had to change:
foreach ($tag['Post'] as $post)
to
foreach ($tag[0]['Post'] as $post)
--
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
cake-php+unsubscr...@googlegroups.com For more options, visit this group at
http://groups.google.com/group/cake-php
Re: Pagination with HABTM?
Have you tried configuring the paginator in your Controller with a limit of
10:
public $paginate = array(
'limit' = 10,
'order' = array(
'Post.title' = 'asc'
)
);
On Monday, 25 June 2012 04:14:32 UTC+3, 42startups wrote:
Ah ok, so how would I paginate and limit results to 10?...
$this-loadModel('Tag', $id);
$tag = $this-Tag-read();
On Monday, June 25, 2012 6:11:55 AM UTC+10, JonStark wrote:
I find it easier to use LoadModel to display and sort posts from HABTM...
Le dimanche 24 juin 2012 10:40:04 UTC+2, 42startups a écrit :
Wow, CakePHP really hasn't got this problem sorted.
After hours of searching I came across the solution below (which may or
may not be outdated), but I'm having issues applying paginatior 'limit' =
10 or other ordering.
Any ideas what I'm missing?
My model:
public $hasAndBelongsToMany = array(
'Post' = array(
'className' = 'Post',
'joinTable' = 'tags_posts',
'foreignKey' = 'tag_id',
'associationForeignKey' = 'post_id',
'order' = array('Post.created DESC'),
'unique' = true
)
);
In my controller in view()
public function view($id) {
$this-Tag-bindModel(array('hasOne' = array('TagsPost')), false);
$this-set('tag', $this-paginate('Tag', array('TagsPost.tag_id' =
$id)));
}
In my view I then had to change:
foreach ($tag['Post'] as $post)
to
foreach ($tag[0]['Post'] as $post)
--
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
cake-php+unsubscr...@googlegroups.com For more options, visit this group at
http://groups.google.com/group/cake-php
