How to create a Eloquent model instance from a raw Object?

Question

I need to make a raw database query using Laravel:

$results = DB::select("SELECT * FROM members 
    INNER JOIN (several other tables) 
    WHERE (horribly complicated thing) 
    LIMIT 1");

I get back a plain PHP StdClass Object with fields for the properties on the members table. I'd like to convert that to a Member (an Eloquent model instance), which looks like this:

use Illuminate\Database\Eloquent\Model;

class Member extends Model {
}

I'm not sure how to do it since a Member doesn't have any fields set on it, and I'm worried I will not initialize it properly. What is the best way to achieve that?

Answer 1

You can try to hydrate your results to Model objects:

$results = DB::select("SELECT * FROM members 
                       INNER JOIN (several other tables) 
                       WHERE (horribly complicated thing) 
                       LIMIT 1");

$models = Member::hydrate( $results->toArray() );

Or you can even let Laravel auto-hydrate them for you from the raw query:

$models = Member::hydrateRaw( "SELECT * FROM members...");

EDIT

From Laravel 5.4 hydrateRaw is no more available. We can use fromQuery instead:

$models = Member::fromQuery( "SELECT * FROM members...");