O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

FileMaker 9 & PHP Foundations

Video Description

The most popular web scripting language PHP* is now distributed and supported by the most efficient desktop database software company FileMaker Inc**. If you know FileMaker and you want to use your data on the web this tutorial shows you the "How-To" from a leading industry expert. The tutorial curriculum is developed as an A-to-Z package. You will be introduced to Custom Web Publishing using FileMaker Server 9, taught the essentials of PHP, and then discover the powerful methods of FileMaker's new API for PHP. Learn the solid foundations of custom web development with PHP and FileMaker Pro***. To begin learning FileMaker 9 & PHP Foundations, simply click on the movie links below.

* FileMaker distributes PHP 5.x

** Requires a copy of FileMaker Server 9

*** Requires a copy of FileMaker Pro 9

Table of Contents

  1. Introduction
    1. Welcome 00:06:29
    2. Web Publishing with PHP 00:03:23
    3. Custom Web Publishing with PHP 00:03:16
    4. The Development Environment 00:05:42
  2. PHP Basics
    1. Code Basics pt. 1 00:04:06
    2. Code Basics pt. 2 00:04:28
    3. Variable Basics 00:05:47
    4. General Output 00:06:37
    5. Advanced Output pt. 1 00:03:59
    6. Advanced Output pt. 2 00:03:21
    7. Include & Require 00:04:38
    8. Configuring PHP pt. 1 00:04:52
    9. Configuring PHP pt. 2 00:03:06
    10. Redirects & Resources 00:06:25
  3. PHP Flow Control
    1. Selection with 00:04:51
    2. Selection with 00:03:25
    3. Selection with 00:06:05
    4. Repetition pt. 1 00:03:20
    5. Repetition pt. 2 00:03:12
    6. Continue & Break 00:04:46
    7. Terminate & Capture pt. 1 00:03:00
    8. Terminate & Capture pt. 2 00:04:28
  4. PHP Data
    1. Data Types pt. 1 00:05:01
    2. Data Types pt. 2 00:03:11
    3. Globals & Constants 00:05:14
    4. Testing Variables & Constants 00:05:21
  5. PHP Arrays
    1. Creating Arrays pt. 1 00:04:28
    2. Creating Arrays pt. 2 00:02:47
    3. Working with Arrays 00:05:45
    4. Multi-Dimensional Arrays 00:03:39
    5. Traversing Arrays pt. 1 00:05:34
    6. Traversing Arrays pt. 2 00:05:31
    7. Traversing Arrays pt. 3 00:02:26
    8. Traversing Arrays pt. 4 00:04:50
    9. Modifying Arrays pt. 1 00:03:48
    10. Modifying Arrays pt. 2 00:04:45
    11. Testing Arrays pt. 1 00:03:02
    12. Testing Arrays pt. 2 00:05:32
    13. Testing Arrays pt. 3 00:01:38
  6. PHP Custom Functions & Objects
    1. Defining Functions 00:05:45
    2. Passing Parameters 00:04:38
    3. Output & Returns 00:04:52
    4. Passing By Reference pt. 1 00:04:35
    5. Passing By Reference pt. 2 00:03:26
    6. Defining Objects 00:05:58
    7. Instances & Assignments 00:04:39
    8. Methods & Properties 00:05:45
    9. Extending Objects 00:05:45
    10. Scope Resolution & Static Components 00:05:32
  7. FileMaker's API for PHP
    1. Files & Documentation 00:04:01
    2. Including the FileMaker Class 00:04:53
    3. Preparing FileMaker Files for API Access 00:05:05
    4. Creating & Using the FileMaker Object 00:04:49
    5. FileMaker Method Results 00:04:41
    6. FileMaker Error Checking 00:06:18
    7. Reviewing Command Classes 00:06:12
    8. Reviewing Non-Command Classes 00:05:23
  8. Performing Basic Finds
    1. Find Any 00:06:12
    2. Exploring Result Objects 00:05:07
    3. Exploring Record Objects 00:05:26
    4. Find All 00:06:15
    5. Perform Find pt. 1 00:05:23
    6. Perform Find pt. 2 00:06:02
    7. Perform Find pt. 3 00:06:09
    8. Searching Related Data 00:05:46
  9. Performing Advanced Finds
    1. User Event Finds pt. 1 00:06:44
    2. User Event Finds pt. 2 00:06:19
    3. Finding by Script pt. 1 00:05:38
    4. Finding by Script pt. 2 00:05:37
    5. Finding by Relationship & Displaying Portals pt. 1 00:04:40
    6. Finding by Relationship & Displaying Portals pt. 2 00:05:37
    7. Finding by Relationship & Displaying Portals pt. 3 00:05:46
    8. Finding by RecordID pt. 1 00:05:18
    9. Finding by RecordID pt. 2 00:06:36
    10. Compound Finds pt. 1 00:05:43
    11. Compound Finds pt. 2 00:06:08
  10. Formatting Output Data
    1. Formatting Value Lists pt. 1 00:05:42
    2. Formatting Value Lists pt. 2 00:05:52
    3. Formatting Form Elements pt. 1 00:06:15
    4. Formatting Form Elements pt. 2 00:05:59
    5. Formatting Text & Numbers 00:06:47
    6. Formatting Dates & Times 00:06:33
  11. Preparing Data for Input
    1. Security & User Input 00:06:39
    2. API Validation Tools pt. 1 00:06:34
    3. API Validation Tools pt. 2 00:06:38
    4. API Validation Tools pt. 3 00:03:20
    5. Converting Form Elements 00:06:53
  12. Working with Records
    1. Editing with the Edit Command pt. 1 00:06:56
    2. Editing with the Edit Command pt. 2 00:06:33
    3. Editing with the Record Object pt. 1 00:05:01
    4. Editing with the Record Object pt. 2 00:04:48
    5. Creating Records 00:05:13
    6. Deleting Records 00:04:46
    7. Duplicating Records 00:05:57
  13. Summarizing Data
    1. PHP & Sub Summary Reports 00:05:57
    2. From Records to Arrays pt. 1 00:06:32
    3. From Records to Arrays pt. 2 00:06:19
    4. Building Sub-Summary Arrays pt. 1 00:06:13
    5. Building Sub-Summary Arrays pt. 2 00:06:42
    6. Display Summary Arrays pt. 1 00:05:19
    7. Display Summary Arrays pt. 2 00:06:19
    8. Producing Leading Grand Totals pt. 1 00:06:41
    9. Producing Leading Grand Totals pt. 2 00:06:36
  14. Working with Container Data
    1. Displaying Container Data 00:06:55
    2. Exporting Container Data 00:05:57
  15. Conclusion
    1. Overview & Closing 00:03:47
    2. About the Author 00:00:53