Web Publishing with PHP and FileMaker 9

by Stark, Jonathan

• ISBN13: 9780672329500
• ISBN10: 0672329506
• Edition: 1st
• Format: Paperback
• Copyright: 2007-09-05
• Publisher: Sams Publishing

Summary

Whether you are a FileMaker developer who is new to web publishing, a web developer who is new to FileMaker, or a complete beginner looking to put your data online, this book is for you. In Part I, you learn the basics of how web publishing works and how to write your own HTML and PHP. In Part II, you learn how to build a FileMaker database and install and configure the FileMaker Server to host the database. In Part III, you learn how to put it all together to create web pages that talk to your database and allow people to view the data and, if you like, modify it. Throughout the book, publishing a FileMaker Product Catalog to the web is used as an example. Each chapter builds on the previous chapter. When you are done, you will have a working website! Detailed information on how tohellip; Master web publishing Read and write basic HTML Read and write basic PHP Build a FileMaker database Install and configure FileMaker Server Publish your FileMaker data to the web Work with portals and container fields Repurpose your FileMaker layouts on the web Introduction 1 Part I: Basics of Web Publishing Chapter 1: How Web Publishing Works 7 Chapter 2: Introduction to HTML 17 Chapter 3: Introduction to PHP 31 Part II: Laying the Groundwork Chapter 4: Building a Simple FileMaker File 49 Chapter 5: Configuring the Server(s) 67 Part III: Publishing FileMaker Data on the Web Chapter 6: Viewing FileMaker Data 91 Chapter 7: Altering FileMaker Data 115 Chapter 8: Working with Related Data (Portals) 137 Chapter 9: Working with Images 167 Chapter 10: Repurposing a FileMaker Layout on the Web 189 Part IV: More Information Appendix A: Performance Tuning 213 Appendix B: Security Concerns 217 Appendix C: Error Handling and Prevention 225 Appendix D: FileMaker PHP API Reference 231 Index 239

Author Biography

Jonathan Stark is the president of Jonathan Stark Consulting, a software consulting firm specializing in data solutions for creative professionals. Past clients include Staples, Turner Broadcasting, and Ambrosi (now Schawk). He has spoken at the FileMaker Developers Conference and has had numerous articles published in FileMaker Advisor and phparchitect magazines. Jonathan is reluctant to admit that he began his programming career more than 20 years ago on a Tandy TRS-80.

 

Table of Contents

Introduction	p. 1
Part I
How Web Publishing Works	p. 7
Introduction to HTML	p. 17
Introduction to PHP	p. 31
Laying the Groundwork
Building a Simple FileMaker File	p. 49
Configuring the Server(s)	p. 67
Publishing FileMaker Data on the Web
Viewing FileMaker Data	p. 91
Altering FileMaker Data	p. 115
Working with Related Data (Portals)	p. 137
Working with Images	p. 167
Repurposing a FileMaker Layout on the Web	p. 189
More Information
Appendix A	p. 213
Appendix B	p. 217
Appendix C	p. 225
Appendix D
Reference	p. 231
Index	p. 239
Table of Contents provided by Publisher. All Rights Reserved.

Excerpts

= 0) {slash = '\\';} else {slash = '/';}openLoc = figLoc.substring(0, figLoc.lastIndexOf(slash) + 1);while (pPage.substring(0,3) == '../') {openLoc = openLoc.substring(0, openLoc.lastIndexOf(slash, openLoc.length - 2)+ 1);pPage = pPage.substring(3, pPage.length + 1);}popUpWin =window.open('','popWin','resizable=1,scrollbars=1,location=0,toolbar=0,width=525,height=394');figDoc = popUpWin.document;zhtm= ' ' + pPage + ' ';zhtm += ' ';zhtm += ' ';zhtm += ' ';zhtm += '' + pPage.substring(pPage.lastIndexOf('/') + 1, pPage.length) + '';zhtm += ' ';figDoc.write(zhtm);figDoc.close();}// modified 3.1.99 RWE v4.1 --> Introduction Introduction Introduction to the IntroductionHi! Thanks for picking up my book. I sincerely hope that it finds its way to a convenient spot on your desk. Nothing would warm my heart more than to see a beat-down, dog-eared, coffee-stained copy of this book right next to your computer.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. Okay, Here's the Real IntroductionSome background: I didn't go to school for computer science. I graduated from Berklee College of Music with a Bachelors of Music degree back in 19... well, a long time ago. Berklee is a pretty hard-core music school and lots of world-class players have come out of there. I was definitely not one of those cats (omg--did I just say "cats"?).At the time, I was an average guitar player at best, I had never been in a band, and I didn't really know any songs. In a word, I stunk. However, I was a whiz at music theory. I couldn't get enough of it. The more I learned, the more I wanted to know.After college, I got into a Boston-area punk band that mostly played really fast, really loud, three-chord tunes. We wore wigs. While I was in that band, I realized exactly what I hadn't learned at Berklee: PERSPECTIVE. I had absolutely none. Somehow, I had ended up knowing all sorts of esoteric stuff, but none of the basics.That being the case, I learned more useful musical knowledge in that band than I ever did at Berklee. Not only was I learning the basics, but I was learning that 80% of the time, the basics are all that is called for.Okay, now for the moral of the story. This book (and my classes) was created with this experience in the forefront of my mind. As an educator, I strive to give the basics the attention that they deserve. This might sound like an obvious w