php json multidimensional array syntax

Question

I have a problem with the JSON I'm creating in PHP; I create the array in a while loop from an sql query. $featuresCSV is a comma-separated string like "1,3,4". In the JSON I need it to end up like feature-1: 1,feature-2: 1,feature-3: 1 The 1 represents true for my checkbox in my front-end program.

while ($stmt2->fetch()) {

  $features = array();
  $featuresTmp = explode(',', $featuresCSV, -1);

  foreach ($featuresTmp as &$featureItem) {
    $features[] = array("feature-" . $featureItem => 1);
  }

  $items[] = array('price' => $price, 'image' => $image, 'features' => $features);
}
...
json_encode($output);

The JSON ends up looking like this:

{"price":8900,
"image":"4d3f22fe-9f1a-4a7e-a564-993c821b2279.jpg",
"features":[{"feature-1":1},{"feature-2":1}]}

but I need it to look like this:

{"price":8900,
"image":"4d3f22fe-9f1a-4a7e-a564-993c821b2279.jpg",
"features":[{"feature-1":1,"feature-2":1}]}

Notice how feature-1 and feature-2 aren't separated by brackets in the second.

SQL Hacks · Accepted Answer · 2016-02-28 02:04:56Z

2

You need to assign the elements at "feature-1" and "feature-2".

foreach ($featuresTmp as &$featureItem) {
   $features["feature-" . $featureItem] = 1;
}

The syntax $feature[] = ... is for appending to the end of an array.

answered Feb 28, 2016 at 2:04

SQL Hacks

1,3321 gold badge10 silver badges16 bronze badges

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

Comments

Josh S. · Accepted Answer · 2016-02-28 02:06:04Z

0

Here ya go

while ($stmt2->fetch()) {

$features = array();
$featuresTmp = explode(',', $featuresCSV, -1);


foreach ($featuresTmp as &$featureItem) {
$features["feature-$featureItem"] = 1;
}

$items[] = array('price' => $price, 'image' => $image, 'features' => $features);
}
...
json_encode($output);

answered Feb 28, 2016 at 2:06

Josh S.

5973 silver badges8 bronze badges

Collectives™ on Stack Overflow

php json multidimensional array syntax

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