CODEWITHSUNDEEP
phpjsond3.js
Pajo Hackman
Pajo Hackman

Reputation: 67

Writing to JSON with PHP

I need help with my json output. At present my output is as so:

[
  [
    {
        "ING_SW_CB": "5",
        "SB_SW_CB": "3",
        "NG3_SW_CB": "1",
        "Mould_Close": "4",
        "Leak_Test": "5",
        "ML_Load": "6",
        "Pre_Heat": "3",
        "Dispense": "9",
        "A310": "7",
        ............
    }
  ]
]

I’d like it to be as following with "key" & "value" included in the output. 

{"key":"ING_SW_CB", "value": "5"},
{"key":"SB_SW_CB", "value": "3"},
 ..............................

Hers is my PHP script:

$json_response = array();

while ($row = mysqli_fetch_array($result2, MYSQL_ASSOC)) {
    $row_array['ING_SW_CB'] = $row['ING_SW_CB'];
    $row_array['SB_SW_CB'] = $row['SB_SW_CB'];
    $row_array['NG3_SW_CB'] = $row['NG3_SW_CB'];
    $row_array['Mould_Close'] = $row['Mould_Close'];
    $row_array['Leak_Test'] = $row['Leak_Test'];
    $row_array['ML_Load'] = $row['ML_Load'];
    $row_array['Pre_Heat'] = $row['Pre_Heat'];
    $row_array['Dispense'] = $row['Dispense'];
    $row_array['A310'] = $row['A310'];
    $row_array['Gelation'] = $row['Gelation'];
    $row_array['Platen'] = $row['Platen'];
    $row_array['Mainline_Unload'] = $row['Mainline_Unload'];
    $row_array['De_mould'] = $row['De_mould'];
    $row_array['Clean_Up'] = $row['Clean_Up'];
    $row_array['Soda_Blast'] = $row['Soda_Blast'];
    $row_array['Miscellaneous'] = $row['Miscellaneous'];

    //push the values in the array
    array_push($json_response,$row_array);
}

$json_data = json_encode($json_response, JSON_PRETTY_PRINT); 
file_put_contents('your_json_file.json', $json_data);

I need the keywords "key" & "value" added to the output so I can popuate a D3 chart.

Upvotes: 0

Views: 63

Answers (3)

Barmar
Barmar

Reputation: 781731

Loop over the columns:

$json_response = array();
while ($row = mysqli_fetch_array($result2, MYSQLI_ASSOC)) {
    $json_row = array();
    foreach ($row as $key => $value) {
        $json_row[] = array('key' => $key, 'value' => $value);
    }
    $json_response[] = $json_row;
}
$json_data = json_encode($json_response, JSON_PRETTY_PRINT);
file_put_contents('your_json_file.json', $json_data);

Upvotes: 1

MrTechie
MrTechie

Reputation: 1847

$json_response = array();

while ($row = mysqli_fetch_array($result2, MYSQL_ASSOC)) {


//push the values in the array

 foreach($row as $k=>$v){
      $my_array = array("key"=>$k, "value"=>$v);
 }

   array_push($json_response,$my_array);
}



 $json_data = json_encode($json_response, JSON_PRETTY_PRINT); 
 file_put_contents('your_json_file.json', $json_data);

Upvotes: 0

Marc B
Marc B

Reputation: 360762

You need to loop on the row's results and build more arrays:

while(...) {
   $temp = array();
   foreach($row as $key => $value) {
       $temp[] = array('key' => $key, 'value' => $value);
   }
   $json_response[] = $temp;
}

Upvotes: 3

Related Questions