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

[Ness, David]

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