/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 vote176 views1 answer
Editing items in collection in laravel
PHP Laravel
12 votes184 views2 answers
Tomorrow carbon laravel
PHP Laravel
0 vote195 views1 answer
Payment gateway webhook returning 302 laravel
PHP Laravel
0 vote194 views1 answer
Custom timestamp column laravel
PHP Laravel
0 vote185 views1 answer
Laravel chain query builder
PHP Laravel
5 votes172 views1 answer
Laravel rate limit
PHP Laravel
14 votes169 views4 answers
Laravel transactions eloquent
PHP Laravel
2 votes184 views1 answer
Laravel upload image to public folder
PHP Laravel
5 votes163 views3 answers
Laravel grouping where
PHP Laravel
1 vote181 views1 answer
Laravel model increase the value by one
PHP Laravel