Machine derived contents note: Introduction -- Chapter 1: Introduction to Web Publishing with FileMaker -- Why PHP and FileMaker? -- What's So Great about PHP? -- Requirements -- Interface Differences -- Summary -- Chapter 2: Setting Up Your Web Server -- What You Need to Write and Test Your PHP Pages -- Local or Remote Testing -- Choosing a PHP Script Editor -- Setting Up IIS on Windows -- Setting Up Apache on Mac -- PHP Installation Options -- Testing Your PHP Installation -- Summary -- Chapter 3: Setting Up FileMaker Server 9 -- Single Computer Installation for FileMaker Server 9 -- Multiple Computer Installation for FileMaker Server 9 -- The Worker Computer -- The Master Computer -- Deployment Assistant -- Manually Installing the FileMaker API for PHP -- Testing Your Installation -- Summary -- Chapter 4: Configuring FileMaker Server Admin Console -- FileMaker Server Admin Console -- Summary -- Chapter 5: Preparing Your FileMaker Database for the Web -- Creating the Blog Database -- Creating the Tables -- Creating the Fields for Each Table -- The Posts Table -- The Commenter Table -- The Comments Table -- The Categories Table -- The Relationships -- Adding Value Lists to the Database -- Layout Mode -- Portals -- Setting Up the FileMaker Accounts -- Summary -- Chapter 6: HTML Basics -- HTML Review -- What Do I Need to Get Started? -- Web Site Folder Setup -- Exercise 1: Adding a Title -- Exercise 2: Working with Headers -- Exercise 3: Text Manipulation -- Exercise 4: Adding Emphasis -- Exercise 5: Formatted Lists -- Exercise 6: Images -- Exercise 7: Sending Emails with a Link -- Exercise 8: Anchors Aweigh! -- Exercise 9: Tables -- Manipulating Cell Data -- Creating Clickable Links in a Table -- Adding Images to Tables -- Working with and -- Nested Tables -- Changing Text and Background Colors of Cells -- I Never Meta Refresh I Didn't Like -- Sending Emails from the Web -- Summary -- Chapter 7: CSS Basics -- Cascading Stylesheets -- Fonts -- Font Size -- Font Weight -- Font Style -- Margins -- Top and Bottom Margins -- Alignment -- Text Decoration -- Commenting Your Code -- Backgrounds -- Background Image -- Fixed Background Images -- Repeating Background Images -- Repeat-x -- Repeat-y -- Background Position -- Vertical Alignment -- Combining Vertical and Horizontal Alignment -- Background Property -- Multiple Stylesheets -- Summary -- Chapter 8: PHP Basics -- PHP Scripts -- Displaying Text -- Variables -- Hip Hip Array -- Creating a Simple Array -- Creating an Array with Keys -- Creating an Array by Specifying Each Index -- Replacing an Element in the Array -- Adding an Element to the End of the Array -- Removing an Element from the End of the Array -- Removing an Element from the Beginning of the Array -- Adding an Element to the Beginning of the Array -- Sorting an Array Ascending Alphabetically -- Sorting an Array Descending Alphabetically -- Separating and Printing the Array Elements as a Text String -- PHP Functions -- Conditions -- Includes -- Comments -- Quotes -- Special Characters -- Summary -- Chapter 9: Links and Forms -- What Type of Navigation Should You Use? -- GET and POST -- Links -- Relative Links -- Absolute Links -- Sending Data in a Link -- Forms -- Types of Form Elements -- Text -- Hidden -- Radio Buttons -- Check Boxes -- Select Lists -- Text Areas -- The Response Page -- Viewing the Passed Data -- Summary -- Chapter 10: Validation -- Validating the Existence of a Form Value -- Validating Empty Form Values -- Validating Numbers -- Validating String Length -- Validating Email Format -- Summary -- Chapter 11: What Is the API for PHP? -- What Is an API? -- A Little Bit of History -- Anatomy of the FileMaker API for PHP -- Summary -- Chapter 12: Creating the Blog and Performing a Simple Query -- What Is a Blog? -- Include File Structure of the Blog -- The Header and Footer Files -- Cascading Stylesheets -- The About Blog Section -- Preparing the Connection Include Folder -- Creating a Connection Include File -- Constructing the Blog Index Page -- Adding a Final All Command to List Posts -- Displaying a Simple Result Set -- Summary -- Chapter 13: Creating New Records and Sorting -- Record Creation Process -- New Record Command -- Building the Input Form -- Processing Form Data Correctly -- Understanding the POST and GET Functions -- Creating the New Record -- Sorting with the FileMaker API -- Adding Sorting to the Home Page -- Summary -- Chapter 14: Database Searches and Limits -- Beyond the Find All -- There Is Also a Find Any Command -- Anatomy of a Find -- About Find Parameters and Logical Operators -- Important Field Name Limitations -- Creating a Blog Search Form -- Creating the Results Page -- Adding Limits to the Search Results -- Using Skip Record Parameters -- Integrating Limits and Skip to Achieve Paging -- Exact Searches and Other Modifiers -- Adding a View Blog Post Link -- View a Single Blog Post Record -- Summary -- Chapter 15: Editing and Deleting Records -- Overview of the Record Object -- Linking to a Single Editable Record -- Building Editable Forms -- Building the Edit Post Script -- Deleting Records -- Summary -- Chapter 16: Working with Data Portals -- Reviewing Related Records and Portals -- Related Record Portal Web Requirements -- Notable Limitations -- Portal Workflow within PHP -- Accessing a Related Set of Data -- Adding a New Related Record -- Isolating a Related Record -- Creating a Related Record Edit Link -- Isolating the Linked Related Record -- Editing a Related Record -- Deleting a Related Record -- Summary -- Chapter 17: Value Lists -- What Are FileMaker Value Lists? -- Why Use FileMaker Value Lists on the Web? -- Requirements for Value Lists -- HTML Drop-downs, Radio Buttons, and Check Boxes -- Retrieving a Value List from the Database -- Building a Dynamic Value List Drop-down -- Building a Dynamic Value List Radio Button Set -- Building a Dynamic Value List Check Box Set -- Adding Empty Default Values -- Creating a Value List Driven Form -- Processing Form Results for Drop-downs and Radio Buttons -- Processing Form Results for Check Boxes -- Taking It to the Next Level-Selecting Values with PHP -- Creating the Commenter Find Request and Basic Form -- Selecting Drop-down Values -- Selecting Radio Button Values -- Selecting Checked Check Boxes -- Implementing the Edit Command -- Limitations of FileMaker Value Lists on the Web -- Summary -- Chapter 18: PHP Sessions -- What Are Sessions? -- Why Use Sessions? -- Using Sessions -- Session Example-Remembering Form Data -- Testing the Session Form Flow -- Chapter 19: Creating Login Authentication Schemes -- Authentication Methods -- Table-based Authentication -- Account-based Authentication -- Table-based Authentication-Building the Login Form -- Table-based Authentication-Building a Protected Page -- Account-based Authentication-Implementation -- Detailed Overview of acountLogin Function -- Other Authentication Methods-Active Directory -- Troubleshooting Authentication Schemes -- Summary -- Chapter 20: File Uploads with PHP and FileMaker -- How Do File Uploads Work? -- Preparing a Form for a File Upload -- Accessing the File Upload with PHP -- Debugging File Uploads-Error Codes Explained -- Connecting Uploaded Files to FileMaker Data -- Important Limitations -- Summary -- Chapter 21: Sending Emails with PHP -- Anatomy of an Email -- Requirements for Sending Email from PHP -- Basic Email from PHP -- Adding a Proper From Address -- CC and BCC Address Headers -- Reply To Address Headers -- Sending HTML Emails -- Custom Character Encodings -- Email Security and Post Data -- Building a Feedback Form -- Adding an "Email a Post" Option to the Blog -- Summary -- Chapter 22: Debugging Connectivity Issues -- Common Connectivity Issues -- Printing Debugging Information -- Checking the Database Authentication Credentials -- Investigating Specific Error Codes -- Local Firewalls -- Routers and ISPs -- Secure Connections -- DNS Issues and Dynamic IPs
Text of Note
When in Doubt, Search the Web -- Summary -- Chapter 23: Wildcards -- What Wildcards Are Available? -- Entering Literal Wildcard Characters -- Replacing Wildcards through a Regular Expression -- Usage Examples -- Summary -- Chapter 24: Going Beyond the Basics -- Only the Beginning -- Things to Know Before Continuing -- Experiment and Learn -- The Sky Is the Limit -- Appendix A: Error Codes -- Appendix B: Additional Resources.