/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 votes273 views2 answers
Laravel migration table column nullable
PHP Laravel
0 vote143 views2 answers
Upload video in laravel
PHP Laravel
0 vote142 views2 answers
The media must not be greater than 12288 kilobytes in laravel
PHP Laravel
0 vote145 views2 answers
How to rollback if one table in laravel didn't save data successfully
PHP Laravel
4 votes146 views2 answers
Display all errors at once in laravel
PHP Laravel
2 votes154 views2 answers
How unset request parameter in laravel
PHP Laravel
0 vote146 views2 answers
Laravel get average from a column
PHP Laravel
5 votes158 views2 answers
Laravel collection chunk
PHP Laravel
1 vote148 views1 answer
How get just one parameter of all objects in one array in laravel
PHP Laravel
7 votes151 views4 answers
Laravel chunk
PHP Laravel