How to select and get data from multiple tables (Laravel)

Question

I want to retrieve data from multiple rows through Laravel Eloquont:

Here is what i have tried:

        $currUser = Auth::User();
        ### search
        
        
        $output_product = $currUser->table('products')
            ->join('product_variants', 'products.product_id', '=', 'product_variants.product_id')
            ->join('product_images', 'product_vairants.id', '=', 'product_images.vairant_id')
            ->select('products.title', 'products.description', 'product_variants.price', 'product_variants.quantity', 'product_images.imgurl')->where('products.product_id', $product_id)
            ->get();        
        return $output_product;
                        
        }

But this function is not returning anything,

i am adding a query here which is working fine:
$output_product = $currUser->products()->where('product_id', $product_id)->first();

Thanks

typos in your second join (vairant)?

kopz
– kopz

2020-08-14 12:00:08 +00:00
Commented Aug 14, 2020 at 12:00 — kopz
– kopz, Commented Aug 14, 2020 at 12:00

Virendra Nagda · Accepted Answer · 2020-08-14 12:21:21Z

3

Thorugh query builder you can do this like:

$output_product = DB::table('products')
->select('products.title', 'products.description', 'product_variants.price','product_variants.quantity', 'product_images.imgurl')
->join('product_variants', 'products.product_id', '=', 'product_variants.product_id')
->join('product_images', 'product_vairants.id', '=', 'product_images.vairant_id')
->where('products.product_id', $product_id)
->get();
return $output_product;

And if you want to do with Eloquont.you need to define all the relationships in the respective Model classes

answered Aug 14, 2020 at 12:21

Virendra Nagda

6585 silver badges10 bronze badges

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

Comments

Egzon Hasi · Accepted Answer · 2020-08-14 11:54:28Z

0

You should do it like;

DB::table('')....

make a join with user-s table and in the end and a where user id is equal to $currUser->id

answered Aug 14, 2020 at 11:54

Egzon Hasi

813 bronze badges

Collectives™ on Stack Overflow

How to select and get data from multiple tables (Laravel)

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related