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

-1 vote277 views2 answers
How to pass value from one php page to another using session
PHP
4 votes284 views2 answers
Redirect back in codeigniter
PHP
2 votes277 views4 answers
Php sort reverse
PHP
0 vote267 views1 answer
Area of a circle segment in php
PHP
3 votes318 views3 answers
Laravel sort by function'
PHP Laravel
2 votes284 views3 answers
Codeigniter last insert id
PHP
1 vote264 views1 answer
Read xml $_POST
PHP
6 votes537 views2 answers
Laravel check if request has value
PHP
0 vote276 views1 answer
Toarray php
PHP
14 votes316 views3 answers
Unset php return array
PHP