Laravel - Undefined index in query builder

Question

I have the following array which I want to pass all values for "main_id" key to whereNotIn condition:

array:7 [
  0 => array:1 [
    "main_id" => "KWS1354767"
  ]
  1 => array:1 [
    "main_id" => "KWS1348470"
  ]
  2 => array:1 [
    "main_id" => "KWS1300790"
  ]
  3 => array:1 [
    "main_id" => "KWS1267286"
  ]
  4 => array:1 [
    "main_id" => "KWS1260614"
  ]
  5 => array:1 [
    "main_id" => "KWS1259115"
  ]
  6 => array:1 [
    "main_id" => "KWS1145684"
  ]
]

My code in controller is the following:

$search = $search->select("properties.prop_id as main_id")->get();
$searcharray = $search->toArray();
$prop_cnt = DB::table("offerdemandsmatchs")->whereNotIn('prop_id', $searcharray['main_id'])
            ->where('offerdemand_id', $o->id)
            ->get();

The error I get is:

ErrorException  : Undefined index: main_id

If I manually pass the array it works:

$prop_cnt = DB::table("offerdemandsmatchs")->whereNotIn('prop_id', ['KWS1354767', 'KWS1348470', 'KWS1300790'])
           ->where('offerdemand_id', $o->id)
           ->get();

I can't get values from array and if I pass the values as in the first statement it fails. How can I pass array values as I'm doing it manually? Do I have to pass a collection?

Regards

Dilip Hirapara · Accepted Answer · 2020-03-17 09:07:58Z

2

Use pluck instead of select and then convert into an array.

Pluck method will create an array for you. check method pluck

$prop_ids = $search->pluck('prop_id');
//$prop_ids = ['KWS1354767','KWS1348470'..];
$prop_cnt = DB::table("offerdemandsmatchs")->whereNotIn('prop_id', $prop_ids)
            ->where('offerdemand_id', $o->id)
            ->get();

edited Mar 17, 2020 at 9:07

answered Mar 17, 2020 at 9:03

Dilip Hirapara

15.4k3 gold badges34 silver badges56 bronze badges

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

1 Comment

Dilip Hirapara Over a year ago

Glad to help you :)

Mihai Matei · Accepted Answer · 2020-03-17 09:03:09Z

1

It is not working because you pass the wrong array to the statement.

What you must do is to use array_column on the search array:

DB::table("offerdemandsmatchs")
    ->whereNotIn('prop_id', array_column($searcharray, 'main_id'))
    ->where('offerdemand_id', $o->id)
    ->get();

answered Mar 17, 2020 at 9:03

Mihai Matei

24.3k5 gold badges34 silver badges50 bronze badges

Collectives™ on Stack Overflow

Laravel - Undefined index in query builder

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related