[FX.php List] JSON help

david weiner 1265 at lucerneblvd.org
Wed Jan 14 19:38:46 MST 2009


Hi,
If anyone on the list has any experience getting FX/PHP to output JSON
encoded data (using json_encode) - I'd like to hear from about it.

I'm looking to get filemaker data into JSON for a few reasons,
primarily all chart related, and am struggling a little with the PHP.
For one example I'm trying to achieve an array that looks like:

[2006-11-01] => Array
        (
            [count] => 10
            [tags] => Array
                (
                    [web] => 1
                    [search] => 1
                    [chinese] => 1
                    [food] => 1
                    [tomatoes] => 1
                    [bread] => 1
                    [restaurants] => 1
                    [japanese] => 1
                    [coffee] => 1
                )

        )

where [2006-11-01] = [parent_date]
[count] = field[number_of_children_for_parent_date] (portal rows)
[tags] => Array ( ... ) is a loop grabbing all the comma separated
field contents from each portal row for the parent date.

The ultimate goal is produce a timecloud using jQuery
(http://wiki.github.com/stef/timecloud), but I think if I can get this
figured out, then extending FX to feed all kinds of JSON driven data
visualizers _should_ be doable.

I've got some very rough code adapted from the timecloud delicious
sample data and would be happy to share it, but it's basically not
working so I'm leaving it off for now.

thanks,
David


More information about the FX.php_List mailing list