how to fetch data from multiple tables in laravel

Question

I have three tables
1. users
id
name
email
2. Listings
id
user_id
name
3 ListingImage
id
list_id
image

Here i want a data in one query. where all data fetched based on users table (id) . i want data something like that

enter code here
 Array
(
    [user] => Array
        (
            [id] => 1
            [name] =>abc
            [email] => [email protected]
            [listing]=>
                    Array
                    (
                        [id] => 1
                        [user_id] => 1
                        [name] => abc list
                        [listingimage] =>

                            [0] => Array
                                (
                                    [id] => 1
                                    [list_id] => 1
                                    [image] => abc.jpg
                                )
                                [1] => Array
                                (
                                    [id] => 2
                                    [list_id] => 1
                                    [image] => abc.jpg

                                )

                     )
                )
            )

i have used hasMany but it will not give me accurate result can anyone help me

Mahfuzul Alam · Accepted Answer · 2016-11-07 11:56:07Z

2

Considering relations are one to many and you've Listing model class and ListingImage model class for Listings table ListingImage table respectively.

In your User model

public function listings()
{
    return $this->hasMany(Listing::class);
}

In your Listing Model

public function images()
{
    return $this->hasMany(ListingImage::class, 'list_id', 'id')
}

And now

$user = User::with('listings.images')->findOrFail($id);

will give you your desired results.

You can find more details here: https://laravel.com/docs/5.3/eloquent-relationships#one-to-many

answered Nov 7, 2016 at 11:56

Mahfuzul Alam

3,17716 silver badges15 bronze badges

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

3 Comments

kunal Over a year ago

work fine Mahfuzul Alam. Now i am facing one problem i want only one listing with multiple images. it returns me listing index start with 0

Mahfuzul Alam Over a year ago

if you want only one listing then change hasMany to hasOne in listings() relation. Simple!

kunal Over a year ago

Thank you so much :) it means a lot :)

Collectives™ on Stack Overflow

how to fetch data from multiple tables in laravel

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related