Laravel Eloquent Query Using WHERE with AND orWhere

Question

I am beginner in Laravel. In use in my project Laravel 5.8. I have this array:

array:4 [
  0 => 1
  1 => 3
  2 => 4
  3 => 5
]

and function:

public function getPaymentMethods(array $paymentId)
    {
            dd($paymentId);
            return PaymentSettings::where('id', '=', $paymentId)->get();
    }

It's not working because in $paymentId I have array. How can I change my code function to use with array (many where/orWhere)?

I need something like this (but in laravel eloquent):

SELECT * from payment_settings where id = 1 or id = 3 or id = 4 or id = 5.

Rahul · Accepted Answer · 2019-08-28 13:45:28Z

1

You need whereIn,

return PaymentSettings::whereIn('id', $paymentId)->get();

Note: The whereIn method verifies that a given column's value is contained within the given array:

You can see detailed documentation here.

answered Aug 28, 2019 at 13:45

Rahul

18.6k7 gold badges43 silver badges64 bronze badges

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

Comments

Adesh Khanna · Accepted Answer · 2019-08-28 14:11:11Z

0

where clause is not used to searche from array, whereIn is used. Usage -

return PaymentSettings::whereIn('id', $paymentId)->get();

answered Aug 28, 2019 at 14:11

Adesh Khanna

2623 silver badges9 bronze badges

Collectives™ on Stack Overflow

Laravel Eloquent Query Using WHERE with AND orWhere

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related