How to get paginated data according to a array of ids in laravel

Question

$ids = [4,3,1,2];
$result = DB::table('products')->where('status',1)->whereIn('id',$ids)->paginate(10);

So here the order of ids [4,3,1,2] in this same order i want paginate data

https://stackoverflow.com/questions/30477915/laravel-pagination-not-working-with-array-instead-of-collection Look into this one. — Sathishkumar Rakkiyasamy, Feb 21 '18 at 05:22

score 1 · Accepted Answer · edited Feb 28 '19 at 06:05

1

Finally i got answer.

$ids = [4,3,1,2];

$ids_ordered = implode(',', $ids);

$result = DB::table('products')->where('status',1)->whereIn('id',$ids)->orderByRaw(DB::raw("FIELD(id, $ids_ordered)"))->paginate(10);

edited Feb 28 '19 at 06:05

Wai Ha Lee

8,598
83
57
92

answered Feb 28 '19 at 06:00

Akash Kumar Verma

3,185
2
16
32

How to get paginated data according to a array of ids in laravel

1 Answers1