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

2 votes227 views1 answer
Laravel get list of columns in a table
PHP Laravel
6 votes278 views1 answer
Laravel route param blade
PHP Laravel
1 vote284 views1 answer
How refresh the record of data in laravel
PHP Laravel
0 vote257 views2 answers
Save big data with laravel
PHP Laravel
1 vote187 views1 answer
Laravel validation on fields inside array in request
PHP Laravel
0 vote220 views2 answers
Gate and policy in laravel
PHP Laravel
2 votes223 views2 answers
Laravel get public path url
PHP Laravel
3 votes218 views2 answers
Error handling in laravel
PHP Laravel
0 vote222 views1 answer
Laravel compile assets
PHP Laravel
1 vote218 views1 answer
Laravel word count utf8
PHP Laravel