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

2 votes159 views1 answer
When image update laravel delete remove image
PHP Laravel
3 votes151 views5 answers
Laravel delete multiple rows
PHP Laravel
3 votes153 views1 answer
Laravel validation greater than or equal to
PHP Laravel
1 vote140 views2 answers
How set field after another field in migration in laravel
PHP Laravel
0 vote130 views1 answer
Php excel to array
PHP
0 vote111 views1 answer
How to delete a row in phpmyadmin
PHP
3 votes125 views2 answers
Seconds to minutes php
PHP
0 vote161 views1 answer
Parameters inside Laravel localized string
PHP Laravel
0 vote142 views1 answer
Laravel where false
PHP Laravel
2 votes152 views2 answers
Update laravel 7 to 8
PHP Laravel