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 votes203 views1 answer
Laravel if syntax
PHP Laravel
0 vote221 views1 answer
Create char laravel migration
PHP Laravel
0 vote165 views1 answer
How to check my server use cgi, fcgi or fpm.
PHP
4 votes206 views3 answers
Wp enqueue style for style.css
PHP Wordpress
35 votes197 views5 answers
Remove the Last Character From a String in PHP
PHP
0 vote271 views1 answer
Composer won't use php version for subdomain multiphp
PHP
0 vote168 views2 answers
Concat in where clause laravel query builder
PHP
4 votes164 views2 answers
Php shorthand if isset post
PHP
0 vote204 views1 answer
Argument 1 passed to Symfony\Component\HttpFoundation\Response::setContent() must be of the type string or null, object given, called in
PHP
0 vote201 views1 answer
Redirect to intent url after login laravel
PHP