When FileMaker 14 was released we decided that it was time to rebuild this web site. We had three main objectives for the new site:
The FileMaker PHP API is used in conjunction with FMWebFrame to pull content from a FileMaker database hosted on one of our FileMaker servers and the site is coded using the Skeleton responsive framework.
FMWebFrame is an extension to the FileMaker API designed to make custom web publishing easier. Two functions are key to achieving two of our objectives - ExecuteSQL and Caching
The FMWebFrame ExecuteSQL function provides access to the FileMaker ExecuteSQLfuntion and makes pulling information from the database really very easy. SeeImplementing FMWebFramein the sidebar to read more about how straightforward it is to do
With FMWebFrame's caching functions, we can cache the ExecuteSQL query results. This can dramatically improve the performance of the site for users, and reduce the load placed on the database server. What this means for this site is that all content is cached on the web server and a call to the database is only made when we trigger an update to a page. So effectively we have a static html/php based site that we can dynamically update at the click of a button.
Skeleton is a responsive css framework based upon a 12 column fluid grid that allows us to produce a variety of page layouts that respond well to changes in screen size from desktop to mobile phone. Skeleton and FMWebFrame seem to work very well together