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

1 vote312 views2 answers
Laravel required_if
PHP Laravel
0 vote344 views1 answer
Laravel collection collapse
PHP Laravel
0 vote366 views1 answer
Laravel eloquent get 3 months
PHP Laravel
1 vote346 views1 answer
Laravel eloquent get only field name
PHP Laravel
5 votes285 views3 answers
'mix' is not recognized as an internal or external command
PHP
0 vote295 views1 answer
Merge cell collumn phpOffice
PHP
1 vote329 views1 answer
Convert Carbon Seconds Into Days Hours Minute
PHP
2 votes280 views1 answer
Command to delete storage logs in laravel
PHP
1 vote324 views4 answers
Laravel scheduler run
PHP Laravel
1 vote281 views1 answer
Example code codeigniter seeders
PHP