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

21 votes315 views5 answers
Laravel 7 auth command
PHP Laravel
14 votes351 views6 answers
Laravel Password Validation
PHP Laravel
3 votes346 views2 answers
Allowed memory size of 1610612736 bytes exhausted (tried to allocate 4096 bytes) laravel
PHP Laravel
0 vote376 views5 answers
Laravel 8 app with more than one database
PHP Laravel
0 vote327 views1 answer
Gate::before not working laravel 8
PHP Laravel
0 vote368 views1 answer
Href in laravel view
PHP Laravel
0 vote342 views1 answer
Check for headers laravel
PHP Laravel
0 vote363 views1 answer
Datetime-local laravel migration data type
PHP Laravel
0 vote511 views1 answer
Download laravel 8 zip
PHP Laravel
0 vote341 views1 answer
How pass optional route parameter in laravel
PHP Laravel