/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

6 votes205 views6 answers
Laravel get current route url
PHP Laravel
8 votes247 views3 answers
Laravel check record exists
PHP Laravel
0 vote210 views1 answer
Add auth middleware to route laravel
PHP Laravel
8 votes230 views4 answers
Laravel model soft delete
PHP Laravel
1 vote222 views1 answer
Get age with carbon in laravel
PHP Laravel
24 votes313 views6 answers
Laravel create method
PHP Laravel
2 votes215 views1 answer
Custom rule laravel validation
PHP Laravel
3 votes327 views6 answers
Email verification laravel
PHP Laravel
-1 vote234 views2 answers
Laravel pagination keep query string
PHP Laravel
3 votes220 views1 answer
Laravel eloquent get column
PHP Laravel