0 Replies Latest reply on May 17, 2010 7:45 AM by gsainc

    PHP - get Record by Field rather than by Id

    gsainc

      Title

      PHP - get Record by Field rather than by Id

      Your post

      I have a PHP enabled db which will be used to ask for and receive customer approval. The PHP access needs to pull a specific record via a URL accessed from the customers email. This URL will be something like this.

      mywebsite.com/Filemaker_PHP/index.php?ID=PROOF-514201040333

       

      I can easily use $record = $fm->getRecordById('Proofing', $_GET['ID']); to access the correct record but if I do so the URL displays the actual record id and that is way to easy to guess - giving access to those who may desire it.

       

      I don't want the customer to have to login either so I have created a field with a hard to guess string of numbers which is unique to that one record.

       

      My question:

      How do I access a record by some field other than the record id when first accessing the filemaker db via PHP?

       

      Thnks

       

      Forgot to say - using FMSA10 and FMA10