[FX.php List] Finding emails in Filemaker with PHP

[Gjermund Gusland Thorsen]

Well that is technically two different email addresses, while the
domain is always lowercase,
the username is pr definition casesensitive, however most mailservers
do strtolower() on the addresses these days,
when the original one was not found, as an active failover.

ggt


2008/9/10 Joel Shapiro <jsfmp at earthlink.net>:
> (attempting to stay under the radar...
>
> If someone enters JohnSmith at gmail.com in FMP (client) and it's stored as
> Unicode, then trying to find johnsmith at gmail.com through PHP -- whether
> before or after  strtolower() -- will fail.  No?
>
> OK.  Over and out (?)
>
> -Joel
>
>
> On Sep 10, 2008, at 2:00 PM, Gjermund Gusland Thorsen wrote:
>
>> Why?
>>
>> 2008/9/10 Joel Shapiro <jsfmp at earthlink.net>:
>>>
>>> And on the FM end you'd probably have to do the same, using Lower() as an
>>> auto-enter calc.
>>>
>>> OK, this thread's gone on long enough.  Over and out.
>>>
>>> -Joel
>>>
>>>
>>> On Sep 10, 2008, at 1:41 PM, Gjermund Gusland Thorsen wrote:
>>>
>>>> Well that part of quality insurance is simple to do from the php point
>>>> of view there should be strtolower() in php?
>>>>
>>>> ggt
>>>>
>>>> 2008/9/10 Joel Shapiro <jsfmp at earthlink.net>:
>>>>>
>>>>> But one problem w/ setting an email field's index to unicode is that if
>>>>> someone searches for JohnSmith at gmail.com, they won't find
>>>>> johnsmith at gmail.com, right?
>>>>>
>>>>> -Joel
>>>>>
>>>>>
>>>>> On Sep 10, 2008, at 8:57 AM, Gjermund Gusland Thorsen wrote:
>>>>>
>>>>>> The reason why it's clumsy to store emails in the a field that has a
>>>>>> language sorting is:
>>>>>>
>>>>>> Language indexes strips off everything outside of the characters that
>>>>>> makes up the language,
>>>>>> for english that would be all characters [A-Z][a-z] on top of it all
>>>>>> A=a, so much for individual characters...
>>>>>> @ is most likely turned into an IFS( inter field separator such as
>>>>>> tab, newline and space ) when a language is used for indexing the
>>>>>> field.
>>>>>>
>>>>>> Switching to Unicode instead of a language does turn off all this
>>>>>> imaginary wordsplitting stuff and therefore indexes an email as 1
>>>>>> entity.
>>>>>>
>>>>>> hth,
>>>>>> ggt
>>>>>>
>>>>>> 2008/9/10 Gjermund Gusland Thorsen <ggt667 at gmail.com>:
>>>>>>>
>>>>>>> I am sure you would all benefit from first making the fields correct,
>>>>>>> then the tables, then the relationships, then the php/ScriptMaker
>>>>>>> stuff.
>>>>>>>
>>>>>>> Doing the design right makes alot of scripting unnecessary.
>>>>>>>
>>>>>>> ggt
>>>>>>>
>>>>>>> 2008/9/10 Michael Layne <fx at 9degrees.com>:
>>>>>>>>
>>>>>>>> Here's what I did a few years ago because it was a bit squirrelly
>>>>>>>> (like
>>>>>>>> you're finding out...)
>>>>>>>> in PHP...
>>>>>>>> $user = str_replace("@","",$_POST['email']);
>>>>>>>> // BEGIN : here we're grabbing the record information
>>>>>>>> $q = new FX($ip, $port);
>>>>>>>> $q->SetDBData($fmdb,$lay . 'parentlist');
>>>>>>>> $q->SetDBPassword($fmpw[0],$fmpw[1]);
>>>>>>>> $q->AddDBParam('email_lookup',$user);
>>>>>>>> $r = $q->FMFind();
>>>>>>>>
>>>>>>>> in FileMaker:
>>>>>>>> email_lookup = calc...
>>>>>>>> Substitute ( email ; "@" ; "" )
>>>>>>>> works for me!
>>>>>>>> HTH...
>>>>>>>> Michael
>>>>>>>> Michael Layne  |  9 degrees development  |  9degrees.com  |
>>>>>>>>  skype:laynebay
>>>>>>>> On Sep 10, 2008, at 9:40 AM, DC wrote:
>>>>>>>>
>>>>>>>> search the archives... this one is a chestnut. anyone make progress
>>>>>>>> on
>>>>>>>> that
>>>>>>>> FAQ we started last year?
>>>>>>>>
>>>>>>>>
>>>>>>>> http://www.google.com/coop/cse?cx=013867382578033190853%3Axht3ywlmfpc
>>>>>>>>
>>>>>>>> cheers,
>>>>>>>> dan
>>>>>>>>
>>>>>>>> william.downs wrote:
>>>>>>>>
>>>>>>>> Hi Josh,
>>>>>>>>
>>>>>>>> Surely using double == works ?
>>>>>>>>
>>>>>>>> as in $medFind->AddDBParam('Email',"==".$medEmail);
>>>>>>>>
>>>>>>>> I may be lost here though
>>>>>>>>
>>>>>>>> William
>>>>>>>>
>>>>>>>> On 10 Sep 2008, at 12:57, Josh Shrier wrote:
>>>>>>>>
>>>>>>>> How do you do a search in PHP for an email in Filemaker. When it
>>>>>>>> performs a
>>>>>>>> regular search the "@" in the e-mail address forces a no records
>>>>>>>> found
>>>>>>>> result during the find. The only way to find it is the use "" around
>>>>>>>> the
>>>>>>>> address. I do not know how to solve this during a PHP query. Please
>>>>>>>> assist.
>>>>>>>>
>>>>>>>> -Josh Shrier
>>>>>>>>
>>>>>>>> _______________________________________________
>>>>>>>>
>>>>>>>> FX.php_List mailing list
>>>>>>>>
>>>>>>>> FX.php_List at mail.iviking.org <mailto: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
>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>> _______________________________________________
>>>>>> 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
>>>
>> _______________________________________________
>> 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
>