Aishan's avatar

pagination in laravel 8

I do not know where to put pagination method in the below query, I have tried to replace it with get() but it gives me error. Can anyone help me please?

 $search_result= Project::join('project__reports','projects.id','=','project__reports.project_id')
        
        ->select(array('projects.*', 'project__reports.status',
        'project__reports.notes','project__reports.prgs_prc','project__reports.prgs_prc_2',
        'project__reports.Registered_date',
        'project__reports.added_days','project__reports.added_fund',
        'project__reports.final_fund','project__reports.final_date'))
        ->orderBy('project__reports.id','ASC')
        ->latest('project__reports.id')->get()->keyBy('id');
0 likes
3 replies
Snapey's avatar

replace ->get()->keyBy('id'); with ->paginate();

Aishan's avatar

->latest('project__reports.id')->get()->keyBy('id')-paginate(10); That worked. Thanks

Please or to participate in this conversation.