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 votes202 views3 answers
Spartie all user with role get laravel
PHP Laravel
2 votes218 views1 answer
Laravel's collection pagination
PHP Laravel
1 vote229 views1 answer
Update many laravel
PHP Laravel
0 vote206 views1 answer
Laravel array to string error
PHP Laravel
0 vote197 views1 answer
Laravel select option form add please select option
PHP Laravel
5 votes243 views2 answers
Laravel naming conventions
PHP Laravel
0 vote203 views1 answer
Server error in laravel
PHP Laravel
3 votes142 views1 answer
Count array laravel
PHP Laravel
8 votes305 views2 answers
Laravel drop multiple columns
PHP Laravel
0 vote201 views1 answer
Laravel storage goes to 404 page. (Symlink not working)
PHP Laravel