I was looking into the following scenario:
I have a table in filemaker that contains two fields I would like to utilize in a webpage written in PHP. They are "code" and "URL"
The webpage starts with a form has an input field asking for the code (6 digit unique code) and when submitted, the page will redirect to the corresponding URL field in the table.
My guess is that a search would happen and the success page could use a PHP redirect using headers.
Any help would be greatly appreciated. I have created the initial files for the database configuration and I can connect to the database successfully.