Laravel eloquent how to display data from 2 table

Question

I have 2 tables, product and promotion. I do not know how I can display the price of both product and promotion(price after discount) based on product_id in blade. In blade i can only display price for promotion using {{$promotion->price}}

Product Table

id - name - price

Promotion Table

id product_id - price - discount

Controller:

 $latestProduct = Promotion::orderBy('created_at', 'desc')
    ->with('product')
    ->take(20)
    ->get();

Model:

Product Model

public function promotion()
{
   return $this->hasMany('App\Model\Promotion');
}

Promotion Model

public function product()
{
    return $this->belongsTo('App\Model\Product');
}

online Thomas · Accepted Answer · 2018-12-04 07:24:12Z

2

in blade file:

Edit:

@foreach($latestProduct as $product)
    {{$product->price}}
    {{$product->promotion->price}}
@endforeach

would work.

edited Dec 4, 2018 at 7:24

online Thomas

9,4887 gold badges52 silver badges94 bronze badges

answered Dec 4, 2018 at 7:14

Ali Özen

1,6192 gold badges16 silver badges30 bronze badges

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

Comments

Сергей Игоревич · Accepted Answer · 2018-12-04 07:29:59Z

0

I think it'll be better to make like this:

$latestProducts = Product::orderBy('created_at', 'desc')
->with('promotion')
->take(20)
->get();

And, as mentioned Ali Özen, in your blade file you'll be able to iterate through your products and get product's promotion price with:

$product->promotion->price

answered Dec 4, 2018 at 7:29

Сергей Игоревич

1088 bronze badges

Collectives™ on Stack Overflow

Laravel eloquent how to display data from 2 table

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