I am using spacetree chart and I require JSON in hierarchical format. See sample required JSON format here. I have ID,ParentID,Name,Description fields in Mysql database table. Now How can I convert data in Hierarchical/nested JSON using PHP? I know json_encode($array). But, I require nested/Hierarchical php array for this. Let me know to do this.
Add a comment
|
2 Answers
You're basically asking two questions here - 1) how to get an hierarchical php structure from a db table and 2) how to encode this structure in json. For the first question see, for example, my (old but working) code. For the second, I believe simple json_encode will work pretty well.
1 Comment
Brij
Thanks @stereofrog. You are very close to my object.the encoded format is different from required json. I don't require parent_ID and some additional stuff are coming.
If you have PHP json extension on your server installed, just use it on an array. The steps will be:
- Build PHP array with hierarchy based on mysql resutls
- call a json_encode($array) http://pl.php.net/manual/en/function.json-encode.php
If you don't have json_encode enabled on your server and cannot install it... You'll just have to write it by hand.
It'll be something like that (untested code warning):
function my_json_encode($array)
{
$return = '{';
$count = count($array);
$i = 0;
foreach ($array as $key => $val)
{
$return .= '"'.$key.'" : ';
if (!is_array($val))
$return .= '"'.$val.'"';
else
$return .= my_json_encode($val);
if ($i < $count-1)
$return .=",";
$i++;
}
$return .= '}';
return $return;
}
3 Comments
Tomasz Struczyński
This solution is a simple proof-of-concept and has to be enhanced. To add is, for example, object type support and some error handle. It's better to use json_encode anyway.
Tomasz Struczyński
Sorry, one more thing. If you're sending json, remember that you should set appropriate headers in response. Like: header('Content-type: application/json');
Brij
Now my question is how to create nested/hierarchical php array?