How to get the last item from a Laravel database query array

Question

Say I am querying the user table like this in Laravel:

routes.php

Route::get('/users', function()
{
    $users = DB::table('users')->get();
}

users.blade.php

<ul>
@foreach ($users as $user)
    <li>{{ $user->id }}</li>
@endforeach
</ul>

But I wanted the following with the last users id from the original query in the row below then how could I get that information?

users.blade.php

<ul>
@foreach ($users as $user)
    <li>{{ $user->id }}</li>
@endforeach
</ul>

<div id="last-user" data-user-id="{{ $users->lastUserId }}"></div>

The Alpha · Accepted Answer · 2014-05-13 15:41:48Z

20

You may use last to get the last item:

$last = $users->last();

answered May 13, 2014 at 15:41

The Alpha

147k30 gold badges294 silver badges313 bronze badges

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

1 Comment

So $users->last()->id ?