Laravel 5 Pagination

Getting following error

FatalErrorException in 73cec445eee8ed02451395c61bbdf2a4 line 52:
Call to undefined method Illuminate\Database\Eloquent\Collection::render()
in 73cec445eee8ed02451395c61bbdf2a4 line 52
at HandleExceptions->fatalExceptionFromError(array('type' => '1', 'message' => 'Call to undefined method Illuminate\Database\Eloquent\Collection::render()', 'file' => '/www/sites/client3/wwwroot/TestLaravel/storage/framework/views/73cec445eee8ed02451395c61bbdf2a4', 'line' => '52')) in HandleExceptions.php line 116
at HandleExceptions->handleShutdown()

Following is the code from view

<div class="pagination"> {!! $plans->render() !!} </div>
    </div>

and following is the code from controller

public function index()
    {
        $plansQuery = Plan::query();
        $plansQuery->where('deleted', '=', 0)->paginate(3);
        $plans = $plansQuery->get();
        return view('plans.plans', compact('plans'));
    }

martindilling

11 years ago

Best Answer

Level 19

If I remember correctly paginate is working like a ->get().

Haven't tested it, but try this:

$plansQuery = Plan::query();
$plans = $plansQuery->where('deleted', '=', 0)->paginate(3);
return view('plans.plans', compact('plans'));

Or just:

$plans = Plan::where('deleted', '=', 0)->paginate(3);
return view('plans.plans', compact('plans'));

1 like

usman

11 years ago

Level 27

@technogenes try:


public function index()
    {
        $plansQuery = Plan::query();
        $plans = $plansQuery->where('deleted', '=', 0)->paginate(3);

       //$plans = $plansQuery->get();
        return view('plans.plans', compact('plans'));
    }

Please or to participate in this conversation.