Web Publishing with PHP and FileMaker 9- P9:On the other hand, it would drive me nuts if you bought this book only to discover that it didn’t address your needs. In the spirit of customer satisfaction, please read the following introduction to get a sense of where I’m coming from, and whether you might get some good use out of this book. | 110 CHAPTER 6 Viewing FileMaker Data Drill Down Pages So that s it for the view links. Let s look at the view page php define F . _HOST define FM_FILE Product Catalog define FM_USER esmith define FM_PASS m4rg0t include fm new FileMaker FM_FILE FM_HOST FM_USER FM_PASS record fm- getRecordById Product _GET recid id record- getField ID name record- getField Name model_number record- getField Model Number price record- getField Price created_at record- getField Created At created_by record- getField Created By html head title 06_05 title head body table border 1 tr th ID th td php echo id td tr tr th Name th td php echo name td tr tr th Model Number th td php echo model_number td tr tr th Price th td php echo price td tr tr th Created At th td php echo created_at td tr Viewing FileMaker Data 111 tr th Created By th td php echo created_by td tr table body html In my opinion this is an example of where really shines. After you have an internal record ID it s really easy to work with a record. This page is pretty simple. Here are the key lines starting from the top Make your FileMaker connection object fm new FileMaker FM_FILE FM_HOST FM_USER FM_PASS Use the getRecordById method of the FileMaker connection object to get a reference to the record object in question and store the reference in the record variable record fm- getRecordById Product _GET recid NOTE Note that in practice it would be considered good form to check first that _GET recid actually existed and contained a value. 6 The record variable will now contain a record object for the record in question. Next use the getField method to pull the values out of the record by field name id record- getField ID name record- getField Name model_number record- getField Model Number price record- getField Price created_at record- getField Created At created_by record- getField Created By All that s left is to burp out the variables in the context of the HTML template html head title .
