[FX.php List] Searching...

[Chris Hansen]

Greetings!

A tip on doing finds with FX.php: finds via FX work the same way that 
they do in FileMaker.  So characters like '@' and '*' which are 
wildcards in FM, are also wildcards when you search via FX.php.  When 
doing a login, an excellent options is to add quotes around your 
parameter like this (using a modified version of the example below):

$query->AddDBParam('email_password', '"' . $user . $pass . '"');

Of course, this means that you'll be doing an exact search, but for a 
login, that's exactly what you want.

Another suggestion, when creating password fields, it can be very 
useful to specify the indexing language as ASCII.  Not only does this 
make special characters behave, but it also makes searches case 
sensitive; which is again perfect for passwords.

HTH

--Chris Hansen
   creator of FX.php
   "The best way from FileMaker to the Web."
   www.iViking.org

On Dec 13, 2004, at 11:08 AM, Jim Bowser wrote:

> Keep in mind that email addresses can contain underscores and dashes 
> and
> periods in the username and they will affect your search results as 
> much as
> the @ symbol!
>
>
> Jim Bowser
> Network Manager
> Shoreline Creations Ltd.
> Publisher of:
>   GROUP TOUR MAGAZINE
>   STUDENT GROUP TOUR MAGAZINE
>
> 616-393-2077 x120
> 800-767-3489 x120
> jim at grouptour.com
> www.grouptour.com
>
>
> On 12/13/04 12:38 PM, "FX" <fx at 9degrees.com> wrote:
>
>> Milosh,
>>
>> my way around this - I am using email addresses as a user ID for
>> authentication -
>>
>> on the PHP side:
>> $user = str_replace("@","","emailaddress at server.com");
>> $password = $_POST['password'];
>> // then concatenate
>> $userpass = $user . " . " . $password;
>> ...
>> $query->AddDBParam('email_password',$userpass);
>> $result = $query->FMFind();
>> ...
>> on the FM7 side:
>> //create a field that concatenates email and password
>> name: email_password
>> type: calculation
>> calc = Substitute ( email ; "@" ; "" )& "." & password
>>
>> Just removing '@' from the equation on both sides allows you to use 
>> the
>> sumbitted email!
>>
>> On Nov 22, 2004, at 10:41 AM, Milos Vukotic wrote:
>>
>>> Not just number-fields, any fields with particular characters (like
>>> "@")... Look at my previous posts.
>>> There is NO good work around in FM7.  Maybe after v9 everything will
>>> work as it is supposed to!?
>>>
>>> Cheers,
>>> Milosh
>>> --
>>> Milos Vukotic
>>> Software Engineer
>>> MC Services
>>> http://www.mcservices.com
>>>
>>> Baard Belsaas wrote:
>>>
>>>> Hello, I have made my first fx-site in FM5, and get it working!
>>>> Now I have converted this to FM7. After a bit of troubles I can
>>>> acsess the
>>>> database from the site, and searching on a text-filed is ok. But 
>>>> when
>>>> I
>>>> search on a number-filed its "game over"; the found counter is "-1"
>>>> and the
>>>> current error=401.
>>>>
>>>> Search is the same to number- or textfield? Or have I sleeping in my
>>>> fx-lessons?
>>>>
>>>>
>>>> In kindness
>>>> Baard Belsaas
>>>>
>>>>
>>>> _______________________________________________
>>>> 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
>>>
>> _________________
>> Michael Layne
>> 9 degrees development
>>
>> _______________________________________________
>> 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
>