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

[Gjermund Gusland Thorsen]

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
>
>