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

FileMaker Web Publishing offers an unparalleled development strategy for database managers, web designers, and programmers who are interested in getting the most out of FileMaker databases on the web. The book introduces the basics of HTML, cascading style sheets, and PHP, then moves on to specific concepts such as database portals, value lists, and complex navigation systems. Advanced topics include uploading and referencing files within the database and sending dynamically formatted emails.

Special Edition Using FileMaker 9 The only FILEMAKER 9 book you need We crafted this book to grow with you, providing the reference material you need as you move toward FileMaker® 9 proficiency and the use of more advanced features. If you buy only one book on FileMaker® 9, Special Edition Using FileMaker® 9 is the only book you need. Make the most of FileMaker 9: • Integrate the Web with FileMaker using the new Web Viewer • Use the new external data sources techniques with SQL and ODBC • Discover how to add supplemental fields in FileMaker to external SQL data sources • See how the major changes in script editing and debugging can help you • Learn new layout techniques, including conditional formatting and auto-resizing layout objects • Find out how to use the new FileMaker Server Admin Console to administer databases • Publish FileMaker databases on the Web using Instant Web Publishing, and use Custom Web Publishing with PHP or XML/XSLT “The new FileMaker 9 product line is the most dramatic new offering in years with over 30 ease-of-use breakthroughs; and Special Edition Using FileMaker 9 is an excellent desk reference and companion resource for all FileMaker professionals!” –Rick Kalman, Senior Product Manager, FileMaker, Inc. Jesse Feiler is a member of the FileMaker Business Alliance. He regularly consults on FileMaker and develops FileMaker solutions for small businesses, non-profits, art, retail point-of-sale, publishing, marketing, and other markets. He has created a number of video training courses, including one on FileMaker 7 and appears regularly on WAMC Northeast Public Radio’s Roundtable and Vox Pop shows. ON THE WEB Download modified FileMaker Starter solutions with added fields, scripts, and layouts to illustrate techniques in the book, along with other materials, from www.quepublishing.com and www.northcountryconsulting.com. Category Database Covers FileMaker 9 User Level Intermediate–Advanced

FileMaker Pro 9: The Missing Manual is the clear, thorough and accessible guide to the latest version of this popular desktop database program. FileMaker Pro lets you do almost anything with the information you give it. You can print corporate reports, plan your retirement, or run a small country -- if you know what you're doing. This book helps non-technical folks like you get in, get your database built, and get the results you need. Pronto. The new edition gives novices and experienced users the scoop on versions 8.5 and 9. It offers complete coverage of timesaving new features such as the Quick Start screen that lets you open or a create a database in a snap, the handy "save to" buttons for making Excel documents or PDFs, the multiple level Undo and Redo commands let you step backwards through your typing tasks, and much more. With FileMaker Pro 9: The Missing Manual, you can: Get your first database running in minutes and perform basic tasks right away. Catalog people, processes and things with streamlined data entry and sorting tools. Learn to use layout tools to organize the appearance of your database. Use your data to generate reports, correspondence and other documents with ease. Create, connect, and manage multiple tables and set up complex relationships that show you just the data you need. Crunch numbers, search text, or pin down dates and times with dozens of built-in formulas. Automate repetitive tasks with FileMaker Pro 9's easy-to-learn scripting language. Protect your database with passwords and set up privileges to determine what others can do once they gain entry. Outfit your database for the Web and import and export data to other formats. Each chapter in the book contains "living examples" -- downloadable tutorials that help you learn how to build a database by actually doing it. You also get plenty of sound, objective advice that lets you know which features are really useful, and which ones you'll barely touch. To make the most of FileMaker Pro 9, you need the book that should have been in the box.

Refocused and completely rewritten with the needs of business users and FileMaker Pro developers in mind, FileMaker Pro 9 Bible shows you how to design an industrial-strength database, make it intuitive, and automate it with scripts and programming. From the fundamentals to data modeling to writing no-fail code, you'll find the clear, step-by-step procedures, solid techniques, and detailed explanations you need to master this powerful software and build the right solutions for your needs.

Learn Filemaker? Pro 9 Provides A Logical, Hands-On Approach To Understanding The Features Of Filemaker Pro, Both For Beginners And Those Who Have Experience With Previous Versions Of The Software. From Defining Database Terms And Converting Files Created In Previous Filemaker Pro Versions To Producing Reports And Using Files On The Web, This Book Covers The Fundamentals As Well As The Newest Features That Considerably Enhance Filemaker Pro’S Database Management Capabilities. Learn How To Format Layout Objects With Autoresize And Conditional Formatting; Harness The Power Of The New External SQL Data Source Tools; Adapt One Script To Many Purposes To Cut Development Time And Expense; Work With The Enhanced Web Viewer To Harvest Data For Your Applications; Share Data As PDF And Excel Files And Export Data As E-Mail Attachments; Organize Your Relationships With The Anchor-Buoy Method; Use The Alignment Tools To Quickly Align Objects On Your Layout.

Advice and techniques that you need to get the job done. Looking for ways to streamline your work so that you can focus on maximizing your time? In Depth provides specific, tested, and proven solutions to the problems you run into every day—things other books ignore or oversimplify. This is the one book that you can rely on to answer all the questions you have now and will have in the future. In Depth offers: Comprehensive coverage, with detailed solutions Breakthrough techniques and shortcuts that are unavailable elsewhere Practical, real-world examples with nothing glossed over or left out Troubleshooting help for tough problems you can’t fix on your own Outstanding authors recognized worldwide for their expertise and teaching style Quick information via sidebars, tips, reminders, notes, and warnings In Depth is the only tool you need to get more done in less time! CATEGORY: Databases COVERS: FileMaker® Pro