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

10 votes294 views2 answers
Format date in laravel using carbon
PHP Laravel
7 votes278 views2 answers
Laravel seeder with relationships
PHP Laravel
8 votes315 views3 answers
Laravel 8 check if record exists
PHP Laravel
1 vote289 views1 answer
Laravel nova 3 belongtomany don't display
PHP Laravel
0 vote303 views1 answer
Laravel auth without vue or bootstrap
PHP Laravel
18 votes293 views4 answers
Use if in laravel blade
PHP Laravel
0 vote296 views1 answer
Maintaining serial number in laravel pagination table
PHP Laravel
0 vote317 views2 answers
Laravel call controller method from view
PHP Laravel
0 vote301 views1 answer
Country code validation in laravel
PHP Laravel
0 vote281 views1 answer
How to import in laravel excel command
PHP Laravel