Laravel 5.2 Eloquent foreach loop

Vote count: 0

I'm in a controller for Laravel 5.2 and am trying to iterate through an eloquent collection of invoice_items, which would translate to something like order items. So, the invoice would act as the order, have it's ordered items (invoice_item), and the invoice_items would list all of the products ordered (product).

Here's what I have:

$id = $value; //from param
$invoice = Invoice::where('id', $id)->get();
$invoice_items = Invoice_item::all()->where('invoice_id', $invoice[0]->id);

$contact = Contact::where('id', $invoice[0]->contact_id)->get();

foreach($invoice_items as $item) {
    $products = Product::all()->where('id', $item->product_id);
}

I'm attempting to pull all of the products from that specific invoice (via invoice items), which in this specific case should be two, different products.

What's happening, is when I iterate through using that loop, it's adding the same product twice, whereas it should be adding each product once. Is my logic just wrong here? Or do I need to look at my relationships again or something?

asked 26 secs ago

Ben Parsell

Let's block ads! (Why?)

Laravel 5.2 Eloquent foreach loop