php - 不应静态调用非静态方法 Illuminate\Support\Collection::where()

Question

我尝试获取如下数据数组:

$coupons = $user->coupons::where('is_activated_flg', 1)->where('is_used_flg', 0)->lists('amount');

我有这个错误:

Non-static method Illuminate\Support\Collection::where() should not be called statically

你能告诉我问题是什么吗？

Answer 1

你可能想把它改成这样:

$couponQuery = $user->coupons()->where('is_activated_flg', 1)->where('is_used_flg', 0);
$couponCollection = $couponQuery->get();

..或合并:

$coupons = $user->coupons()->where('is_activated_flg', 1)->where('is_used_flg', 0)->get();

如果您使用的是 Laravel 5.1 或稍低版本，您可能需要考虑使用 pluck 而不是列表: https://laravel.com/docs/5.1/collections#method-pluck

$plucked = $collection->pluck('name');
$plucked->all();