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.
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.
How do I access a record by some field other than the record id when first accessing the filemaker db via PHP?