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 votes126 views4 answers
Print last query laravel
PHP Laravel
9 votes113 views3 answers
Laravel image validation
PHP Laravel
0 vote65 views1 answer
How convert the string to int in laravel function event
PHP Laravel
3 votes114 views2 answers
Error handling in laravel
PHP Laravel
0 vote140 views1 answer
<warning>PHP Warning: preg_grep() expects parameter 2 to be array, string given in G:\Office Projects\Luggage Backend\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Concerns \Guards Attributes.php on line 207</warning>
PHP Laravel
0 vote115 views1 answer
Laravel Auth::logoutOtherDevices
PHP Laravel
1 vote117 views1 answer
Laravel format number blade
PHP Laravel
0 vote120 views1 answer
Change the date format in laravel view page
PHP Laravel
3 votes109 views4 answers
Input if not null laravel
PHP Laravel
2 votes108 views4 answers
Laravel where in array
PHP Laravel