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
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.