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 vote234 views1 answer
Morph relation laravel
PHP Laravel
2 votes237 views1 answer
Laravel get only relationship
PHP Laravel
31 votes229 views6 answers
Update or create laravel
PHP Laravel
7 votes219 views3 answers
Laravel 8 – Remove Public from URL
PHP Laravel
0 vote210 views1 answer
Laravel unique column except self
PHP Laravel
0 vote166 views2 answers
Laravel restrict home route access
PHP Laravel
21 votes239 views5 answers
Laravel 7 auth command
PHP Laravel
0 vote311 views1 answer
Laravel automatically generate unique username
PHP Laravel
0 vote290 views7 answers
Laravel eloquent tricks
PHP Laravel
33 votes231 views6 answers
Laravel make:auth
PHP Laravel