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 vote226 views5 answers
Laravel create multiple models at once
PHP Laravel
10 votes210 views2 answers
Array to string conversion in laravel controller
PHP Laravel
1 vote167 views1 answer
Laravel dynamic page title
PHP Laravel
18 votes199 views6 answers
Laravel form validation
PHP Laravel
0 vote180 views1 answer
Update onlu one column laravel
PHP Laravel
0 vote222 views1 answer
Laravel env pgsql
PHP Laravel
0 vote233 views1 answer
Laravel get all vendor files
PHP Laravel
0 vote177 views1 answer
How can we check in the table in comma separated values in laravel
PHP Laravel
0 vote137 views1 answer
Singular from table laravel
PHP Laravel
1 vote170 views2 answers
Laravel query relationship nested
PHP Laravel