• PHP is the most widely used scripting language on the web. It's accessible, well documented, and easy to learn. When FileMaker Inc. released their API for PHP a new door was opened to build rich web applications that interact with FileMaker Pro databases. This VTC course will introduce you to the PHP language, FileMaker's API for PHP, and best practices for Custom Web Publishing with PHP.

CONTENT:

Welcome
The Development Environment
Static Web Publishing
Dynamic Web Publishing with PHP
PHP Basics
Code Basics
Variable Basics
Working with Text
PHP Settings
Include and Require
Redirects and Resources
PHP Flow Control
Selection with IF
Selection with SWITCH
While Loop
For Loop
Foreach Loop
Continue and Break
Exiting Scripts
Logging Errors
FileMaker and PHP
Ready Your Files
Ready Your Server
Ready Your HTML Skills
Ready Your FileMaker API for PHP
Talking to FileMaker pt. 1
Talking to FileMaker pt. 2
PHP Arrays
Numeric Arrays
Associative Arrays
Explode and Implode
Multidimensional Arrays
Arrays from FileMaker
Traversing Arrays pt. 1
Traversing Arrays pt. 2
Array Reference
Performing Finds
Command Functions
Find Commands
Building Your Layout
Adding Find Criteria
Working with Results
Working with Records
Trapping for Errors
Building Your Form
Form Processing pt. 1
Form Processing pt. 2
HTML Formatting
Data Lists and Tables
Intermediate Find Techniques
Displaying Select Menus
FileMaker Value Lists
Select List Triggered Finds
Drill Down Finds pt. 1
Drill Down Finds pt. 2
Drill Down Finds pt. 3
Sorts / Scripts / Results
Sorting Records
Limiting Results
Result Layout
Perform Script pt. 1
Perform Script pt. 2
Script Parameters pt. 1
Script Parameters pt. 2
Script Results pt. 1
Script Results pt. 2
Script Results pt. 3
Related Records and Compound Finds
Related Fields
Displaying Portals pt. 1
Displaying Portals pt. 2
Compound Finds pt. 1
Compound Finds pt. 2
Compound Finds pt. 3
Compound Find with Omit
Custom Functions
Format and Declaration
Passing Variables
GOBAL Scope and Results
Work with Records
Creating the Form
Creating Records pt. 1
Creating Records pt. 2
Editing Records pt. 1
Editing Records pt. 2
Creating Related Records
Deleting Related Records
Deleting Records
Working with Container Data
Displaying Container Data
Exporting Container Data
Formatting Output Data
Formatting Text
Formatting Numbers
Formatting Date and Time
Summarizing Data
Intro to Sub Summary Design
Build Layouts and Finds
Multi-Dimensional pt. 1
Multi-Dimensional pt. 2
Sub Summary Totals
Grand Totals
Record Formatting pt. 1
Record Formatting pt. 2
Dynamic Data
Dynamic Value List
Dynamic Sort
Dynamic Summary
Conclusion
Course Wrap Up
Credits
About the Author