I am tasked with troubleshooting a web registration form that queries a Filemaker Pro v12 database via a Filemaker PHP API.

The web form had been running well for a couple of months after major revision, when all of a sudden:

1. All dropdowns are empty
2. All radio buttons are missing
3. These symptoms appear to be browser-independent.

The appearance of these symptoms is mysterious:

1. Nobody has modified the PHP code for the web form - I've done a compare with a backup done at the time when the web form was not broken and it is identical to what is currently on the server. 
2. The Filemaker Pro layout that the web form is querying is just fine - all the value lists for the dropdowns and radio buttons are present.

I've created a stripped-down version of the web form: https://campmeetings.cccsda.org/test_form.php and I've also attached the php source code file.

The date and record fields are populating correctly. Notice the empty dropdown list after "Church I attend."

Could this be caused by an incompatibility between the FMP PHP API and PHP libraries on the server? Perhaps due to a PHP update on the server? Any ideas how to troubleshoot this? 

test_form.php

I wil note that this is not done purely with the API - it's an FMStudio v2 generated page which uses some custom functions not used in the API.

And that FMStudio went unsupported a few years back.

It's also not a query page - it creates a new record, and reads data back from that record.

That said, if the WebForm layout does have the value lists available when a brand new record is created (used for drop downs and buttons), this looks like it should work

Edited January 30, 20178 yr by webko