/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

8 votes354 views3 answers
Route parameter type laravel
PHP Laravel
0 vote366 views1 answer
Laravel 8 date difference in days
PHP Laravel
0 vote396 views1 answer
Push key and value in laravel
PHP Laravel
0 vote294 views5 answers
Get recoed between two datetime laravel
PHP Laravel
39 votes358 views3 answers
Add column in laravel migration cmnd
PHP Laravel
0 vote317 views2 answers
Laravel download file from s3
PHP Laravel
0 vote342 views1 answer
Laravel signed Route custom domain
PHP Laravel
11 votes314 views5 answers
Laravel model transaction
PHP Laravel
8 votes330 views6 answers
Laravel command not found
PHP Laravel
1 vote347 views1 answer
Laravel blade skip entry
PHP Laravel