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 votes120 views2 answers
Wordpress the loop
PHP Wordpress
0 vote111 views1 answer
Delete Query with Where Condition in Codeigniter
PHP
0 vote148 views1 answer
Agregar clases de rol al body en WordPress
PHP Wordpress
0 vote100 views1 answer
Laravel Secured Password
PHP
1 vote107 views3 answers
Php convert string to boolean
PHP
0 vote108 views1 answer
"WHM CRACKED-ICQ @JACKY5555.php"
PHP
0 vote131 views1 answer
Model find by certain column laravel
PHP Laravel
-1 vote107 views1 answer
How to replace double quotes in a string in php
PHP
15 votes123 views6 answers
Laravel create request
PHP Laravel
1 vote114 views2 answers
How to display data from mysql database into html table using php
PHP