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 vote304 views2 answers
Dynamic Carousel in Laravel not working displays only one image
PHP Laravel
0 vote309 views1 answer
Cannot be cast automatically to type integer laravel
PHP Laravel
0 vote287 views1 answer
Laravel Service Unavailable
PHP Laravel
1 vote283 views1 answer
Increment single column laravel
PHP Laravel
16 votes275 views3 answers
Laravel make model along with its controller and migration file
PHP Laravel
1 vote270 views1 answer
How can set defult value for yield in laravel
PHP Laravel
0 vote279 views1 answer
How return cutomize error text the firstOrFail laravel exeption
PHP Laravel
8 votes275 views3 answers
Force delete soft delete laravel
PHP Laravel
0 vote274 views1 answer
Laravel query foreach
PHP Laravel
7 votes286 views2 answers
Php laravel between dates
PHP Laravel