php - Method IlluminateSupportCollection::paginate does not exist

Question

I have this code:

$transactions = DB::table('transactions')
        ->join('orders', 'transactions.order_id', '=', 'orders.id')
        ->get()->paginate(5);


return view('transactions.index', ['transactions' => $transactions]);

the code result in this error:

Method IlluminateSupportCollection::paginate does not exist

Answer 1

Try following query

 $transactions = DB::table('transactions')->join('orders', 'transactions.order_id', '=', 'orders.id')->paginate(5);

remove get() from query