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

[Bob Patin]

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