Scodigo, Inc.

With SmartPill PHP Edition™ you have all the power of PHP at your fingertips right inside your FileMaker® applications. Here are just a few of the things you can do:

Endless Possibilities

• Send and receive email
• Send and receive files using FTP
• Get URLs (including SSL support)
• Read and write to Active or Open Directory with LDAP functions
• Communicate with web services
• Encrypt and decrypt your data
• Execute shell commands and return the results
• XML, XSL and XPath functions
• Read and write to files on disk
• Connect to MySQL databases
• Utilize the power of regular expressions
• Access an extensive set of string functions
• Read and write zip files
• Create and manipulate images
• Read EXIF data from image files

Watch a video to see how it works!

Watch the video with Matt Petrowsky of FileMaker Magazine.

New In Version 1.5

• Container fields can now be set directly using the new PHP_Execute_To_Container function. Now you can use PHP functions to retrieve (or even create) images, documents and other files and store them directly in the database. Most file types are supported and preview images are generated for the following graphic files: bmp, gif, giff, jpg, jpeg, pct, pdf, png, psd, tif, tiff.
• The Windows version is now distributed as a single “.fmx” plug-in file. This greatly simplifies installation on the Windows platform and will now work with the FileMaker auto-update function for plug-in installation and update on client machines.
• The MySQL extension is now compiled into the Windows version and the PostgreSQL and Microsoft SQL (MSSQL) extensions are now compiled in for both Mac and Windows versions. The PDO extension is also now included.
• New fm_sql_select and fm_sql_execute functions allow you to perform SQL queries internally without the need for ODBC drivers or any type of configuration. Now you can easily access the power and flexibility of SQL.
• New variable functions allow you to manage variables that are stored globally at the application level which means they can be accessed from any file.
• New fm_script_control function allows script triggering to be turned on and off. This is very helpful for situations when you don’t want script triggering to occur.
• New fm_get_last_error function allows you to check for errors returned by other “fm” functions that are included in the PHP extension.
• New fm_set_error function allows you to return user-defined errors from within your PHP code. Errors set with this function can be read with using the PHP_GetLastError function.
• The PHP_GetLastError function now includes an optional selector parameter allowing you to specify the return of just the error number or just the error description.
• The calendar and wddx extensions, which were previously only available in the Windows version, are now compiled in for the Mac versions.
• Now includes PHP version 5.2.4.