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

0 vote142 views1 answer
Laravel subtract date
PHP Laravel
0 vote125 views2 answers
How do we calculate average in laravel 8
PHP Laravel
0 vote134 views1 answer
How to get a list of registered route paths in Laravel?
PHP Laravel
9 votes120 views6 answers
Laravel 8 date format
PHP Laravel
0 vote124 views1 answer
Laravel validatrion check should be null
PHP Laravel
4 votes144 views1 answer
Laravel mail send flexible subject
PHP Laravel
1 vote125 views1 answer
Laravel pusher broadcasting/auth 403
PHP Laravel
2 votes132 views1 answer
Custom rule laravel validation
PHP Laravel
0 vote119 views1 answer
Laravel telescope tutorial
PHP Laravel
1 vote138 views1 answer
How to override default name for apiresourc route in laravel
PHP Laravel