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 vote226 views1 answer
Creating default object from empty value laravel
PHP Laravel
0 vote206 views1 answer
Model find by certain column laravel
PHP Laravel
1 vote229 views1 answer
String to uppercase laravel
PHP Laravel
0 vote219 views1 answer
Laravel fetch max value
PHP Laravel
6 votes296 views1 answer
In order to use the Auth::routes() method, please install the laravel/ui package.
PHP Laravel
6 votes223 views2 answers
Laravel check if request has value
PHP Laravel
2 votes233 views1 answer
Laravel get only the Ids of an eloquent arrays
PHP Laravel
7 votes228 views1 answer
Laravel eloquent date range
PHP Laravel
0 vote229 views1 answer
Rule for radio button in laravel
PHP Laravel
2 votes223 views1 answer
Laravel abort
PHP Laravel