Laravel get next record

public function show($id)
{

    // get the current user
    $user = User::find($id);

    // get previous user id
    $previous = User::where('id', '<', $user->id)->max('id');

    // get next user id
    $next = User::where('id', '>', $user->id)->min('id');

    return View::make('users.show')->with('previous', $previous)->with('next', $next);
}

Source: stackoverflow.com

Similar codes

9 votes298 views2 answers
Laravel Str::random
PHP Laravel
8 votes314 views3 answers
Laravel redirect back with errors and input
PHP Laravel
0 vote345 views1 answer
Laravel telescope redirect to localhost
PHP Laravel
7 votes389 views4 answers
Laravel is route name
PHP Laravel
0 vote360 views1 answer
How to display all posts assocatied to user in laravel
PHP Laravel
0 vote344 views1 answer
Add custom attribute for validation errors laravel
PHP Laravel
8 votes381 views6 answers
Laravel transaction
PHP Laravel
24 votes311 views6 answers
Laravel create method
PHP Laravel
23 votes317 views6 answers
Make auth in laravel 7
PHP Laravel
7 votes329 views2 answers
Laravel how to check if there are record exists
PHP Laravel