/PHP/Laravel/Laravel get next and previous record

Laravel get next and previous record

// get next record of current record
$next = Model::select('id AS next')->where('id', '>', /*current_id*/)->min('id');
// get previous record of current record
$previous = Model::select('id as previous')->where('id','<', /*current_id*/)->max('id');

Similar codes

1 vote153 views1 answer
How to catch query exception in laravel 8
PHP Laravel
0 vote144 views1 answer
Laravel route match
PHP Laravel
0 vote104 views1 answer
Laravel showing index of problem
PHP Laravel
0 vote171 views1 answer
Laravel collection namespace
PHP Laravel
1 vote149 views2 answers
How to pass parameter in routes of laravel
PHP Laravel
3 votes160 views2 answers
Different days in carbon laravel between different dates
PHP Laravel
19 votes143 views4 answers
Laravel bootstrap auth
PHP Laravel
2 votes160 views1 answer
Laravel-ckeditor
PHP Laravel
1 vote156 views2 answers
How to remove token while logout using laravel 8
PHP Laravel
4 votes145 views4 answers
Delete all rows from table laravel
PHP Laravel