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

8 votes174 views3 answers
Validate time in laravel
PHP Laravel
0 vote203 views1 answer
How to create table for every user in laravel
PHP Laravel
0 vote190 views1 answer
Laravel check if api request
PHP Laravel
0 vote197 views1 answer
How to get meta information from pagination in laravel controller
PHP Laravel
0 vote203 views2 answers
Laravel migration change column order
PHP Laravel
0 vote183 views1 answer
Response()->make laravel pdf
PHP Laravel
5 votes189 views2 answers
Laravel auth namespace
PHP Laravel
0 vote183 views1 answer
Laravel query foreach
PHP Laravel
1 vote186 views1 answer
Laravel 6 make http request
PHP Laravel
1 vote192 views1 answer
Publish config laravel
PHP Laravel