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

16 votes325 views6 answers
Laravel group routes
PHP Laravel
4 votes410 views2 answers
Validate year laravel
PHP Laravel
0 vote306 views2 answers
Php 5.6 xampp
PHP
0 vote343 views1 answer
Ubuntu 18.04 php is not working
PHP
4 votes335 views2 answers
Get permalink by id wordpress
PHP
0 vote333 views3 answers
Php date + 30 days
PHP
0 vote299 views1 answer
Year shortcode
PHP
15 votes328 views6 answers
Php convert string to date
PHP
1 vote294 views1 answer
Php assign value to object
PHP
13 votes320 views6 answers
Read csv file in php
PHP