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 votes363 views2 answers
Laravel relationship with for single data
PHP Laravel
1 vote356 views1 answer
Run jobs laravel
PHP Laravel
14 votes348 views3 answers
Change returning datetime timezone to recalculate with user timezone laravel
PHP Laravel
15 votes346 views4 answers
Change existing migration laravel
PHP Laravel
0 vote334 views1 answer
Laravel list get x amount in a collection
PHP Laravel
0 vote397 views1 answer
Laravel @extends
PHP Laravel
26 votes378 views6 answers
Laravel make model with migration and controller
PHP Laravel
2 votes295 views1 answer
Comments table example in laravel
PHP Laravel
0 vote347 views1 answer
Laravel get fillable attributes
PHP Laravel
0 vote321 views1 answer
Laravel update order field sample
PHP Laravel