Level 102
Try adding a seed
$products = Product::where('id',$id)->inRandomOrder('foobar')->paginate(10)
3 likes
Nov 2, 2019
8
Level 2
inRandomOrder with paginate returns duplicated records
Hi, I want to show the data for one of my models in a random order, the easiest way was to write it like this:
$products = Product::where('id',$id)->inRandomOrder()->paginate(10);
Now, this work perfectly for the first page, but sometimes I see the same data in other pages. Is there a better way to get the desired result without duplicates ?
Level 1
I'm sorry, what the meaning is 'foobar' ? thx
Level 1
Hello @masiseng7, 'foobar' is a column in the table.
Level 3
@Elias Fonseca If you use a table column here then the records will never be randomised - always the same results. This is what I ended up doing, perhaps not the best way, but here it is:
// Seed should be integer (although table column is accepted for some reason??)
if(!session()->exists('table_order')) {
session()->put('table_order', rand(0, 999999));
}
$seed = session('table_order');
...
->inRandomOrder($seed)
Level 2
That did it ! Thank you !
Why isn't that in the documentation tho?
Level 102
It think the documentation would be way to long if everything was in there. Always check the api when using a new method
https://laravel.com/api/6.x/Illuminate/Database/Query/Builder.html#method_inRandomOrder
1 like
Level 2
I will. Thank you again
Please or to participate in this conversation.