Query result from database

Use or instead of and in your where clause

But isn't better to have :

• images table
• students table (with a column classroom_id)
• classroom table
• image_student (to link the many to many relation between both)
• classroom_image (for the same as above between image and classroom)

@Vilfago It makes no difference

In your Student model

public function galleries()
{
        return $this->hasMany(Gallery::class);
}

public function classroom()
{
        return $this->belongsTo(Classroom::class);
}

In Classroom model:

public function galleries()
{
        return $this->hasMany(SharedGallery::class);
}

And than you can do:

Student::with(['galleries', 'classroom.galleries'])->get();

select galleries.id as gid, shared_galleries.id as sid,galleries.student_id, galleries.classroom_id from galleries cross join shared_galleries on galleries.classroom_id=shared_galleries.classroom_id where galleries.student_id=31 or galleries.classroom_id=28

@lanatel How can I add a where condition to the code Student::with(['galeries', 'classroom.galleries'])->get();

to get the data of a student

@vilfago I tried your query, but it resulted in the same duplicated results

@bincy123

Student::where('id', $student_id)->with(['galeries', 'classroom.galleries'])->first();

@lanatel I tried your code and got results from galleries table only

@bincy123 can you dump your result? You should get results from both tables by using $student->galleries and $student->classroom->galleries.

@bincy123 if you don't get any errors, be sure to fill your db tables with data. Maybe you just get empty result

I do have data in database and I got data for $student->galleries , but got the error 'Trying to get property of non-object' while printing $student->classrooms->galleries

This is my Student model :

public function classrooms(){
    return $this->belongsTo('App\Classroom');
}

public function galleries(){
    return $this->hasMany('App\Gallery');
}

And this is my Classroom model:

public function users(){
    return $this->belongsToMany('App\User');
}

public function students(){
    return $this->hasMany('App\Student');
}

public function galleries()
{
    return $this->hasMany('App\SharedGallery');
}

first of all rename you classrooms relation to classroom. And maybe try just get $student->classroom. Are there any results?

Yea now I got the result. But can I use this array of data to paginate them

my actual issue was that I was not able to paginate them while I tried union between these two tables. i need to implement laravel pagination in my set of results. I am facing this issue : https://github.com/laravel/framework/issues/21958

If your objective is to have x image per page that come from shared image or not, I think my suggestion of database will make your life easier.

If you can't change it, you probably must create your own pagination as you have to paginate from 2 different tables.

@Vilfago Would you mind sharing your suggestion of database??

I thought my first reply was enough, but here more information :

Tables

| images |
| -- | -------- | ----- |
| id | alt_text | image |

| students |
| -- | ---- | ------------ |
| id | name | classroom_id |

| classrooms |
| -- | ---- | --- |
| id | name | ... |

| image_student |
| -------- | ---------- |
| image_id | student_id |

| classroom_image |
| -------- | ------------ |
| image_id | classroom_id |

| image_user |
| -------- | ------- |
| image_id | user_id |

Models

class Image extends Model {

    public function users(){
        return $this->belongsToMany('App\User');
    }

    public function students(){
        return $this->belongsToMany('App\Student');
    }

    public function classrooms(){
        return $this->belongsToMany('App\Classroom');
    }
}

class Student extends Model {

    public function images(){
        return $this->belongsToMany('App\Image');
    }

    public function students(){
        return $this->belongsTo('App\Classroom');
    }
}

class Classroom extends Model {

    public function students(){
        return $this->hasMany('App\Student');
    }

    public function images(){
        return $this->belongsToMany('App\Image');
    }
}

Query

$studentId = 31;
$student_with_images = Student::with('images')
    ->with('classroom.images')
    ->find($studentId);
dd($student_with_images);

I didn't test it, just wrote in this post. Hope it works without error.