show in random order initially

Try

Gallery::all()->random(50); 

I also found: https://laracasts.com/discuss/channels/eloquent/laravel-52-inrandomorder-and-pagination-is-there-an-alternative-to-orderbydbrawrandaseed?page=0

thanks but now I'm getting: Method Illuminate\Database\Eloquent\Collection::links does not exist

@boyjarv you can shuffle the results in the view using javascript on load.

To shuffle an array you can use lodash: https://lodash.com/docs/4.17.15#shuffle

Thanks but how can I use lodash shuffle in my laravel project?

Just explaining for others.....

The problem is that you will get the first 50 in random order, then on page 2, you will get them all in random order again, which could include some of the ones already seen on the first page.

links doesn't exist if you don't paginate. Probably what you want is to determine if something other than the first page is being requested, and only optionally use the inRandomOrder()

I have a complicated solution and a simple solution.

Complicated

• if no set already stored
• Get all IDs in a random order.
• Partition them into sets of 50.
• Store all the partitioned IDs in session
• Use your own paginator to know if you are on page=1 (set 1) or page=2 (set 2)
• Once you have the correct set of 50 IDs, run a query whereIn the set and return to view
• You will need to write your own paginator for the view.

Simple

• add an order column to your Gallery
• run a scheduled task at intervals (hourly or daily) which randomly changes the order value.
• use standard pagination with the records all sorted by the order column (note, within a given period, all users will see the same 'random' order)

Both solutions really assume that you don't have thousands of records, and more like several hundred.