DEV Community

Cover image for How To Fetch Resources Randomly in Laravel with a Single Line Of Code.
Funke Olasupo
Funke Olasupo

Posted on • Originally published at roxie.hashnode.dev

How To Fetch Resources Randomly in Laravel with a Single Line Of Code.

Have you encountered a challenge where you need to fetch records from the database in no particular order using Laravel?

I found myself at this point once and here is how I solved it. All thanks to dear Google!๐Ÿ˜

This is a regular SQL query to fetch records randomly:

select * from `users` order by RAND() ```



But in Laravel, there is a method named

 ```inRandomOrder()```

 which simply fetches the records in random order.

Here is a list of the few ways this method can be used:




```PHP

//Fetch all records in random order
Model::inRandomOrder()->get();

// 5 indicates the number of records
Model::inRandomOrder()->limit(5)->get();

//Fetc all records in pages or sets of 6
Model::inRandomOrder()->paginate(6)->get();

// get one random record
Model::inRandomOrder()->first()
Enter fullscreen mode Exit fullscreen mode

The helper method can also be used like this:

Model::where('name',$name)->inRandomOrder()->get();
Enter fullscreen mode Exit fullscreen mode

PS: The inRandomOrder() method can also be used alongside other helper methods for fetching records like paginate() and limit().

Thats It!๐Ÿ˜

I trust this will be of great assistance๐Ÿฅฐ. I would also love to learn more about this so please feel free to drop your comments or send a direct message on twitter.
Questions are welcomed. Don't forget to connect with me on socials.๐Ÿ˜Ž

Thank you๐Ÿ˜Ž

Top comments (6)

Collapse
 
ojpro1 profile image
Oussama ELJabbari • Edited

Thanks you.
I will use it in a project that I am working on

Collapse
 
roxie profile image
Funke Olasupo

Thats amazing, thank you.

Collapse
 
ojpro1 profile image
Oussama ELJabbari

I used it today ๐Ÿ˜…

Thread Thread
 
roxie profile image
Funke Olasupo

Amazing๐Ÿ’ช, I'm open to futher discussions

Collapse
 
jovialcore profile image
Chidiebere Chukwudi

Thanks for sharing

Collapse
 
roxie profile image
Funke Olasupo

Thank you