Convert Laravel Query builder to Eloquent builder

Question

Because get() function of Query builder returns an array while I need A collection, is there a way to convert Laravel Query Builder to Eloquent Builder?

$query_builder = DB::table('table1');

// different than
$eloquent_builder = Table1Model::select()

You can create a collection from an array: Collection::make($query_builder). Here is a usage sample: stackoverflow.com/questions/33449387/… — Iamzozo
– Iamzozo, Commented Nov 10, 2015 at 14:00

Joseph Silber · Accepted Answer · 2015-11-10 14:27:31Z

9

Laravel ships with a collect helper to convert an array to a collection:

$collection = collect(DB::table('table1')->get());

There's a proposal on Github to have the next version of Laravel return collection instances from the query builder's get method.

answered Nov 10, 2015 at 14:27

Joseph Silber

221k59 gold badges369 silver badges292 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

asmmahmud Over a year ago

As in laravel 5.4 and 5.5 Query Builder (DB::table) returns collection

Collectives™ on Stack Overflow

Convert Laravel Query builder to Eloquent builder

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related