PHP Functions
Smartpill includes a PHP extension that adds powerful FileMaker related functions to PHP.
These are actual PHP functions that can be used in your PHP code.
With these functions you can:
- Return the results of any FileMaker calculation (a great way to get data from FileMaker from within your PHP code).
- Execute SQL against your FileMaker data (includes the ability to select, insert, update and delete data in FileMaker).
- Define variables (available at the application level – not restricted to the file level like FileMaker global variables).
- Have the user select a file or folder and return the selected path.
- Display progress bars.
- Trigger scripts.
- Define your own errors.
- Get parameters passed to your PHPx functions.
- Return typed results to FileMaker.
- fm_evaluate
- fm_set_variable
- fm_get_variable
- fm_get_defined_variables
- fm_isset
- fm_unset
- fm_set_error
- fm_get_last_error
- fm_perform_script
- fm_script_control
- fm_save_file
- fm_select_file
- fm_select_folder
- fm_new_progress_bar
- fm_update_progress_bar
- fm_close_progress_bar
- fm_progress_bar_control
- fm_progress_bar_position
- fm_progress_bar_timeout
- fm_progress_bar_title
- fm_user_cancelled
- fm_sql_select
- fm_sql_select_ex
- fm_sql_execute
- fm_sql_execute_on_idle
- fm_sql_get_query_status
- fm_get_parameter
- fm_get_all_parameters
- fm_set_container_file_name
- fm_set_result