AnsweredAssumed Answered

Exact Search using PHP

Question asked by on Apr 11, 2017
Latest reply on Apr 13, 2017 by Mike Duncan

Exact searches from FM API for PHP stopped working when we moved to a newer PHP version.  I believe this is because the magic quotes option in the php.ini has been removed.


Did the Filemaker API change to accommodate the change?  I don't see anyone talking about it.

The below code works on our server using FMP Server 14 and PHP v5.5.16, but breaks with newer versions of PHP.


What is the proper mix of FMP/PHP to keep simple exact searches working?


Thanks in advance.





  $relevantplace = "ALLEN";


    #start the find

    $find_Criteria2 = $db_obj->newFindCommand("SI Login");


//  $find_Criteria2->addFindCriterion('Contacts','=='.$relevantplace);

    $find_Criteria_result2 = $find_Criteria2->execute();







PHP Version 5.5.16

System Windows NT FM14-PACSOL-DEV 6.3 build 9200 (Windows Server 2012 R2 Standard Edition) i586

Build Date Aug 21 2014 14:19:24

Compiler MSVC11 (Visual C++ 2012)

Architecture x86

Configure Command cscript /nologo configure.js "--enable-snapshot-build" "--enable-debug-pack" "--disable-zts" "--disable-isapi" "--disable-nsapi" "--without-mssql" "--without-pdo-mssql" "--without-pi3web" "--with-pdo-oci=C:\php-sdk\oracle\x86\instantclient10\sdk,shared" "--with-oci8=C:\php-sdk\oracle\x86\instantclient10\sdk,shared" "--with-oci8-11g=C:\php-sdk\oracle\x86\instantclient11\sdk,shared" "--with-enchant=shared" "--enable-object-out-dir=../obj/" "--enable-com-dotnet=shared" "--with-mcrypt=static" "--disable-static-analyze" "--with-pgo"

Server API CGI/FastCGI

Virtual Directory Support disabled

Configuration File (php.ini) Path C:\Windows

Loaded Configuration File C:\Program Files\FileMaker\FileMaker Server\Web Publishing\publishing-engine\php\php.ini