Laravel Eloquent - Using array in find() method

Question

I have three tables - users, products and orders There is a relation between users and orders (users has many orders).

orders table contains product_id and user_id column.

Now I want to access the product details of orders for a user.

What I am trying:

public function myOrders(){
    $orders = Auth::user()->orders->pluck('product_id');
    $products = Product::find($orders);
    return view('shop.myorders', compact('products'));
}

But this is not working. Can anyone help me? What other way can be better to achieve this?

Find is the same as where('id', '=', ?)->first(). Use ->get() and whereIn() instead. — aynber
– aynber, Commented Apr 24, 2017 at 16:43

aynber · Accepted Answer · 2017-04-24 16:45:04Z

3

As mentioned, find() will always return 1 item, and expects a string/int for the parameter. You want to use where and get instead. With an array of ids, you can use whereIn.

public function myOrders(){
    $orders = Auth::user()->orders->pluck('product_id');
    $products = Product::whereIn('id', $orders)->get();
    return view('shop.myorders', compact('products'));
}

answered Apr 24, 2017 at 16:45

aynber

23.2k9 gold badges57 silver badges69 bronze badges

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

2 Comments

Sunny Kumar Over a year ago

Thanks your solution worked. But laravel documentation says that we can use an array as parameter to call find() method to get matching results- laravel.com/docs/5.4/eloquent#retrieving-single-models

aynber Over a year ago

Ah, I see that they added that in 5.2. I'll have to remember that.

Alexey Mezenin · Accepted Answer · 2017-04-24 16:45:20Z

2

I assume you have orders() relation defined in the Product model:

public function orders()
{
    return $this->hasMany(Order::class)
}

Then you'll be able to load products from all user's orders:

$products = Product::whereHas('orders', function($q) {
        $q->where('user_id', auth()->id())
    })->get();

answered Apr 24, 2017 at 16:45

Alexey Mezenin

164k27 gold badges309 silver badges287 bronze badges

Collectives™ on Stack Overflow

Laravel Eloquent - Using array in find() method

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related