fnPHPExecute ( php_code ; php_filepath_local )

Execute PHP code locally. Simple but powerful.

Average rating: 5.0 (1 vote) Log in to vote

Drew Wesley - Show more from this author
Drewsol
https://www.drewsol.com

Sample input:

Windows: fnPHPExecute ( "$date = date('Y-m-d H:i:s'); echo $date" ; "C:\PHP" )
macOS: fnPHPExecute ( "$date = date('Y-m-d H:i:s'); echo $date" ; "" )

Sample output:

2021-12-28 17:34:30

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

/**
 * ==================================================================
 *  fnPHPExecute ( php_code )
 *  Drewsol
 *
 *  PARAMETERS:
 *      php_code (text): The PHP code.
 *      php_filepath_local (text): Filepath to local php.exe file.
 *  RETURNS:
 *      echoed result
 *  DEPENDENCIES:
 *      php.exe (NTS preferred) and php5.dll, php7.dll, or php8.dll (depending on version) in local directory
 *      BaseElements Plugin: BE_ExecuteSystemCommand
 *  PURPOSE:
 *      Execute PHP code locally. Simple but powerful.
 *  NOTES:
 *      PHP code must use 'echo', not 'return'.
 *      Runs 'synchronously' in-function or script.
 *      Commenting format here: https://filemakerstandards.org/display/cs/Commenting
 *      PHP is/was included in Mac OS X 10.0 (Cheetah) but removed in macOS 12.0 (Monterey)..
 *        ..Would need to be installed on Mac by other means (ie. Homebrew).
 *  REVISIONS:
 *      12/28/2021 - Support for macOS with PHP installation, or Windows PATH environmental variable.
 *      12/28/2021 - Initial release.
 * ==================================================================
 */

Let ( [

  php_code_block =
  // For illustration purposes..
  // <?php

php_code ;

  // ?>

  // Provision for macOS with PHP installation or Windows PATH environmental variable.
  php_filepath_local =
  Case (
    Get ( SystemPlatform ) = 1 or php_filepath_local = "" ;
    "php" ;
    php_filepath_local
  ) ;

  cmd = php_filepath_local & " -r " & "\"" & php_code_block & "\"" & ";"

  ] ;

  BE_ExecuteSystemCommand ( cmd )

) // end Let

Execute PHP code locally. Simple but powerful.
See commenting for more.

Comments

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

fnPHPExecute ( php_code ; php_filepath_local )

Comments

Support this website.

Support this website.