/PHP/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

2 votes126 views1 answer
Laravel model truncate
PHP
14 votes124 views2 answers
Enable php error
PHP
2 votes150 views2 answers
Laravel include config
PHP Laravel
1 vote129 views2 answers
Php bulk insert mysql
PHP
0 vote140 views1 answer
Multi-idiomas com PHP
PHP
8 votes251 views5 answers
Codeigniter 4 redirect with data
PHP CodeIgniter
0 vote132 views1 answer
Add like and equal in same query in laravel
PHP
4 votes147 views2 answers
Ubuntu laravel storage permission
PHP
1 vote131 views1 answer
Get taxonomy name in singhle post
PHP
4 votes174 views2 answers
Cascade in laravel migration
PHP Laravel