Sort result with custom function and paginate

Hi, I want to sort results with custom function and want to paginate the result.

I try this. EG :

$posts = Post::paginate(3)->sortBy(function ($post) {
    // custom sort here
});

It 's work . But when i show pagination in views with $posts->render();. It said "Method render does not exist".

How to sort with custom function and paginate properly. Is there any better ways to do it?

zachleigh

10 years ago

Level 47

Create the paginator after you sort the results. Try this:

$posts = Posts::all()->sortBy(function ($post) {
    // custom sort here
})->paginate(3);

1 like

HeinZawHtet

10 years ago

Level 1

@zachleigh It show "Method paginate does not exist."

zachleigh

10 years ago

Level 47

Hmm. Maybe you could manually create one. Something like this:

    private function paginateAnswers($data, $request)
    {
        $page = $request->get('page', 1);

        $perPage = 10;

        $offset = ($page * $perPage) - $perPage;

        $paginator = new LengthAwarePaginator(
            $data,
            count($answers),
            $perPage,
            $page,
            ['path' => $request->url(), 'query' => $request->all()]
        );

        return $paginator;
    }

Please or to participate in this conversation.