[FX.php List] Finding match to an email address

[Bob Patin]

Absolutely! I don't think I'll be in Las Vegas in time for Joel's unconference, but I'm sure we'll run into each other.

All the best,

Bob Patin
Longterm Solutions
bob at longtermsolutions.com
615-333-6858
FileMaker 9, 10, 11, 12 & 13 Certified Developer
http://www.longtermsolutions.com
-
iChat: bobpatin at me.com
Twitter: bobpatin
—
FileMaker Consulting 
FileMaker Hosting for all versions of FileMaker
PHP • Full email services • Free DNS hosting • Colocation • Consulting

> On Jul 14, 2015, at 9:03 AM, Ness, David <dness at bondedbuilders.com> wrote:
> 
> Thanks Bob,
> 
> Yes, that seems to work perfectly.
> 
> See you next week, buddy.
> 
> 
> David Ness
> FileMaker & Web Applications Developer
> 
> Bonded Builders Warranty Group
> St. Petersburg, Florida USA
> 800-749-0381 x4923
> 
> 
> -----Original Message-----
> 
> Try this:
> 
> $q->AddDBParam('email','=='.preg_replace('/([@*#?!=<>"])/','\\\${1}',$email));
> 
> 
> Bob Patin
> Longterm Solutions
> bob at longtermsolutions.com
> 615-333-6858
> FileMaker 9, 10, 11, 12 & 13 Certified Developer http://www.longtermsolutions.com
> -
> iChat: bobpatin at me.com
> Twitter: bobpatin
> —
> FileMaker Consulting
> FileMaker Hosting for all versions of FileMaker PHP • Full email services • Free DNS hosting • Colocation • Consulting
> 
>> On Jul 14, 2015, at 8:08 AM, Ness, David <dness at bondedbuilders.com> wrote:
>> 
>> What is the best approach for attempting to search for an email address entered on the website within  FileMaker using fx.PHP?
>> 
>> I currently trim, lower, and replace '@', '*', and "!" on both ends and search on those results for a match.
>> 
>> Not that it's likely, but this would result in both of these leading to a match.
>> 
>> abc at def.com == ab at cdef.com
>> 
>> Is there a better way that you use?
>> 
>> 
>> David Ness
>> FileMaker & Web Applications Developer
>> 
>> Bonded Builders Warranty Group
>> St. Petersburg, Florida USA
>> 800-749-0381 x4923
> 
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list