Web Publishing with PHP and FileMaker 9 and over one million other books are available for Amazon Kindle. Learn more

Buy New

or
Sign in to turn on 1-Click ordering.
or
Amazon Prime Free Trial required. Sign up when you check out. Learn More
Buy Used
Used - Good See details
$14.18 & eligible for FREE Super Saver Shipping on orders over $25. Details

or
Sign in to turn on 1-Click ordering.
 
   
More Buying Choices
Have one to sell? Sell yours here
Web Publishing with PHP and FileMaker 9
 
 
Start reading Web Publishing with PHP and FileMaker 9 on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Web Publishing with PHP and FileMaker 9 [Paperback]

Jonathan Stark (Author)
5.0 out of 5 stars  See all reviews (7 customer reviews)

List Price: $44.99
Price: $27.24 & this item ships for FREE with Super Saver Shipping. Details
You Save: $17.75 (39%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
In Stock.
Ships from and sold by Amazon.com. Gift-wrap available.
Only 5 left in stock--order soon (more on the way).
Want it delivered Monday, February 13? Choose One-Day Shipping at checkout. Details
Textbook Student FREE Two-Day Shipping for students on millions of items. Learn more

Formats

Amazon Price New from Used from
Kindle Edition $16.20  
Paperback $27.24  

Book Description

September 15, 2007 0672329506 978-0672329500 1

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


Frequently Bought Together

Web Publishing with PHP and FileMaker 9 + FileMaker Web Publishing: A Complete Guide to Using the API for PHP + FileMaker® 9 Developer Reference: Functions, Scripts, Commands, and Grammars, with Extensive Custom Function Examples
Price For All Three: $95.76

Show availability and shipping details

Buy the selected items together


Editorial Reviews

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.

 

Excerpt. © Reprinted by permission. All rights reserved.

Introduction

Introduction

Introduction to the Introduction

Hi! 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 Introduction

Some 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 way to approach an instructional book, but all too often, I find that authors (who are typically experts in their field) tend to gloss over the basics and jump to the esoteric (that is, fun) stuff. It's easy to forget what it is like to be a beginner when you have been practicing a discipline for the better part of 20 years.

The issue of how much time to devote to basic versus esoteric topics is further muddied by the fact that some of the esoteric stuff is superimportant. I have tried to address that issue here by relegating important yet esoteric topics to notes that are called out throughout the book and in the appendixes in Part IV. It's stuff that you need to know, but that I felt would have obscured the point of the examples in other sections of the book had it been included there.

This book essentially covers three topics: HTML, PHP, and FileMaker. I have taken pains to start at the very beginning of each of the topics in an effort to cover the basics for the total beginner. Furthermore, I have built in a fair amount of repetition into the examples, which I hope will provide some perspective. The examples are sort of a microcosm of what you can expect in day-to-day development.

If you have experience in one or more of these areas, there might very well be sections that you should skip over. If you are already familiar with HTML and PHP, you might completely skip Part I. If you already know how to build a FileMaker layout, most of Chapter 4, "Building a Simple FileMaker File," is probably not going to introduce any earth-shattering concepts.

Conclusion to the Introduction

My advice is to jump around if you want, underline things, scribble notes in the margin, fold the page corners over...whatever it takes. If you are doing web publishing with FileMaker, I'm confident that you can wring a lot of useful information out of this little book. And if I'm wrong, maybe you can at least kill a few bugs with it.

Please feel free to contact me with thoughts, questions, suggestions, errata, and so on. You can reach me through my website at

http://jonathanstark.com/contact.php
Happy web publishing!
Jonathan Stark
Providence, RI
June 2007

How This Book Is Organized

Web Publishing with PHP and FileMaker is broken into four parts, each relatively independent of the others. This structure should allow you to skip any sections of the book that cover topics with which you are already familiar.

  • Part I, "Basics of Web Publishing," provides an overview of the architecture of the web, explains how to write HTML documents, and covers the most important features of the PHP scripting language.

  • Part II, "Laying the Groundwork," is devoted to building a FileMaker database file, setting up and configuring the FileMaker Server software, and using the PHP Site Assistant tool.

  • Part III, "Publishing FileMaker Data on the Web," focuses on how to use the FileMaker application programming interface (API) for PHP to integrate FileMaker data into a website in a variety of ways, including creating, editing, and deleting records; displaying and uploading images; working with related data and portals; and re-creating a FileMaker layout on the web.

  • Part IV, "More Information," consists of more detailed and esoteric information pertaining to performance tuning, security concerns, and error handling and prevention.

Conventions Used in This Book

There are a few conventions used throughout this book that you should be aware of.

Web Pages

Obviously, there are lots of web page addresses in the book, for example: http://jonathanstark.com/. When you see one of these addresses (also known as a URL), you can go to that web page by entering the URL into the address bar in your web browser.

Code Samples

PHP code is displayed in this book in a monotype font, like so:

echo "This is some PHP code!"; 

In some spots, code is included in a line of otherwise normal text, like so:

"As you can see, I am using the echo command to output the $result variable."

When a line of code is too long to fit on one line of text, it is wrapped onto the next line. In this case, the continuation will be preceded with the code-continuation character, like this:

This is a super long line of code that does not fit on one line so the code-continuation character was used

Special Elements

As you read through this book, you'll note several special elements, presented in what we in the publishing business call "margin notes." Different types of margin notes are used for different types of information, as you see here.


Note - This is a note that presents some interesting but not necessarily essential information about a topic discussed in the surrounding text.



Caution - This is a caution that is something you should really pay attention to!




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 7.1 x 0.6 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 Best Sellers Rank: #378,249 in Books (See Top 100 in Books)

More About the Author

Jonathan Stark is a mobile application consultant who the Wall Street Journal has called an expert on publishing desktop data to the web. He has written three books on mobile & web programming, is a frequent speaker at leading mobile web conferences, and has been quoted in the media on internet and mobile lifestyle trends. Jonathan began his programming career more than 20 years ago on a Tandy TRS-80 and still thinks Zork was a sweet game.

 

Customer Reviews

7 Reviews
5 star:
 (7)
4 star:    (0)
3 star:    (0)
2 star:    (0)
1 star:    (0)
 
 
 
 
 
Average Customer Review
5.0 out of 5 stars (7 customer reviews)
 
 
 
 
Share your thoughts with other customers:
Most Helpful Customer Reviews

18 of 18 people found the following review helpful:
5.0 out of 5 stars PHP and FileMaker Integration - a fast and enjoyable journey!, February 3, 2008
This review is from: Web Publishing with PHP and FileMaker 9 (Paperback)
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."
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No


9 of 9 people found the following review helpful:
5.0 out of 5 stars Excellent down-to-code approach, November 6, 2007
This review is from: Web Publishing with PHP and FileMaker 9 (Paperback)
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!
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No


6 of 6 people found the following review helpful:
5.0 out of 5 stars Clear, precise and even fun., November 29, 2007
This review is from: Web Publishing with PHP and FileMaker 9 (Paperback)
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.
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No

Share your thoughts with other customers: Create your own review
 
 
 
Most Recent Customer Reviews





Only search this product's reviews



Inside This Book (learn more)
Key Phrases - Statistically Improbable Phrases (SIPs): (learn more)
admin console, web viewer, database server, search page, embedding images, web root directory, domain name registrar, editing records, simple website, layout group, server overview, record list page, inventory portal, product list page, php echo, php define, superglobal array, first page load, php block, portal records, product layout, portal row, container field, table occurrences, portal data
Key Phrases - Capitalized Phrases (CAPs): (learn more)
Product Catalog, Model Number, Product List, Related Data, Manage Database, Merry Tofu Substitute, Site Assistant, Skeeter's Egg Beaters, Configuring the Server, Storing Images, Home Page, Charcuterie de Leo, Full Access, List View, Data Entry Only, Related Table, Product Name Search, Deployment Assistant, Manage Accounts, Hello World, Server Advanced, New Product, Quick Start, Web Publishing, Can't Modify Auto
Browse Sample Pages:
Front Cover | Table of Contents | First Pages | Index | Back Cover | Surprise Me!
Search Inside This Book:

What Other Items Do Customers Buy After Viewing This Item?


Tags Customers Associate with This Product

 (What's this?)
Click on a tag to find related items, discussions, and people.
 
(4)

Your tags: Add your first tag
 

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
 


Active discussions in related forums
Search Customer Discussions
Search all Amazon discussions
   
Related forums



So You'd Like to...


Create a guide


Look for Similar Items by Category


Look for Similar Items by Subject