insight's avatar

How to create a pagination result corresponding to single table in multiple tables join?

Dear Friends,

I know how to paginate a single Table query result in controller like below:

       $pages = Magazine::latest('created_at')->paginate(7); 
       return view('magazines.viewpage', compact('pages'));

But in case of join how I can do this . From documentation can see

                $pages = \DB::table('magazine_details')
                ->join('magazines', 'magazine_details.magazine_id', '=', 'magazines.id')
                ->select('magazine_details.*', 'magazines.title')
                ->get();
                return view('magazines.viewpage', compact('pages'));

am I right ? Please advise

Thanks

Anes

0 likes
1 reply
insight's avatar

Thanks friends ,

a simple change need here resolved issue...

        $pages = \DB::table('magazine_details')
        ->join('magazines', 'magazine_details.magazine_id', '=',      'magazines.id')
        ->select('magazine_details.*', 'magazines.title')
        ->paginate(7);

Please or to participate in this conversation.