Laravel - Has many relationship not working inside foreach loop

Question

I have a HasMany relationship that works on the whole site. Just made a new controller and in this controller I have this inside a method:

  // find all galleries that need to be deleted...
    $galleries = DB::table('galleries')->where('curdeldate', '<', time())->get();

    foreach($galleries as $gallery)
    {            

        //get all the images associated with the gallery
        $photos = $gallery->photos;

this throws this message: ErrorException Undefined property: stdClass::$photos but I cannot figure out why...

I also included this:

use App\Gallery;
use App\Photo;

actually that can'T work because you use DB facade... that's like getting raw data from table... it's not connected with anything... no relationships... — lewis4u
– lewis4u, Commented Apr 18, 2020 at 14:09

lewis4u · Accepted Answer · 2020-04-18 14:13:13Z

1

You should use:

$galleries = Gallery::where('curdeldate', '<', time())->get();

foreach($galleries as $gallery)
{            
    $photos = $gallery->photos;

.............

answered Apr 18, 2020 at 14:13

lewis4u

15.3k22 gold badges116 silver badges161 bronze badges

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

2 Comments

sharkyenergy Over a year ago

Thank you very much it worked.. coudl you please explain what the difference is? why the other one does not work?

lewis4u Over a year ago

When you use DB facade it's like you are using raw SQL... SELECT * FROM 'galleries' and you get only data from that table... the photos are in the 'photos' table and you would have to use join photos to get the photos also... You could make it work also with DB:: but I find this approach much cleaner and since you already have the Eloquent models why not to use them.

Collectives™ on Stack Overflow

Laravel - Has many relationship not working inside foreach loop

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related