how can I produce json object in php mysqli

Question

I could I produce this JSON with a MYSQLi query in PHP?

{
    "name": "Top Node",
    "children": [
      {
        "name": "Bob: Child of Top Node",
        "parent": "Top Node",
        "children": [
          {
            "name": "Son of Bob",
            "parent": "Bob: Child of Top Node"
          },
          {
            "name": "Daughter of Bob",
            "parent": "Bob: Child of Top Node"
          }
        ]
      },
      {
        "name": "Sally: Child of Top Node",
        "parent": "Top Node"
      }
    ]
  }

Check this http://stackoverflow.com/questions/3351882/convert-mysqli-result-to-json — Farmer, Mar 18 '17 at 05:16
Possible duplicate of [convert mysqli result to json](http://stackoverflow.com/questions/3351882/convert-mysqli-result-to-json) — Beck Yang, Mar 18 '17 at 09:11

score 0 · Answer 1 · answered Mar 18 '17 at 05:14

0

You can use json_encode, to encode your result from sql query.

Example :

    $rows = array();
    while ($r = mysqli_fetch_array("SELECT * FROM TABLE_NAME", MYSQLI_ASSOC)) {
        $rows[] = $r;
    }
    echo json_encode($rows);  //print result in json format

answered Mar 18 '17 at 05:14

Ravi

30,829
42
119
173

thanks for your answer, but i am asking about nested json to use in parent child tree. – Himanshu Ranjan Mar 18 '17 at 06:13
To nested json, you need to nest query output. I mean, pass nested sql result to `rows[]` – Ravi Mar 18 '17 at 07:31

how can I produce json object in php mysqli

1 Answers1