how to paginate a relationship inside eloquent model

Can you dd($widget) and check what was the output of the code?

assuming as like below pagination buttons should be,

      {{ $pageWidget->articles->links() }}

@nhayder if you're not using Laravel's paginate method, you should manually create a paginator instance and pass it to the view, then you will be able to call links method on it.

https://laravel.com/docs/6.x/pagination#manually-creating-a-paginator

new \Illuminate\Pagination\LengthAwarePaginator($items, $total, $perPage, $currentPage)

https://github.com/laravel/framework/blob/6.x/src/Illuminate/Pagination/LengthAwarePaginator.php#L40

@sti3bas i've gone through your link, Unfortunately it's very difficult to understand the documentation for a beginner like me, Are you familiar for any tutorial that cover this type of pagination

can you show some code please

just noticed that the code above is not returining pagionated data when i dd($widget->article);

So basically the pagionation is not taking place ????

@nhayder I guess I misunderstood you. If you want to paginate the articles relationship, you should be able to do that with $widget->articles()->paginate(10).

i think now we are on the same page, But not sure how to implement your code with mine,

i have this

    public static function getPageWidgets($id, $lang)
    {
        $pageWidget = Cache::rememberForever('page-'.$id, function () use ($id,$lang) {
        
            return Widget::with(

                        ['wsubcats','buttons', 'content', 'content.linkedPage', 'content.linkedArticle','articles' => function ($query) use ($lang) {

                            $query->where('language', '=', $lang)->paginate(15);

                        }]

                    )

                    ->where('page_id', '=', $id)

                    ->orderBy('sorting', 'asc')

                    ->get();

        });

        return $pageWidget;
    }

but when i dd($widget->articles) i can't see any pagination is happening.

So how to implement your code with maine ??? any ideas

Change as like below and check use $pageWidget instead of $widget,

   {{ $pageWidget->articles->links() }}

else

     {{ $Widget->links() }}

i'm getting same error for all cases, that because the links function is not available ???

Method Illuminate\Database\Eloquent\Collection::links does not exist

You cannot paginate a nested relation.

You need to fetch the paginated collection as a separate variable and pass that to the view.

@snapey hey how are you, ...

Your comment is very clear, I was trying to understand if it's possible to paginate a nested relationship or not. will do a seperate variable for the paginated collection, that will definitely work.

So glad you showed up :-), Thanks

its the same answer that @sti3bas gave you, just worded differently