[FX.php List] Searching...

Vinnie P. Taranto vinniept at dso.ufl.edu
Mon Dec 13 12:56:06 MST 2004


Hello,

I had 2 questions,

How do you specify the indexing language as ASCII in FMFind()?
and
How do you configure the number of simultaneous sessions PHP can handle?
I'm running Apache 1 and I can't find the value in either the Apache or
PHP config files. The reason I'm asking is because I've created a web
database and I always get a bunch of session variable errors when the
load gets heavy.

Thanks for all yous guys do.

Vinnie Taranto
Technology Specialist & Database Engineer
Dean of Students Office
University of Florida
MAIN: (352) 392-1261
FAX: (352) 392-1261
TDD: (352) 392-5566
TOLLFREE: (877) 9UF-DEAN
WEB: http://www.dso.ufl.edu
EMAIL: vinniept at dso.ufl.edu
-----Original Message-----
From: fx.php_list-bounces at mail.iviking.org
[mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of Chris Hansen
Sent: Monday, December 13, 2004 1:47 PM
To: FX.php Discussion List
Subject: Re: [FX.php List] Searching...

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
>

_______________________________________________
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