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

[Michael Layne]

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.iviking.org/pipermail/fx.php_list/attachments/20080910/3a6ac739/attachment.html