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 vote142 views2 answers
Laravel file upload
PHP Laravel
-1 vote105 views4 answers
Laravel collection find
PHP Laravel
1 vote132 views4 answers
Laravel create multiple rows
PHP Laravel
3 votes124 views3 answers
Laravel get a url using name
PHP Laravel
0 vote117 views1 answer
Get database columns laravel
PHP Laravel
1 vote127 views1 answer
Laravel trans with parameters
PHP Laravel
2 votes76 views1 answer
Comments table example in laravel
PHP Laravel
0 vote120 views1 answer
Laravel after method()
PHP Laravel
0 vote123 views1 answer
How to pass token with post request laravel
PHP Laravel
3 votes123 views2 answers
Name csrf token laravel mismatch
PHP Laravel