How to get collection by array of IDs

594 0 0 0

Last Updated : 2024-04-20 15:57:20

At this snippet I will teach you how to get laravel collection with your wanted records by using an array of IDs with default sorting and disabled sorting

If you have an array of IDs and want to get all records belongs to these IDs in laravel eloquent you can use 2 expressions like this :


First (Default collection sorting)


$finalRecords = Triple::find($recordsArray); // change records array to your array of IDs
$finalRecords = Triple::whereIn('id', $recordsArray)->get(); // change records array to your array of IDs

Second (without sorting or keep sorting of your array)


$finalRecords = Triple::whereIn('id', $recordsArray)->orderByRaw("field(id,".implode(',',$recordsArray).")")->get();  // change records array to your array

Mahmoud Anwar

Mahmoud Anwar

Back End Developer with a passion for developing innovative web applications that expedite the efficiency and effectiveness of organizational success. Well-versed in technology and writing code to create systems that are reliable and user-friendly. Also has the proven ability to motivate, educate, and collaborate effectively to build web applications and effectively track changes. Confident communicator, strategic thinker, and innovative creator to develop software that is customized to meet a company’s organizational needs, highlight their core competencies, and further their success.