Re: Thinking out loud - a continuation...

[Bastien <phpster@xxxxxxxxx>]

On 2012-03-21, at 2:39 PM, Jay Blanchard <jay.blanchard@xxxxxxxxxxxxxxxxxxx> wrote:

> 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@xxxxxxxx",
>                     "website" => "www.john.com",
>                     "age" => "22",
>                     "password" => "pass",
>                     "description" => array(
>                         "hair" => "blonde",
>                         "eyes" => "blue",
>                         "build" => "medium"
>                     )),
>                  "Anna" => array(
>                     "email" => "anna@xxxxxxxx",
>                     "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@xxxxxxxx","website":"www.john.com","age":"22","password":"pass","description":{"hair":"blonde","eyes":"blue","build":"medium"}},"Anna":{"email":"anna@xxxxxxxx","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!
> 
> 
Would it not be easier to get the data from a view which has the tables joined? Then it would be one query and it's a simple matter to format the results into the multi dimensional array then json?

Bastien
-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php