Web Publishing with PHP and FileMaker 9 (Paperback)

by Jonathan Stark (Author)
Key Phrases: admin console, web viewer, database server, Product Catalog, Model Number, Product List (more...)

Editorial Reviews

Product Description

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 to…

• 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

About the Author

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.

 

See all Editorial Reviews

Product Details

• Paperback: 264 pages
• Publisher: Sams; 1 edition (September 15, 2007)
• Language: English
• ISBN-10: 0672329506
• ISBN-13: 978-0672329500
• Product Dimensions: 9 x 6.9 x 0.4 inches
• Shipping Weight: 14.9 ounces (View shipping rates and policies)
• Average Customer Review: 5.0 out of 5 stars See all reviews (7 customer reviews)
• Amazon.com Sales Rank: #206,736 in Books (See Bestsellers in Books)

  Popular in these categories: (What's this?)

  #15 in	Books > Computers & Internet > Databases > Specific Databases > FileMaker
  #95 in	Books > Computers & Internet > Web Development > Programming > PHP

Customer Reviews

Most Helpful Customer Reviews

14 of 14 people found the following review helpful:

5.0 out of 5 stars PHP and FileMaker Integration - a fast and enjoyable journey!, February 3, 2008

By	Timothy Dietrich "filemaker addict" (Richmond, Virginia USA) - See all my reviews (REAL NAME)

Over the holiday break I had some time to read (a better word might be "consume") Jonathan Stark's book "Web Publishing with PHP and FileMaker 9." In a little more than 250 pages, Jonathan manages to do the impossible: He explains how to put the FileMaker API for PHP to use.

The book is divided into four logical sections. The first section provides background information for those new to the world of Web publishing, including an introduction to HTML and PHP. After reading this section, you won't be an HTML expert, and you certainly won't be a PHP pro. But you will have a good understanding of the technologies involved in Web publishing and development, and how those technologies fit together.

The second section of the book provides a foundation for the examples that are used later on. The section includes a chapter on how to setup a FileMaker database (creating fields, working with the database, performing finds, and so on). I'm sure that the majority of readers will find this section to be unnecessary and might be tempted to skip it. However, the chapter does cover one key topic that you should take a few minutes to check out, and that is an explanation on how to setup a FileMaker account (and grant it the correct privileges) that PHP can use to connect to the database.

The second section also covers installation, deployment, and configuration of FileMaker Server, as well as the new PHP Site Assistant. Jonathan makes a recommendation -- and one that I heartily agree with -- that if you do not absolutely need your own server, then using a server provided by a Web hosting provider is an ideal solution. However, if you do have your own server, you'll find this information to be of great use.

The third section of "Web Publishing with PHP and FileMaker 9" includes what I consider to be the most valuable information in the book. This section covers the FileMaker API for PHP (often referred to as "FileMaker.php") itself, and does so using an example Web application that is developed and expanded throughout the section. The application is one that most readers will be able to associate with -- an online product catalog.

The section includes chapters on how to select, sort, and do finds against a FileMaker database using PHP. Another chapter explains how to alter FileMaker data over the Web, including the creation of new records and updates and deletions of existing records. There are also chapters on how to view, add, edit, and delete related data via PHP (which is accomplished using portals), as well as some very useful information on how to work with images (including images stored in container fields and those stored by reference using URLs).

The last chapter in the third section describes a very interesting concept: Developing a PHP application that automatically updates as the FileMaker layouts that it is built on are updated. For example, if a field is added or removed, the PHP application automatically adds and/or drops the field as well. If you are looking for an easy way to let your FileMaker users "self-manage" a PHP application, then this chapter will prove to be invaluable to you.

"Web Publishing with PHP and FileMaker 9" covers a lot of ground, and does so in a way that makes it a fast and enjoyable journey. Jonathan's writing style and "voice" make it easy to follow along with the material. His expert knowledge of PHP and FileMaker is apparent, and he does a great job of sharing that knowledge in the book.

If you are looking for a good book on PHP and FileMaker integration -- whether you are new to the topic or consider yourself to be a pro -- then I highly recommend picking up a copy of "Web Publishing with PHP and FileMaker 9."

7 of 7 people found the following review helpful:

5.0 out of 5 stars Excellent down-to-code approach, November 6, 2007

By	Kirk Bowman "FileMaker developer" (Dallas, Texas USA) - See all my reviews (REAL NAME)

This book is an excellent introduction to HTML, PHP and the FileMaker API. Jonathan has an easy-to-read style. I found it to be a quick and informative read. I enjoyed how he can cover a topic in sufficient depth without the material being too long. This book focuses on the code in a text editor (rather than a visual editor), which is the best way to truly master the subject. Each chapter covers a specific topic so you can read it cover to cover or just focus on the material that is of interest to you. Well done Jonathan!

5 of 5 people found the following review helpful:

5.0 out of 5 stars Clear, precise and even fun., November 29, 2007

By	Alan G. Hagerty "awards123" (Atlanta, GA USA) - See all my reviews (REAL NAME)

FileMaker and PHP are absolutley the way to go, and this is
THE BEST BOOK to get for Filemaker web publishing.
As a "non-programmer" who has struggled in the past trying to bring a database to the web,
I found the examples in this book easy to follow and understand.
It definately took me to the next level.