Thinking out loud - a continuation...
| From: | Jay Blanchard | Date: | Wed, 21 Mar 2012 18:39:19 +0000 |
| Subject: | Thinking out loud - a continuation... | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-317163@lists.php.net to get a copy of this message | ||
This is a continuation of the nested query thing I posted to the list a while back. I was finally
able to output a nested unordered array that worked out well, but scope-creep has come in the door
and I have to change gears.
I have a project where I have multiple queries and each query uses the results from the previous
query to get it's results. I need to do one of two things, either out put a multidimensional
array that I can use json_encode() on or I have to format the output from the queries as a JSON
string. The resulting JSON will be used by a JavaScript widget and must be formed correctly. I
created the following array by hand:
$userList = array("John" => array(
"email" => "john@demo.com",
"website" => "www.john.com",
"age" => "22",
"password" => "pass",
"description" => array(
"hair" => "blonde",
"eyes" => "blue",
"build" => "medium"
)),
"Anna" => array(
"email" => "anna@demo.com",
"website" => "www.anna.com",
"age" => "24",
"password" => "pass",
"description" => array(
"hair" => "brunette",
"eyes" => "hazel",
"build" => "petite"
)
));
I ran it through json_encode() and got the following output
{"John":{"email":"john@demo.com","website":"www.john.com","age":"22","password":"pass","description":{"hair":"blonde","eyes":"blue","build":"medium"}},"Anna":{"email":"anna@demo.com","website":"www.anna.com","age":"24","password":"pass","description":{"hair":"brunette","eyes":"hazel","build":"petite"}}}
jslint.com verifies this as good JSON (although I thought there had to be square brackets around
child arrays).
If you were me would you just generate the JSON? If not what is he best way to output an array that
will nest properly for each subsequent query?
Thanks for any insight!