Im trying to figure out how to setup my database so it can be accessible online by our clients who have a current subscription with us.
I do not have much experience in web technologies other than standard HTML so PHP is kind of new to me.
Currently i have something similar setup using a MySQL database. Every night i export the usernames and passwords of clients who have a subscription with us and upload the information to the MySQL database. I would like to remove the manual export/import and have everything live based off of the FileMaker database.
I tried setting up the MySQL database as an external data source in FileMaker and create a relationship but saying that the connection was slow was a compliment.
We have FileMaker Server Advanced 12 setup in a 2 server config both running on MS Windows Server 2008. Our website is currently hosted on a VPS at Network Solutions and i was hoping to host the web pages there but if needed i do have IIS setup on the WPE Server.
I purchased the book titled "FileMaker Web Publishing - A Complete Guide to Using the API for PHP", so far it has given some info and some samples but does not explain the elements that go into writing the code.
Does anyone know of any examples that demonstrate what i am trying to do or can point me in the right direction as far as web resources go.
Thanks in advance