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

7 votes209 views2 answers
Laravel carbon get month number
PHP Laravel
0 vote209 views1 answer
Laravel where has query
PHP Laravel
0 vote238 views1 answer
Laravel select error
PHP Laravel
0 vote210 views1 answer
Laravel count data wise
PHP Laravel
10 votes232 views3 answers
For loop in laravel
PHP Laravel
0 vote217 views2 answers
View blade not found in laravel
PHP Laravel
16 votes224 views6 answers
Laravel run migration
PHP Laravel
0 vote202 views1 answer
Laravel parse markdown
PHP Laravel
0 vote200 views1 answer
Laravel controller create command in a folder
PHP Laravel
1 vote250 views1 answer
Laravel hasone users relations
PHP Laravel