AnsweredAssumed Answered

PHP - get Record by Field rather than by Id

Question asked by gsainc on May 17, 2010

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

Outcomes