Laravel DB mysql select where column exists in array?

Question

I send an array to my API made in Laravel 5 which is an array of allowed values ex: [1,3,5]

I try to do the select like this:

$json = (object)Input::all();

$loans = DB::table("loans")
         ->where("years", ">=", $json->year_low)
         ->where("years", "<=", $json->year_high)
         ->where("risk", $json->risks)
         ->get();

risks is the array.

What I receive from the database is and empty array.

In a test I send every possible value 0...4 but I receive an empty array.

How can I select a row which a column's value exists inside an array?

whereIn() perhaps?

Andrei
– Andrei

2015-07-01 11:30:18 +00:00
Commented Jul 1, 2015 at 11:30 — Andrei
– Andrei, Commented Jul 1, 2015 at 11:30

pinkal vansia · Accepted Answer · 2015-07-01 11:30:05Z

7

If you meant $json->risks is array like [1,2,3], try following

->whereIn("risk", $json->risks)

Comments

Bhavin Solanki · Accepted Answer · 2015-07-01 11:42:36Z

3

I have made some changes in your script :

$json = (object)Input::all();

$loans = DB::table("loans")
     ->where("years", ">=", $json->year_low)
     ->where("years", "<=", $json->year_high)
     ->whereIn("risk", array($json->risks))
     ->get();

This will work and you will get the array of values.

answered Jul 1, 2015 at 11:42

Bhavin Solanki

4,8143 gold badges28 silver badges47 bronze badges

Collectives™ on Stack Overflow

Laravel DB mysql select where column exists in array?

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