[FX.php List] Conditional value lists with PHP and FileMaker

[Anders Monsen]

I have done something like that for larger report queries. I will  
investigate and also see if that gives me a better array to work from.

Anders

On Nov 19, 2008, at 11:04 AM, Gjermund Gusland Thorsen wrote:

> To optimize for speed I would do the query once and dump the result  
> in _SESSION,
> then I would build the contextual menues from subsets of that array.
>
> ggt
>
> 2008/11/19 Anders Monsen <andersm at alamark.com>:
>> Thanks. Here is the link.
>> http://pastebin.com/m11a42e0c
>>
>> Anders
>> On Nov 19, 2008, at 10:48 AM, Gjermund Gusland Thorsen wrote:
>>
>> Please use pastebin.com with appropriate syntax coloring and please
>> leave for a month,
>> and then paste the link here.
>>
>> ggt667
>>
>> 2008/11/19 Anders Monsen <andersm at alamark.com>:
>>
>> Has anyone on the list worked on this issue? I spent most of  
>> yesterday
>>
>> putting together a process that works, but may not be the most  
>> efficient
>>
>> process. I was wondering if anyone would be open to looking at my  
>> code (the
>>
>> snippet is 130 lines long at minimum, so I didn't just want to  
>> throw it out
>>
>> there) to see if there are ways I can improve the process. It  
>> certainly made
>>
>> me appreciate how easy FileMaker makes this process...
>>
>> (I just discovered and read Jonathan Stark's article in July
>>
>> FileMakerAdvisor after writing this email. It uses Ajax, so I may  
>> try to
>>
>> incorporate his techniques, although I'm using FX.php and no  
>> existing value
>>
>> lists from FileMaker, just existing data.)
>>
>> Here's the scenario. I have a table with four fields: district  
>> number,
>>
>> district name, campus number, and campus name. I want the district  
>> and
>>
>> campus to be drop down menus, where the user sees the name but  
>> submits the
>>
>> number into another FileMaker database/table. Also, when the user  
>> selects a
>>
>> district, I need the value list of campuses to correspond just to  
>> their
>>
>> appropriate district.
>>
>> My first issue was to find a way to create an associative array with
>>
>> district numbers=>district names. Apparently I took the hard route in
>>
>> dynamically building associative arrays... After several failed  
>> attempts, I
>>
>> used a function that I found on php.net in the section on  
>> "array_push" to
>>
>> create this array. The first problem I ran into was that the list  
>> currently
>>
>> contains 270 records. For now I had to manually change the  
>> groupsize in the
>>
>> query to above 300, but I plan to first query all records to get a  
>> count,
>>
>> then make this the groupsize. The reason for this is that the  
>> district array
>>
>> becomes unique only after all records have been loaded into the  
>> array, so
>>
>> the default groupsize of 50 has to be modified.
>>
>> Is there a way to 1) build a better array and 2) make the district  
>> array
>>
>> unique in the initial query? The database is structured as one  
>> file, with
>>
>> all four fields, and so the district numbers and names are  
>> repeated. I
>>
>> didn't create the database, and I can't change it.
>>
>> Distnum |       Distname        | CampusNum     |       Campus Name
>>
>> 10                      The ISD         2                        
>> School
>>
>> 10                      The ISD         2.1                      
>> OtherSchool
>>
>> etc.
>>
>> Additionally, after several failed attempts to get the Javascript  
>> onchange
>>
>> function to work when the form changed, I resorted to DreamWeaver's
>>
>> JumpMenu, which seems to work fine. Has anyone been able to get a  
>> working
>>
>> onchange form and what is the correct syntax? When the user selects a
>>
>> district from the dropdown, the page reloads with the district  
>> number in the
>>
>> URL.
>>
>> Given all of the above, my process *does* work, and the page does  
>> not appear
>>
>> to load with delays. I have not used conditional values lists with
>>
>> PHP/Javascript in about three years, so I am a little unsure of best
>>
>> practices.
>>
>> Thanks,
>>
>> Anders
>>
>> _______________________________________________
>>
>> 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
>>
>>
>>
>>
>> _______________________________________________
>> 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
>
>