PHP Associative Array to JSON

Question

I need to have data output in a very specific format to be used with something.

$product = Product::with('product_attribute_values', 'product_attribute_values.product_attribute_key')->find(2);

$product_decoded = json_decode($product, true);

I need to extract product attribute values into a specific format and it currently looks like:

I wish for it be like:

{
    "Material":"Plastic", 
    "Printing Method":"Pad", 
    "Ink Colour":"Black", 
    "Barrel Colour":"Silver", 
    "Grip Colour":"Black"
}

I have attempted this:

$final_array = array();

foreach($product_decoded['product_attribute_values'] as $pav) {
     $array = [
          $pav['product_attribute_key']['name'] => $pav['name']
     ];

     array_push($final_array, $array);
}

return json_encode($final_array);

This results in data looking like:

[
    {"Material":"Plastic"},
    {"Printing Method":"Pad"},
    {"Ink Colour":"Black"},
    {"Barrel Colour":"Silver"},
    {"Grip Colour":"Black"}
]

How would this be achieved?

do not use array_push, use directly as $final_array[$pav['product_attribute_key']['name']] => $pav['name'] — Vibha Chosla
– Vibha Chosla, Commented Nov 29, 2019 at 11:14
May be - ->plick('product_attribute_values.name', 'product_attribute_key.name')->all() — Sougata Bose
– Sougata Bose, Commented Nov 29, 2019 at 11:35

Martin Dimitrov · Accepted Answer · 2019-11-29 11:13:08Z

3

You can do it like this:

foreach($product_decoded['product_attribute_values'] as $pav) {
     $array[$pav['product_attribute_key']['name']] = $pav['name'];
}

return json_encode($array);

answered Nov 29, 2019 at 11:13

Martin Dimitrov

1,3041 gold badge11 silver badges26 bronze badges

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

Comments

Rwd · Accepted Answer · 2019-11-29 11:26:50Z

3

For something like this you could use collections:

return collect($product_decoded['product_attribute_values'])
    ->pluck('name', 'product_attribute_key.name')
    ->toJson();

Alternatively, you could use the array helpers:

$finalArray = Arr::pluck($product_decoded['product_attribute_values'],'name', 'product_attribute_key.name' );

return json_encode($finalArray);

edited Nov 29, 2019 at 11:26

answered Nov 29, 2019 at 11:20

Rwd

35.3k7 gold badges71 silver badges85 bronze badges

2 Comments

Rwd Over a year ago

@SougataBose I'm not sure it can be as it would trying to access the relationship as a column on the initial table (if I'm not mistaken). The QueryBuilder should ultimately return a collection so it will be possible from that.

Sougata Bose Over a year ago

I meant to ask this. :) . I am not sure too.

JoSSte · Accepted Answer · 2019-11-29 11:15:49Z

You need to have it in an object instead of an array.

$item = array("Material"=>"Plastic", "Printing Method"=>"Pad", "Ink Colour"=>"Black", "Barrel Colour"=>"Silver", "Grip Colour"=>"Black");

echo json_encode($item);

will result in this JSON:

[
    {"Material":"Plastic"},
    {"Printing Method":"Pad"},
    {"Ink Colour":"Black"},
    {"Barrel Colour":"Silver"},
    {"Grip Colour":"Black"}
]

Which is correct JSON array syntax.

In order to get

{
    "Material":"Plastic", 
    "Printing Method":"Pad", 
    "Ink Colour":"Black", 
    "Barrel Colour":"Silver", 
    "Grip Colour":"Black"
}

You would need soemthing like

$item->Material = "Plastic";
$item->PrintingMethod = "Pad";
$item->InkColour = "Black";
$item->Barrel Colour = "Silver";
$item->GripColour = "Black;

json_encode($item);

Collectives™ on Stack Overflow

PHP Associative Array to JSON

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related