Laravel. Eloquent query

Question

I got this query:

$users = DB::table('users')->whereExists(function($query)
        {
            $query->select(DB::raw(1))
               ->from('galleries')
               ->whereRaw('galleries.user_id = users.id');
        })->get();

This query selects all users who have gallery. Problem is that I can't use eloquent releationships now. Whenever i try to loop like this:

@foreach ($user->gallery as $gallery)
    {{$gallery->name}}      
@endforeach

I get error:

Undefined property: stdClass::$gallery

It happens with all other tables. What am I doing wrong here? My realationships are defined and they work just fine, i got problems only in this query. Thanks.

EDIT
Since it's not eloquent query, could you show me example how to write query, into few tables with eloquent. For example, I need all users who have their status approved in example table

You're not selecting from the User model, you're selecting from DB::table('users'). — Joel Hinz
– Joel Hinz, Commented Jun 30, 2015 at 10:19
You're not using eloquent here, you're using fluent, 2 different things. If users and galeries are in a relation, you shouldn't need to do this to being with. — Andrei
– Andrei, Commented Jun 30, 2015 at 10:20
Thanks. So could you show me an example how do i write eloquent query for 2 tables? Since I need only those users, who have gallery? It's just example, in real time project I have to pick all users, where galleries have status approved. — Evaldas Butkus
– Evaldas Butkus, Commented Jun 30, 2015 at 10:25
I manage to do it by myself. I used User:: instead of DB::table('users'). Thanks for help. — Evaldas Butkus
– Evaldas Butkus, Commented Jun 30, 2015 at 11:39

sunny_skellington · Accepted Answer · 2015-06-30 11:42:22Z

3

First, determine a relationship in the User class, like this:

class User {
    // Determine relation to Example table
    public function examples() {
        return $this->hasMany('Example', 'user_id', 'id'); // second parameter is the foreign key
    }
}

Then the query:

User::whereHas('examples', function( $query ) {
    $query->where('status','approved');
})->get();

answered Jun 30, 2015 at 11:42

sunny_skellington

4062 silver badges4 bronze badges

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

Collectives™ on Stack Overflow

Laravel. Eloquent query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related