Best way to paginate relations in laravel

@Rahul why dont you fetch separately?

like

public function show($id)
    {
        $topic = Topic::where('id',$id)->firstOrFail();

        $comments = Comment::where('topic_id', $id)->with('user')->paginate(15);

        return view('forums.show', compact('topic', 'comments'));
    }

@edoc - Basically i'm building API with laravel and calling with my client angular application . well this is fine for getting first 15 comments for all post according to your code. but what about other comments . when request for more comments for that single post . for that i should need to build other function or something like that. what would you like to say on that topic.?

I'd make a separate endpoint for comments. For example, you could use /api/v1/posts to get the post's ID, and then make a second call to /api/v1/comments?post_id=42. In this second call, you can do any pagination you want, including getting more records if the user clicks that button.

<<well this is fine for getting first 15 comments for all post according to your code

I'm afraid no sir.You can fetch all the comments since every comment is paginated

Let's say you have this code for your api

public function fetch(){

        return App\Comment::paginate(5);
}

and let's say you have 20 comments for the particular post. that will be 4 pages in total right?

when you access like api/comments/{id} you fetch the first 5 comments

and then you wanna fetch the next 5 you hit api/comments/{id}/?page=2

Ok edoc , i might be wrong :). let me give it a shot and then i'll be back.

yes i know that. even i fetched all my posts from databases and even added infinite scroll feature to my frontend :) . but i'm little careful about comments. n i were stuck. but now i have found couple way to solve it. let me try

Thanks JeroenVanOort. i think your endpoint gave me another way to think about the solution of this problem. let me see which one works for me better.

@Rahul you can also use nested resources endpoint:

/posts/{post}/comments

Hmm. you are right. thanks for your time @kfirba :)

So here is the perfect ans of my own question -

Whenever we think of loading related data , the first things came into mind is by using laravel eloquent eager loading . like : In my case i wants to load Post with it's Comments, so with eager loading we write something like this

$posts = Post::with('comments')->paginate(10);   OR
$posts = $this->post->with('comments')->paginate(10); OR

In this case it's really hard to paginate comment and if we can do by nested query. it's really hard to make next page request on that comment.

but this was not the right way to do it. yeah this was first cam into mind.. so

Solution

so basically what i did, i just wanted to show my users initially single comment for that i fetched my post with single & most popular comment. like this: end point is: /posts

$posts = $this->post->with(['comments'=> function(query){

   $query->first();   //your popular comment or other logic

}])->paginate(10);

this was initial comment for my post.

then i created new function for handling my asynchronous fetching comments. like @edoc said :

end point is: posts/postId/comments @kfirba said

public function getPostComments($postId)
    {
        $post= Post::where('id',$id)->firstOrFail();

        $comments = Comment::where('post_id', $postId)->with('user')->paginate(15);

        return view('post.show', compact('post', 'comments'));
    }

So now you can call this function for your paginated comments.

Taught , it will be awesome to explain this for someone else, Thanks to @edoc @kfirba & @JeroenVanOort