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 vote123 views1 answer
Laravel query builder select first
PHP Laravel
3 votes128 views1 answer
Laravel validation pdf
PHP Laravel
2 votes159 views1 answer
Set session after login with laravel
PHP Laravel
1 vote137 views1 answer
Laravel route fallback
PHP Laravel
0 vote116 views1 answer
Import separate graphql file laravel
PHP Laravel
9 votes131 views3 answers
Laravel enum migration
PHP Laravel
0 vote124 views1 answer
Take 10 skip 10 laravel
PHP Laravel
2 votes76 views2 answers
Laravel dump
PHP Laravel
0 vote140 views1 answer
Import local js file laravel
PHP Laravel
3 votes124 views3 answers
Laravel pagination having raw query not working
PHP Laravel