how to add pagination to the nested comments in laravel?

Question

class Nested extends Model{
  public function nestedfunc()
{
    return $this->hasMany(Nested::class, 'parent_id');
}
 public function childnestedfunc()
{
    return $this->hasMany(Nested::class, 'parent_id')->with('nestedfunc');
}
}

//this is my model function for reccursion. how to add pagination to the root of the nested comments. i am storing all comments to the same table

root comment 1 -nested comments of root 1 ....
root comment 2 - nested comments of root 2 ....
paginate the root comments
root comments 3 - nested comments of root 3 ....
root comments 4 -nested commets of root 4.....
paginate the root comments
so on

score 2 · Accepted Answer · answered Oct 31 '19 at 14:22

2

You don't need two separate functions here, relationships can recursively call themselves so first changes your relationships to this

public function children()
{
    return $this->hasMany(Nested::class, 'parent_id')->with('children');
}

Then for your query you can just do

Nested::where('parent_id', null)->with('children')->paginate();

When I built a nested comments model I also added a scope to make it a little more readable

public function scopeTopLevel($query)
{
   return $query->where('parent_id', null);
}

So now the call in my controller is just

Comment::topLevel()->with('children')->paginate()

answered Oct 31 '19 at 14:22

Alec Joy

1,848
8
17

Will it paginate the root level comments. I don't want to paginate the children. Just the root level comments – alina Oct 31 '19 at 14:33
Yes, the pagination only applies to the root level comments – Alec Joy Oct 31 '19 at 14:34

how to add pagination to the nested comments in laravel?

1 Answers1