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 vote166 views1 answer
Yajra laravel datatables rawcolumn
PHP Laravel
0 vote191 views1 answer
Laravel file permission denied
PHP Laravel
1 vote170 views1 answer
Laravel run query migration
PHP Laravel
3 votes153 views5 answers
Laravel permission
PHP Laravel
0 vote194 views1 answer
Laravel Customizing Missing Model Behavior
PHP Laravel
0 vote172 views1 answer
Token delete laravel
PHP Laravel
5 votes165 views5 answers
Install laravel 8 with composer
PHP Laravel
33 votes235 views6 answers
Migrate specific migration laravel
PHP Laravel
5 votes181 views2 answers
Laravel vue
PHP Laravel
8 votes160 views2 answers
Laravel hash namespace
PHP Laravel