[FX.php List] Lasso equivalent in php/fx.php

Nick Trenary trenaryn at crlibrary.org
Mon Nov 5 08:03:43 MST 2007


There are 43 fields that can be searched.  They unfortunately do not 
have the same possible options.  Some yes/no, others have different 
options. 

Nick

Chris Hansen wrote:
> Nick,
>
> Thanks for the code.  This is actually what I was talking about...  
> I'm guessing that the page searches on Agency, Location, and County?  
> At any rate, the simplest way to do things would be with AddDBParam(), 
> however you could also step through the $_POST array and grab the 
> fields you are interested in that way (looping over a single 
> AddDBParam() call with variables as parameters).  How would you prefer 
> things work?  Do you have a very large number of parameters that 
> you're trying to work with?
>
> Best,
>
> --Chris Hansen
>   FileMaker 8 Certified Developer
>   FileMaker 7 Certified Developer
>   Creator of FX.php
>   "The best way from FileMaker to the Web."
>   www.iViking.org
>
>
> On Nov 2, 2007, at 2:48 PM, Nick Trenary wrote:
>
>> Sorry -
>>
>> This is an example of the code for a radio button in the form:
>> <input type="radio" name="Services" value="LD">
>>
>> This is the Lasso code from the action page:
>> [Var: 'action']
>> [If:  (Action_Param: 'action') == 'Search' ]
>>   [Var: 'action' = '-Search' ]
>> [Else:  (Action_Param: 'action') == 'Find All' ]
>>   [Var: 'action' = '-Findall' ] [/If]
>>
>> [If:  $action == '-Search'  ||  $action == '-FindAll']
>>
>>    [Inline:    (Action_Params),
>>      -$action,
>>      -Database='agencies2',
>>                        -Table='Search2',        
>> 'Agency'=(Action_Param: 'Agency'),
>>      'Location'=(Action_Param: 'Location'),
>>      'County'=(Action_Param: 'County'),
>>                        -Sortfield='Location',
>>                        -Sortfield='Agency',
>>                        -Maxrecords='all' ]
>>
>> [Records]
>> html code
>> [/Records]
>> [/Inline]
>> [/If]
>>
>> Nick
>>
>> Gjermund Gusland Thorsen wrote:
>>> What about pasting the code instead of leaving it to our imagination
>>> to give you an answer?
>>>
>>> ggt
>>>
>>> On 11/2/07, Nick Trenary <trenaryn at crlibrary.org> wrote:
>>>
>>>> My apologies if this is a purely php answer.  Any Lasso developers out
>>>> there?  I have inherited some search pages that were built using Lasso
>>>> with Filemaker databases.  I am working on converting them to php.
>>>> There are a couple of pages that have a form where a user can click on
>>>> yes or no radio buttons for several, several fields for an advanced
>>>> search.  Somehow in the action file for Lasso the radio button options
>>>> are sent that perform the search w/out actual coding to perform the
>>>> several field search, it must be something in the Lasso app 
>>>> itself.  Is
>>>> there a php/fx.php equivalent of this type of search or do I need to
>>>> have a '$query->AddDBParam();' parameter for each search field?
>>>>
>>>> Nick
>>>>
>>>> -- 
>>>> -- 
>>>>
>>>> Nick Trenary
>>>> Computer Information Systems Analyst
>>>> Cedar Rapids Public Library
>>>> Office: 319.398.5145 x267
>>>> Cell: 319.310.7699
>>>>
>>>>
>>>> _______________________________________________
>>>> 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
>>>
>>>
>>>
>>
>> -- 
>> -- 
>>
>> Nick Trenary
>> Computer Information Systems Analyst
>> Cedar Rapids Public Library
>> Office: 319.398.5145 x267
>> Cell: 319.310.7699
>>
>>
>> _______________________________________________
>> 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
>
>

-- 
--

Nick Trenary
Computer Information Systems Analyst
Cedar Rapids Public Library
Office: 319.398.5145 x267
Cell: 319.310.7699




More information about the FX.php_List mailing list