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

5 votes161 views2 answers
Laravel encrypt decrypt
PHP Laravel
6 votes158 views2 answers
Create migration model and seeder laravel at once
PHP Laravel
1 vote185 views1 answer
Laravel descending order paginate eloquent
PHP Laravel
6 votes158 views2 answers
Laravel migration make column nullable
PHP Laravel
1 vote175 views3 answers
Laravel api enable cors
PHP Laravel
1 vote190 views2 answers
Laravel update email unique
PHP Laravel
0 vote181 views1 answer
Laravel return a single dimensional array
PHP Laravel
15 votes185 views6 answers
Confirm password validation in laravel
PHP Laravel
0 vote179 views1 answer
Maintaining serial number in laravel pagination table
PHP Laravel
0 vote176 views1 answer
Rawbetween in laravel
PHP Laravel