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

0 vote331 views1 answer
Call to undefined method Illuminate\\Database\\Eloquent\\Relations\\HasMany::attach()
PHP
40 votes340 views6 answers
Php remove element from array
PHP
0 vote372 views1 answer
Import class route laravel
PHP
0 vote344 views1 answer
Encapsulation in PHP
PHP
1 vote391 views1 answer
Increament single column laravel current value + 1
PHP Laravel
0 vote437 views1 answer
Laravel count without pagination
PHP Laravel
0 vote372 views1 answer
Simple-phpunit --version handling the phpunit-setup event returned with error code 127 on ubuntu
PHP
0 vote385 views1 answer
Add code return block phpstorm
PHP
7 votes346 views2 answers
Modal show not close jquery
PHP
0 vote341 views1 answer
Schema key issue laravel
PHP