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

8 votes169 views3 answers
Get env app url laravel
PHP Laravel
0 vote157 views1 answer
Gate::before not working laravel 8
PHP Laravel
5 votes149 views2 answers
Laravel jetstream livewire
PHP Laravel
0 vote175 views1 answer
Laravel 8 - get values of url query strings in controller
PHP Laravel
0 vote157 views1 answer
How to pass token with post request laravel
PHP Laravel
2 votes133 views2 answers
The requested url was not found on this server. laravel
PHP Laravel
1 vote148 views2 answers
Running laravel as host
PHP Laravel
0 vote150 views1 answer
Import facade URL laravel
PHP Laravel
10 votes148 views3 answers
Get current date carbon laravel
PHP Laravel
7 votes151 views4 answers
Laravel route namespace and prefix
PHP Laravel