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

38 votes201 views6 answers
Laravel foreign key
PHP Laravel
10 votes146 views5 answers
How to remove public from url in laravel
PHP Laravel
0 vote145 views1 answer
Populate old value of dropdown laravel
PHP Laravel
2 votes153 views1 answer
Foreign key constraint is incorrectly formed laravel
PHP Laravel
7 votes133 views3 answers
Laravel 8 validation unique 2 columns
PHP Laravel
0 vote151 views1 answer
Get deleted value laravel
PHP Laravel
0 vote141 views1 answer
Many to many relationship in laravel example stackoverflow
PHP Laravel
0 vote150 views2 answers
Laravel "query()->find"
PHP Laravel
1 vote150 views1 answer
Laravel multiple group by
PHP Laravel
0 vote147 views1 answer
Update session laravel
PHP Laravel