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 on

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

Collapse
roxie profile image
Funke Olasupo Author

Thats amazing, thank you.

Collapse
ojpro1 profile image
Oussama ELJabbari

I used it today πŸ˜…

Thread Thread
roxie profile image
Funke Olasupo Author

AmazingπŸ’ͺ, I'm open to futher discussions

Collapse
jovialcore profile image
Chidiebere Chukwudi

Thanks for sharing

Collapse
roxie profile image
Funke Olasupo Author

Thank you

🌚 Friends don't let friends browse without dark mode.

Sorry, it's true.