How to create a dynamic JSON array in PHP using multiple for eaches?

Question

I need to generate a JSON Object and push it to a JSON object array using PHP. This is my code.

public function getJSONData()
{
    $csv = $this->getCsvData();

    $finalArray = array();

    // First foreach to iterate the data array.
    foreach ($csv["data"] as $key => $value) {

        // Second foreach to iterate the headlines array.
        $newArray = array();
        foreach ($csv["headlines"] as $index => $headline) {
            // $newArray[$key]->$csv["headlines"] = $value;
            // print_r($headline);
            // print_r($value[$index]);
            // echo " ";
            array_push($newArray, array($headline => $value[$index]));
        }
        echo json_encode($newArray);
        echo "<br>";
        array_push($finalArray, json_encode($newArray));
        
    }
    // dd($finalArray);
}

From this code, I'm getting the following response.

[{"ID":12348},{"Status":1},{"Manufacturere_ID":101},{"Famiy_matchcode":"101-iphone-11"},{"Name":"iPhone 11"},{"Price":639.95}] [{"ID":12348},{"Status":1},{"Manufacturere_ID":101},{"Famiy_matchcode":"101-iphone-11"},{"Name":"iPhone 11"},{"Price":509.95}] [{"ID":12348},{"Status":1},{"Manufacturere_ID":101},{"Famiy_matchcode":"101-iphone-11"},{"Name":"iPhone 11"},{"Price":349.95}] [{"ID":12349},{"Status":1},{"Manufacturere_ID":101},{"Famiy_matchcode":"101-iphone-11"},{"Name":"iPhone 11"},{"Price":639.95}] [{"ID":12349},{"Status":1},{"Manufacturere_ID":101},{"Famiy_matchcode":"101-iphone-11"},{"Name":"iPhone 11"},{"Price":509.95}] [{"ID":12349},{"Status":1},{"Manufacturere_ID":101},{"Famiy_matchcode":"101-iphone-11"},{"Name":"iPhone 11"},{"Price":349.95}] [{"ID":12350},{"Status":1},{"Manufacturere_ID":101},{"Famiy_matchcode":"101-iphone-11"},{"Name":"iPhone 11"},{"Price":639.95}] [{"ID":12350},{"Status":1},{"Manufacturere_ID":101},{"Famiy_matchcode":"101-iphone-11"},{"Name":"iPhone 11"},{"Price":509.95}]

But it is not a valid JSON and I really need to get an output like this:

[{"ID":12348,"Status":1,"Manufacturere_ID":101,"Famiy_matchcode":"101-iphone-11","Name":"iPhone 11","Price":639.95}, {"ID":12348,"Status":1,"Manufacturere_ID":101,"Famiy_matchcode":"101-iphone-11","Name":"iPhone 11","Price":509.95}]

This is a standard JSON object array.

In my code, I'm using array_push($newArray, array($headline => $value[$index])); to generate the array and take it as JSON.

Please help me on this.

Generate the full array first, and only then use json_encode on that result. — Jonnix
– Jonnix, Commented Oct 21, 2020 at 11:45
@Jonnix Can you please provide some more explanation please. You are in expert level and I'm in beginner level. :-) — Chanaka De Silva
– Chanaka De Silva, Commented Oct 21, 2020 at 12:04

Nigel Ren · Accepted Answer · 2020-10-21 11:50:08Z

2

You seem to be creating arrays and adding json data in several places, build the data as a normal array and then encode the result...

// Foreach to iterate the data array.
foreach ($csv["data"] as $key => $value) {
    // Combine headers with data and add to final result
    $finalArray[] = array_combine($csv["headlines"], $value);
    
}
echo json_encode($finalArray);

answered Oct 21, 2020 at 11:50

Nigel Ren

57.3k11 gold badges49 silver badges59 bronze badges

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

1 Comment

Chanaka De Silva Over a year ago

I'm checking your answers now and thank you in advance. I will tell you the results. :-)

Collectives™ on Stack Overflow

How to create a dynamic JSON array in PHP using multiple for eaches?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related