Chapter 23Wildcards

Wildcards are very useful sequences of characters that can be used to perform partial matching within database searches. FileMaker includes a few very useful wildcards to match characters, numbers, and even date ranges. However, wildcards present a huge security risk when using user-entered data to find a record, and thus this chapter will explain how to protect your scripts from wildcard-based attacks.

What Wildcards Are Available?

Figure 23-1 is a screenshot from the FileMaker Pro find screen showing the wildcards that are available to you through both PHP and FileMaker Pro.

The most dangerous wildcards to security are the “@” and “*” symbols, which allow guessing within search strings to access records that do not belong ...

Get FileMaker Web Publishing: A Complete Guide to Using the API for PHP now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.