How to generate json response using php

Question

In the model:

public function groups($getGroupId) {
        $cols = array('group_id','name');
        $sql = $this->select ()
                    ->from ( $this->_name, $cols )
                    ->where ( 'parent_id=?', $getGroupId );
        $groupDetails = $this->fetchAll ( $sql );
        //$childGroupName = $groupDetails['name'];
        return $groupDetails;
}

groupDetails.php page:

$dbGroup = new dbGroups();
$groupDetails = $dbGroup -> groups($getGroupId);
$jsonResponse = json_encode($groupDetails);
print_r($jsonResponse);

When printing the data i'm getting response like this

[{"group_id":"2","name":"ABCD"},{"group_id":"7","name":"XYZ"}]

But i want output like this, Because i have to generate a jstree using json

[
   {
      "data" : {
         "icon" : <optional>,
         "title" : <node name>
      },
      "attr" : {
         "rel" : <the type you defined in the js (maybe "group")>,
         "title" : <node title>,
         "id" : <the node's id / group id>
      },
      "state" : "closed"
   }
]

just use the json_encode php.net/manual/en/function.json-encode.php` and don't forget to set the headers to application/json, e.g. header('Content-type: application/json'); — scibuff
– scibuff, Commented Feb 27, 2012 at 9:57
i am using json_encode but the output is different than what i want. — vvr
– vvr, Commented Feb 27, 2012 at 10:00
you just need to structure your data properly in the object/array which you pass into json_encode — scibuff
– scibuff, Commented Feb 27, 2012 at 10:06

Svish · Accepted Answer · 2012-02-27 10:52:57Z

2

I would recommend that you use the output from json_encode as it is. Takes less bandwidth. Only reason I see for all the whitespace is for debugging, and for that I'd rather use FireBug and/or JSONView in FireFox.

Anyways, if you really want to, you can maybe try the JSON_PRETTY_PRINT flag? Seems this was added in 5.4.0 though, so maybe not the version you're on supports it... There seems to be options you can use for that in the comments there though. Maybe you can find something useful? http://www.php.net/manual/en/function.json-encode.php#102091

You say you have to create a jstree now, and that doesn't really have anything to do with what you're asking. You're two examples of data doesn't look anything alike at all. json_encode does not do anything special or magic. It just takes data and turns it into JSON. It's your job to make that data look correctly first, before encoding it. Your DB query most likely returns a set of flat rows, and you'll have to loop through it and somehow generate your tree the way you want it. You can probably find other questions here about how to create tree structures out of flat DB results.

edited Feb 27, 2012 at 10:52

answered Feb 27, 2012 at 10:10

Svish

159k183 gold badges479 silver badges636 bronze badges

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

2 Comments

vvr Over a year ago

i need to generate a jstree using json response

Svish Over a year ago

@wr What you generate is just a matter of how you create your data before you encode it. The query you create (unless I'm missing some magic) is returning a flat set of rows. You're probably going to have to go through it and restructure it into a tree. You can use print_r (without json_encode) to output your data to see how it looks. If you've managed to get it to look correctly. Then when it does, use json_encode.

Liyali · Accepted Answer · 2012-02-27 11:50:40Z

1

Since you are using Zend Framework, I recommend you to use Zend_Json. Zend_Json is a pretty useful component to use in order to format Json from any supported format (object, array, xml...).

Zend_Json::decode() and Zend_Json::encode() will allow you to encode and decode Json and prettyPrint() is used to make your output prettier.

Edit: As Svish said, your two examples doesn't look alike, so it's kind of hard to guess what you want to put inside your tree.

What you need is to create your own array, so you can make it look like the way you want.

For example, let's say you only want one row from your database in your tree, then your array would be something like this:

$v = array(
       array(
         "data" => array("icon" => "ICON",
                         "title" => $row->name),
         "attr" => array("rel" => "REL",
                         "title" => "TITLE", 
                         "id" => $row->group_id),
          "state" =>     "closed"));
echo Zend_Json::encode($v);

These lines should echo something like in your examples.

To make it works with your fetchAll(), a simple foreach will do it.

edited Feb 27, 2012 at 11:50

answered Feb 27, 2012 at 10:26

Liyali

5,6832 gold badges29 silver badges41 bronze badges

2 Comments

vvr Over a year ago

response is same as above nothing changed. I have to generate jstree from that json.

Liyali Over a year ago

Well, I improved my answer. Hope it makes things clearer for you now.

Collectives™ on Stack Overflow

How to generate json response using php

2 Answers 2

2 Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related