hi,
I'm using PHP FX to interface with Filemaker and i am having a problem in the way fx.php urlencodes DB paramenters before passing it to the Filemaker server..
This is my php script
<?php
include_once('../fx/fx.php');
include_once('../db_config.php');
$email=test@test.com;
$cand=new FX($dbHost,$port,$dbType,$conType);
$cand->setDBPassword($dbPass,$dbUser);
$cand->setDBData($dbName,'webdev_Candidate');
$cand->AddDBParam('email',$email,'eq');
$cand_data=$cand->FMFind();
$count= $cand_data['foundCount'];
unset($cand);
echo $count;
?>
I checked the url that is being called and its as follows:
(i've slightly modified the url by removing slashes from http:// because the forum post is truncating the address )
There is an email record called test@test.com in the database, since i can't use @ in the query i've changed the @ to + using php.
http:xxxx:xxxx@zzzzz.moyergroup.com:80/fmi/xml/FMPXMLRESULT.xml?-db=JobPostings&-lay=webdev_Candidate&-max=50&email.op=eq&email=test%2Btest.com&-find
This above query returns zero results since filemaker searches for "test%2Btest.com" and not "test+test.com"
i've also tried to use quotes but even they are gettin urlencoded to %22
by manually calling the url
htp:xxxx:xxxx@zzzzz.moyergroup.com:80/fmi/xml/FMPXMLRESULT.xml?-db=JobPostings&-lay=webdev_Candidate&-max=50&email.op=eq&email=test+test.com&-find
it returns the XML page with the resultset correctly
Does anyone have any clues how i can fix this, or override php-fx from urlencoding select parameters..
Is there something wrong in my approach?
Thanks,