Reverse Order of Array Elements with Foreach Loop using Eloquent in Laravel

Question

I have a Score-Table with different ratings, strings and radio-buttons.

Now I want to loop through these. Normally I would go about solving it like this:

 <table>
    <tr>
        <th>ID</th>
        <th>Type</th>
        <th>Comment</th>
    </tr>
    @foreach($scores as $score)

    <tr>
        <td>{{$score->id}}</td>
        <td>{{$score->ratingradio}}</td>
        <td>{{$score->ratingtext}}</td>
    </tr>

    @endforeach
</table>

But I don't only want the order to be reversed, but I also want the array to be sliced, so that it just outputs the last 20 Elements of the array.

I attempted solving it like this in my Controller:

$scores = Score::where('unit_id', $id)->where('created_at', '>', Carbon::now()->subDays(3))->get();


// Save all ratingtexts in an array
$comments = $scores->lists('ratingtext');
$commenttype = $scores->lists('ratingradio');
// Get the last 20 Elements of the Array
$comments = array_slice($comments, -20, 20, true);
// Reverse the array, to have the latest element first displayed
$comments = array_reverse($comments, true);

And then looping through the $comments. But I don't only want to display the comment, I also want to be able to display all Information regarding this Element. So preferably like the above method with eloquent, where I output $score->ratingtext, $score->ratingradio, $score-id, and whatever I want.

I tried just using

 @foreach(array_reverse($scores) as $score)

Which obviously didn't work, because $scores is an object and it was expecting an array. How am I going to reverse loop through every score of my Scores Table?

Why don't you simply set orderBy and limit to fetch only 20 rows? — Jarek Tkaczyk
– Jarek Tkaczyk, Commented May 5, 2014 at 8:24

ollieread · Accepted Answer · 2014-05-05 22:44:00Z

29

Retrieving the last 20 items is quite easy.

$scores = Score::where('unit_id', $id)
    ->where('created_at', '>', Carbon::now()->subDays(3))
    ->orderBy('created_at', 'desc')
    ->take(20)
    ->get();

$scores = $scores->reverse();

Done.

Just tell it to pull out the first 20 items that match your query, with a reversed order and then reverse the collection to get the proper order.

answered May 5, 2014 at 22:44

ollieread

6,3211 gold badge22 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

ollieread Over a year ago

What exactly do you mean? The above will do exactly what it's supposed to do.

Mureithi Maina Over a year ago

The problem with the above is the array key in the collection does not change and if passed using JSON, it reverts.

ollieread Over a year ago

I'm not following @RazorMureithi, what key?

Mureithi Maina Over a year ago

Let me try to explain what I remember the $scores variable currently has the right order if you lets say return with JSON i.e. return response()->json(['date'=>$scores]) it will revert the order. this is because the collection index did not change/

Abdur Rahman Turawa · Accepted Answer · 2017-05-02 12:52:24Z

21

You can as well easily do @foreach($scores->reverse() as $score)

answered May 2, 2017 at 12:52

Abdur Rahman Turawa

5814 silver badges6 bronze badges

Comments

Aurel · Accepted Answer · 2014-05-05 02:35:22Z

12

You can use:

array_reverse($scores->toArray());

or Eloquent\Collection methods to keep the Model object

$scores->reverse();

Take a look at the Eloquent\Collection API.

answered May 5, 2014 at 2:35

Aurel

3,7501 gold badge21 silver badges22 bronze badges

1 Comment

user1669496 Over a year ago

To clear it up, $scores = Score::where('unit_id', $id)->where('created_at', '>', Carbon::now()->subDays(3))->get()->reverse()->take(20) should work.

Oleg Shakhov · Accepted Answer · 2018-02-07 15:05:12Z

0

There are even easyest way:

$scores = Score::where('unit_id', $id)
    ->where('created_at', '>', Carbon::now()->subDays(3))
    ->orderBy('created_at', 'desc')
    ->orderBy('id', 'asc')
    ->take(20)
    ->get();

answered Feb 7, 2018 at 15:05

Oleg Shakhov

4458 silver badges27 bronze badges

Comments

user1669496 · Accepted Answer · 2014-05-05 13:50:47Z

-2

Looking through the API, it seems you can use take() to make this very simple. It behaves a little differently when running on query builder vs collection, so you'd want to get your collection first.

$scores = Score::where('unit_id', $id)->where('created_at', '>', Carbon::now()->subDays(3))->get()->take(-20);

answered May 5, 2014 at 13:50

user1669496

33.3k9 gold badges76 silver badges65 bronze badges

Collectives™ on Stack Overflow

Reverse Order of Array Elements with Foreach Loop using Eloquent in Laravel

5 Answers 5

4 Comments

Comments

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

4 Comments

Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related