[FX.php List] JSON help

david weiner 1265 at lucerneblvd.org
Thu Jan 15 16:12:59 MST 2009


Thanks so much!

I'm getting dangerously close to understanding what's going on, but  
there's one element that's just not getting through. I can't get my  
date_stamp field to show up in the first array brackets. I've spent  
some time reading about key() but I just can't figure out how that  
line should be written - I've tried to break it down but I'm just not  
getting the concept.

I have successfully created the following array:
Array
(
     [] => Array
         (
             [count] => 3
             [tags] => Array
                 (
                     [meat] => 1
                     [spice] => 1
                     [jewel] => 1
                 )

         )

)
Using the following code:
<?php require_once('Connections/chart.php'); ?>
<?php
$FMP_find = clone($chart);
$FMP_find->layout = 'fragrances';
$FMP_findCriterions = array('key'=>'='.$_GET['id'],);
foreach($FMP_findCriterions as $key=>$value) {
     $FMP_find->AddDBParam($key,$value);
}

$FMP_k_find = clone($chart);
$FMP_k_find->layout = 'keywords';
$FMP_k_findCriterions = array('fragrance_key'=>'='.$_GET['id'],);
foreach($FMP_k_findCriterions as $key_k=>$value_k) {
     $FMP_k_find->AddDBParam($key_k,$value_k);
}

fmsSetPage($FMP_find,'FMP',10);
fmsSetPage($FMP_k_find,'FMP_k',10);

$FMP_result = $FMP_find->FMFind();
$FMP_k_result = $FMP_k_find->FMFind();


$FMP_row = current($FMP_result['data']);
$FMP_row_key = key($FMP_result['data']);
$FMP_k_row = current($FMP_k_result['data']);
$FMP_k_row_key = key($FMP_k_result['data']);



foreach( $FMP_k_result['data'] as $FMP_k_row_key=>$FMP_k_row ) {
	$php_tag[$FMP_k_row['keyword'][0]] = $FMP_k_row['one'][0];
}
foreach( $FMP_result['data'] as $FMP_row_key=>$FMP_row ) {
	$php_count = (int)$FMP_row['count_of_keywords'][0];
}

$desiredArray[$FMP_result['data'][key($FMP_result['data'])] 
[$FMP_row['date_stamp']]] = array(	
	'count' => $php_count,
	'tags' => $php_tag);
?>
<pre>
<?php print_r($desiredArray) ?></pre>
<pre><?php print json_encode($desiredArray); ?></pre>
<pre><?php print $FMP_row['date_stamp'][0]; ?></pre>



On Jan 15, 2009, at 7:14 AM, Gjermund Gusland Thorsen wrote:

> Beware of Thy Array Cowboy™
>
> ;-p
>
> 2009/1/15 Jonathan Schwartz <jschwartz at exit445.com>:
>> Uh oh.  I'm starting to understand ggt's php shorthand. ;-)
>>
>> This is a milestone.
>>
>> J
>>
>>
>>
>> At 12:34 PM +0100 1/15/09, Gjermund Gusland Thorsen wrote:
>>>
>>> I assume what you are looking for would be something along these  
>>> lines:
>>> ---
>>> foreach( $rSlaveTable as $v ) {
>>>       $tmp[$v['type'][0]] = $v['value'][0];
>>> }
>>>
>>> $desiredArray[ $rParent['data'][key($rParent['data'])] 
>>> ['parent_date'] ] =
>>> array(
>>>       'count' => $rParent['foundCount'],
>>>       'tags' => $tmp;
>>> );
>>> ---
>>> ggt
>>>
>>> 2009/1/15 Gjermund Gusland Thorsen <ggt667 at gmail.com>:
>>>>
>>>> In order to make that array, I would have to know your current
>>>> Filemaker sources for the fields involved.
>>>>
>>>> ggt
>>>>
>>>> 2009/1/15 Blair Duncan <Blair.Duncan at bbdo.ca>:
>>>>>
>>>>>> From a lurker...
>>>>>
>>>>> Usually I would sit on my hands rather than replying with a  
>>>>> wiseass
>>>>> remarks
>>>>> such as "and this has something to do with FX/PHP in what  
>>>>> way???" as it
>>>>> is
>>>>> more of a php question.
>>>>>
>>>>> But then I click on the link and think, wow another cool thing  
>>>>> that I
>>>>> may be
>>>>> able to use someday. Good people on this list, thanks.
>>>>>
>>>>>
>>>>> On 14/01/09 9:38 PM, "david weiner" <1265 at lucerneblvd.org> wrote:
>>>>>
>>>>>> 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
>>>>>> _______________________________________________
>>>>>> FX.php_List mailing list
>>>>>> FX.php_List at mail.iviking.org
>>>>>> http://www.iviking.org/mailman/listinfo/fx.php_list
>>>>>>
>>>>>
>>>>>
>>>>> Please consider the environment before printing this e-mail.
>>>>>
>>>>> This message and any attachments contain information, which may be
>>>>> confidential or privileged. If you are not the intended  
>>>>> recipient, please
>>>>> refrain from any disclosure, copying, distribution or use of this
>>>>> information. Please be aware that such actions are prohibited.  
>>>>> If you have
>>>>> received this transmission in error, kindly notify us by e-mail to
>>>>> helpdesk at bbdo.com. We appreciate your cooperation.
>>>>>
>>>>> _______________________________________________
>>>>> FX.php_List mailing list
>>>>> FX.php_List at mail.iviking.org
>>>>> http://www.iviking.org/mailman/listinfo/fx.php_list
>>>>>
>>>>
>>> _______________________________________________
>>> FX.php_List mailing list
>>> FX.php_List at mail.iviking.org
>>> http://www.iviking.org/mailman/listinfo/fx.php_list
>>
>>
>> --
>> Jonathan Schwartz
>> Exit 445 Group
>> jonathan at exit445.com
>> http://www.exit445.com
>> 415-370-5011
>> _______________________________________________
>> FX.php_List mailing list
>> FX.php_List at mail.iviking.org
>> http://www.iviking.org/mailman/listinfo/fx.php_list
>>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list



More information about the FX.php_List mailing list