/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

0 vote186 views1 answer
Change the date format in laravel view page
PHP Laravel
0 vote190 views3 answers
Laravel migration softdelete
PHP Laravel
0 vote202 views1 answer
Laravel run seeder enter timestamps
PHP Laravel
0 vote187 views1 answer
Show data from a table in laravel 8
PHP Laravel
2 votes199 views2 answers
How to use stored procedure in laravel
PHP Laravel
4 votes184 views4 answers
Delete all rows from table laravel
PHP Laravel
3 votes215 views1 answer
Laravel get project root
PHP Laravel
0 vote194 views1 answer
Beanstalk run laravel command
PHP Laravel
-1 vote196 views2 answers
Laravel model save get id
PHP Laravel
1 vote225 views1 answer
Edit data using model in laravel 8
PHP Laravel