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 vote315 views1 answer
Laravel migrate error default character 199 boot
PHP Laravel
1 vote334 views1 answer
Laravel eloquent get only field name
PHP Laravel
3 votes332 views2 answers
How to redirect a particular user role to a page after login laravel
PHP Laravel
6 votes309 views2 answers
Laravel findorfail
PHP Laravel
2 votes328 views2 answers
Laravel custom model primary Key
PHP Laravel
0 vote316 views1 answer
Only get selected value from has many ralation laravel
PHP Laravel
25 votes321 views6 answers
Laravel where
PHP Laravel
63 votes408 views6 answers
Laravel clear cache
PHP Laravel
0 vote354 views1 answer
Back() with errors in laravel
PHP Laravel
0 vote343 views2 answers
Laravel collection reduce
PHP Laravel