Wordware Publishing FileMaker Web Publishing, A Complete Guide to Using the API for PHP (2008).pdf

FileMaker Web

Publishing

A Complete Guide to Using

the API for PHP

Allyson Olm, Stephen Knight,

and Michael Petrov

Wordware Publishing, Inc.

Library of Congress Cataloging-in-Publication Data

Olm, Allyson.

FileMaker Web publishing : a complete guide to using the API for PHP / by Allyson Olm,

Stephen Knight, and Michael Petrov.

p. cm.

Includes index.

ISBN-13: 978-1-59822-041-4

ISBN-10: 1-59822-041-1

1. FileMaker (Computer file). 2. Web publishing. 3. PHP (Computer program language).

I. Knight, Stephen, 1968- II. Petrov, Michael. III. Title.

TK5105.888.O465 2007

005.75'65--dc22

2007026436

1100 Summit Avenue, Suite 102

Plano, Texas 75074

No part of this book may be reproduced in any form or by any means

without permission in writing from Wordware Publishing, Inc.

Printed in the United States of America

ISBN-13: 978-1-59822-041-4

ISBN-10: 1-59822-041-1

10987654321

0707

FileMaker is a registered trademark of FileMaker, Inc. in the U.S. and other countries.

All of the logos in Appendix B are used with the permission of their respective owners. Other brand names and

product names mentioned in this book are trademarks or service marks of their respective companies. Any omission

or misuse (of any kind) of service marks or trademarks should not be regarded as intent to infringe on the property of

others. The publisher recognizes and respects all marks used by companies, manufacturers, and developers as a

means to distinguish their products.

This book is sold as is, without warranty of any kind, either express or implied, respecting the contents of this book

and any disks or programs that may accompany it, including but not limited to implied warranties for the book’s

quality, performance, merchantability, or fitness for any particular purpose. NeitherWordware Publishing, Inc. nor its

dealers or distributors shall be liable to the purchaser or any other person or entity with respect to any liability, loss, or

damage caused or alleged to have been caused directly or indirectly by this book.

All inquiries for volume purchases of this book should be addressed to Wordware Publishing,

Inc., at the above address. Telephone inquiries may be made by calling:

(972) 423-0090

Contents

Acknowledgments ............................xi

Introduction ..............................xiii

Chapter 1 IntroductiontoWebPublishingwithFileMaker.......1

WhyPHPandFileMaker?........................2

What’sSoGreataboutPHP?......................2

Requirements ..............................3

Macintosh...............................3

Windows................................4

InterfaceDifferences ..........................5

Summary.................................6

Chapter 2 SettingUpYourWebServer .................7

WhatYouNeedtoWriteandTestYourPHPPages..........8

LocalorRemoteTesting.........................8

ChoosingaPHPScriptEditor......................9

Dreamweaver.............................9

TextWrangler ............................10

Nvu..................................11

SettingUpIISonWindows ......................12

SettingUpApacheonMac.......................15

PHPInstallationOptions........................16

TestingYourPHPInstallation.....................19

Summary ................................21

Chapter 3 SettingUpFileMakerServer ................23

SingleComputerInstallationofFileMakerServer9.........24

MultipleComputerInstallationofFileMakerServer9 .......28

TheWorkerComputer .......................28

TheMasterComputer .......................31

DeploymentAssistant.........................34

Manually Installing the FileMaker API for PHP ...........40

TestingYourInstallation........................41

Summary ................................44

Chapter 4 ConfiguringFileMakerServerAdminConsole.......45

FileMakerServerAdminConsole...................46

Summary ................................49

iii

Contents

Chapter 5 Preparing Your FileMaker Database for the Web .....51

CreatingtheBlogDatabase......................52

CreatingtheTables...........................53

CreatingtheFieldsforEachTable ..................55

ThePostsTable...........................55

TheCommentersTable.......................57

TheCommentsTable........................58

TheCategoriesTable........................59

TheRelationships..........................59

AddingValueListstotheDatabase..................65

LayoutMode..............................69

Portals..................................73

SettingUptheFileMakerAccounts..................78

Summary ................................80

Chapter 6 HTMLBasics.........................81

HTMLReview .............................81

WhatDoINeedtoGetStarted?....................82

WebsiteFolderSetup..........................82

Exercise1—AddingaTitle....................83

Exercise2—WorkingwithHeaders ...............84

Exercise3—TextManipulation..................86

Exercise4—AddingEmphasis ..................90

Exercise5—FormattedLists...................92

Exercise6—Images........................95

Exercise7—SendingEmailswithaLink............100

Exercise8—AnchorsAweigh!..................102

Exercise9—Tables........................104

ManipulatingCellData.....................109

CreatingClickableLinksinaTable ..............112

AddingImagestoTables....................113

Workingwith<rowspan>and<colspan>..........114

NestedTables..........................118

ChangingTextandBackgroundColorsofCells........119

I Never Meta Refresh I Didn’t Like .................122

SendingEmailsfromtheWeb ....................123

Summary................................125

Chapter 7 CSSBasics..........................127

Cascading Style Sheets ........................127

Fonts..................................133

FontSize..............................135

FontWeight.............................135

FontStyle..............................136

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika: