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

0 vote167 views1 answer
Laravel auth without vue or bootstrap
PHP Laravel
0 vote243 views1 answer
Laravel how to query belongsTo relationship
PHP
0 vote197 views2 answers
Wordpress admin redirecting to http
PHP Wordpress
0 vote149 views1 answer
Laravel post index method
PHP
0 vote176 views1 answer
Change initial country + add top countiries on Caldera forms
PHP
10 votes185 views2 answers
Get current date laravel
PHP Laravel
8 votes163 views4 answers
Wordpress enqueue if shortcode
PHP
8 votes182 views2 answers
Laravel passport
PHP Laravel
0 vote357 views1 answer
Drupal 7 db_query example
PHP Drupal
4 votes194 views2 answers
Date_default_timezone_set for india in php laravel
PHP Laravel