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 votes142 views1 answer
Laravel string key
PHP Laravel
0 vote157 views1 answer
Laravel select error
PHP Laravel
0 vote148 views1 answer
Laravel collection get
PHP Laravel
1 vote194 views2 answers
Class name laravel
PHP Laravel
0 vote195 views1 answer
How to set db table type in laravel
PHP Laravel
0 vote183 views1 answer
Laravel count data wise
PHP Laravel
0 vote150 views1 answer
Foreign key cosntraint laravel
PHP Laravel
2 votes160 views2 answers
Laravel eloquent randomise data from database
PHP Laravel
1 vote145 views2 answers
Laravel return response view
PHP Laravel
1 vote160 views1 answer
Not required a field when checked not applicable checkbox in laravel
PHP Laravel