Write JSON file from MySql using php

Question

I want to add Data before the array and it is written into the converted json. I have checked that there are no errors when converting, but why isn't there?

This the code

$response = array();
while($row =mysqli_fetch_assoc($result))
{
    $response[] = $row;
}
echo json_encode($response);
    //write to json file
$fp = fopen('op.json', 'w');
fwrite($fp, json_encode('{"Data":', $response), '}');// JSON_PRETTY_PRINT
fclose($fp);

Previous results like this

[
  {
    "id": "6",
    "name": "kiko",
    "score": "999"
  },
  {
    "id": "9",
    "name": "johyn",
    "score": "88"
  },
  {
    "id": "12",
    "name": "aaaani",
    "score": "99"
  }
]

I want the results like this

{
  "Data": [
    {
      "id": "6",
      "name": "kiko",
      "score": "999"
    },
    {
      "id": "9",
      "name": "johyn",
      "score": "88"
    },
    {
      "id": "12",
      "name": "aaaani",
      "score": "99"
    }
  ]
}

You can also replace the loop and mysqli_fetch_assoc() with mysqli_fetch_all() — Nigel Ren
– Nigel Ren, Commented Aug 14, 2018 at 16:51

RiggsFolly · Accepted Answer · 2018-08-14 16:48:18Z

2

json_encode() encodes an array or object to a JSON String, so make the parameter an array and it will work

fwrite($fp, json_encode(["Data" => $response]);

Or to get JSON_PRETTY_PRINT

fwrite($fp, json_encode(["Data" => $response], JSON_PRETTY_PRINT);

answered Aug 14, 2018 at 16:48

RiggsFolly

94.7k22 gold badges108 silver badges152 bronze badges

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

Comments

War10ck · Accepted Answer · 2018-08-14 16:48:13Z

1

Rather than trying to code the JSON and then json_encode() it you can use an array to generate the desired output:

$response = array();
while($row =mysqli_fetch_assoc($result))
{
    $response[] = $row;
}
echo json_encode($response);
    //write to json file
$fp = fopen('op.json', 'w');
fwrite($fp, json_encode(array('Data' => $response), JSON_PRETTY_PRINT)); // JSON_PRETTY_PRINT
fclose($fp);

In addition, json_encode() has the ability to pretty print the json by supplying the second parameter.

answered Aug 14, 2018 at 16:48

War10ck

12.5k7 gold badges46 silver badges56 bronze badges

Collectives™ on Stack Overflow

Write JSON file from MySql using php

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