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 votes316 views1 answer
Permissions on ssh
PHP
20 votes327 views6 answers
Sort array php by key
PHP
0 vote324 views1 answer
Symfony refresh endpoints
PHP
0 vote364 views2 answers
Foreach array for 3 or more
PHP
1 vote344 views2 answers
Magento2 zend log
PHP
4 votes388 views2 answers
Duplicate record laravel
PHP
1 vote340 views3 answers
Laravel syncwithoutdetaching
PHP
0 vote320 views1 answer
Laravel - Query Builder Raw Query selectRaw
PHP
5 votes373 views3 answers
Enum table in laravel
PHP Laravel
0 vote362 views1 answer
Laravel mcq questions
PHP Laravel