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 and PHP Foundations

Video Description

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. To begin learning today, simply click on the movie links.

Table of Contents

  1. Introduction
    1. Welcome 00:04:27
    2. The Development Environment 00:04:53
    3. Static Web Publishing 00:03:25
    4. Dynamic Web Publishing with PHP 00:04:58
  2. PHP Basics
    1. Code Basics 00:04:34
    2. Variable Basics 00:04:37
    3. Working with Text 00:05:31
    4. PHP Settings 00:05:46
    5. Include and Require 00:04:15
    6. Redirects and Resources 00:05:21
  3. PHP Flow Control
    1. Selection with IF 00:04:54
    2. Selection with SWITCH 00:03:32
    3. While Loop 00:03:58
    4. For Loop 00:04:08
    5. Foreach Loop 00:04:08
    6. Continue and Break 00:04:18
    7. Exiting Scripts 00:03:54
    8. Logging Errors 00:04:58
  4. FileMaker and PHP
    1. Ready Your Files 00:04:40
    2. Ready Your Server 00:03:35
    3. Ready Your HTML Skills 00:04:11
    4. Ready Your FileMaker API for PHP 00:04:47
    5. Talking to FileMaker pt. 1 00:05:30
    6. Talking to FileMaker pt. 2 00:05:03
  5. PHP Arrays
    1. Numeric Arrays 00:04:10
    2. Associative Arrays 00:02:56
    3. Explode and Implode 00:03:40
    4. Multidimensional Arrays 00:02:36
    5. Arrays from FileMaker 00:05:11
    6. Traversing Arrays pt. 1 00:04:02
    7. Traversing Arrays pt. 2 00:06:38
    8. Array Reference 00:03:04
  6. Performing Finds
    1. Command Functions 00:03:50
    2. Find Commands 00:03:01
    3. Building Your Layout 00:04:38
    4. Adding Find Criteria 00:03:25
    5. Working with Results 00:04:18
    6. Working with Records 00:05:22
    7. Trapping for Errors 00:05:22
    8. Building Your Form 00:04:17
    9. Form Processing pt. 1 00:04:56
    10. Form Processing pt. 2 00:03:12
    11. HTML Formatting 00:03:54
    12. Data Lists and Tables 00:05:18
  7. Intermediate Find Techniques
    1. Displaying Select Menus 00:04:25
    2. FileMaker Value Lists 00:05:32
    3. Select List Triggered Finds 00:05:17
    4. Drill Down Finds pt. 1 00:05:04
    5. Drill Down Finds pt. 2 00:04:38
    6. Drill Down Finds pt. 3 00:05:17
  8. Sorts / Scripts / Results
    1. Sorting Records 00:05:22
    2. Limiting Results 00:04:06
    3. Result Layout 00:04:13
    4. Perform Script pt. 1 00:05:14
    5. Perform Script pt. 2 00:03:18
    6. Script Parameters pt. 1 00:05:56
    7. Script Parameters pt. 2 00:05:53
    8. Script Results pt. 1 00:03:02
    9. Script Results pt. 2 00:03:01
    10. Script Results pt. 3 00:05:55
  9. Related Records and Compound Finds
    1. Related Fields 00:05:30
    2. Displaying Portals pt. 1 00:05:28
    3. Displaying Portals pt. 2 00:05:55
    4. Compound Finds pt. 1 00:04:39
    5. Compound Finds pt. 2 00:04:21
    6. Compound Finds pt. 3 00:07:14
    7. Compound Find with Omit 00:04:49
  10. Custom Functions
    1. Format and Declaration 00:03:29
    2. Passing Variables 00:04:42
    3. GOBAL Scope and Results 00:05:37
  11. Work with Records
    1. Creating the Form 00:05:09
    2. Creating Records pt. 1 00:03:25
    3. Creating Records pt. 2 00:04:19
    4. Editing Records pt. 1 00:04:57
    5. Editing Records pt. 2 00:06:51
    6. Creating Related Records 00:06:32
    7. Deleting Related Records 00:06:36
    8. Deleting Records 00:03:40
  12. Working with Container Data
    1. Displaying Container Data 00:05:33
    2. Exporting Container Data 00:04:24
  13. Formatting Output Data
    1. Formatting Text 00:05:33
    2. Formatting Numbers 00:02:53
    3. Formatting Date and Time 00:05:42
  14. Summarizing Data
    1. Intro to Sub Summary Design 00:05:50
    2. Build Layouts and Finds 00:05:48
    3. Multi-Dimensional pt. 1 00:05:36
    4. Multi-Dimensional pt. 2 00:06:36
    5. Sub Summary Totals 00:05:38
    6. Grand Totals 00:04:04
    7. Record Formatting pt. 1 00:03:24
    8. Record Formatting pt. 2 00:05:22
    9. Dynamic Data 00:06:43
    10. Dynamic Value List 00:05:31
    11. Dynamic Sort 00:03:21
    12. Dynamic Summary 00:03:46
  15. Conclusion
    1. Course Wrap Up 00:01:08
  16. Credits
    1. About the Author 00:00:47