Level 73
Can you explain why paginate is not working?
There are other methods for sure, you can use take but that's like using limit, you will not be able to get the next page of 20 results.
Payment::take(20)->get();
Jul 4, 2019
7
Level 1
other methods for all()
is there any other method for all()? im getting a big collection and paginate is not working. it only gets the first page of pagination
heres my code
controller:
$payments = Payment::paginate(20);
blade:
<?php
foreach($payments as $payment){
if($client->id == $payment->id){
$pay+= $payment->loan_interest+$payment->loan_amount+$payment->loan_cbu;
}
}
$balance = $cap-$pay-$rev;
?>
<tr>
<td>{{$balance}}</td>
</tr>
Level 13
Check in blade as like below the tr tags,
<div>{{ $payments ->links() }}</div>
and can you show what is the exact error do you getting?
Level 1
yeah thats why i want to know how can i get the next page result. im not using it as a display
Level 1
im using $payments to get all clients balance
Level 122
you have to use the ->links() function to load next page of results in a new request
Trying to add data from multiple pages is never going to work
You should use aggregate functions in your database query to get the total without looping
https://reinink.ca/articles/calculating-totals-in-laravel-using-conditional-aggregates
Level 1
how about chunk?
Level 88
@duckz1209 chunk would split the collection in smaller parts, but in the end you still have the full collection so it has the same performance as all.
Can you maybe explain what you're trying to achieve?
1 like
Please or to participate in this conversation.