How to array merge in laravel

Question

I have a problem here, I want to combine 2 arrays into 1, I've tried using array_merge from php, and merge () from laravel but nothing works //$plucked is EAV database

$vendor = Vendor::find($id)->toArray();
        $vendor_detail = Vendor_detail::where('vendor_id',$id)->get();
        $plucked = $vendor_detail->pluck('vendor_name','vendor_value');

        $merged = array_merge($plucked, $vendor);

        // $merged = $vendor->merge($plucked)->all(); 
        dd($merged);

I think because the array is different, there array $plucked

#items: array:10 [▼
    "user_email" => "[email protected]"

  ]

and there my array in $vendor


array:15 [▼
  "vendor_id" => 39
  "province" => "ACEH"

]

the output that I want

$somearray =[
   "vendor_id" => 39
  "province" => "ACEH"
  "user_email" => "[email protected]"

]

@albus_severus there's my expected result $somearray =[ "vendor_id" => 39 "province" => "ACEH" "user_email" => "[email protected]" ] — Newbie 123
– Newbie 123, Commented Dec 12, 2019 at 9:48

MEDZ · Accepted Answer · 2019-12-12 10:02:03Z

1

Your $vendor is one associative array while $plucked is an array of arrays. Even if it has only one item it will be of index zero so you need to loop through $plucked and merge for each one.

$vendor = Vendor::find($id)->toArray();
$vendor_detail = Vendor_detail::where('vendor_id',$id)->get();
$plucked = $vendor_detail->pluck('vendor_name','vendor_value');

$merged = [];
foreach($plucked as $p){
    $merged[] = array_merge($p, $vendor);
}
dd($merged);

answered Dec 12, 2019 at 10:02

MEDZ

2,2952 gold badges17 silver badges19 bronze badges

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

Comments

Piyush Shukla · Accepted Answer · 2019-12-12 10:14:46Z

1

$vendor = Vendor::find($id);
$vendor_detail = Vendor_detail::select('vendor_id','province')->where('vendor_id',$id)->get()->toArray();

$data= array_merge($vendor,$vendor_detail);

edited Dec 12, 2019 at 10:14

answered Dec 12, 2019 at 10:08

Piyush Shukla

2542 silver badges12 bronze badges

Comments

Shailesh Matariya · Accepted Answer · 2019-12-12 10:15:47Z

1

I think you should use database join to get faster results.

$vendor = Vendor::join('vendor_details', 'vendors.id', '=', 'vendor_details.vendor_id')
    ->select('vendors.*', 'vendor_name','vendor_value')
    ->where('id', $id)
    ->first();

if ($vendor)  {
    $vendor = $vendor->toArray();
}

answered Dec 12, 2019 at 10:15

Shailesh Matariya

8405 silver badges14 bronze badges

Comments

Prafulla Kumar Sahu · Accepted Answer · 2019-12-12 14:50:14Z

0

  $vendor_detail = Vendor_detail::where('vendor_id',$id)->get(); will give you a collection

as well as $plucked = $vendor_detail->pluck('vendor_name','vendor_value'); will give you a collection, so, either you can use collection merge or you may like to loop through one and add merge another as other answer is doing, but these are not array, you are getting collections.

answered Dec 12, 2019 at 14:50

Prafulla Kumar Sahu

9,75911 gold badges78 silver badges116 bronze badges

Collectives™ on Stack Overflow

How to array merge in laravel

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related