FM API for PHP Standalone help

[Daniel Shanahan]

For brevity's sake I will write what is working and what is not:

File is hosted locally

Working:

Viewing db from my localhost (http://localhost/~User/Database).

FM_API_for_PHP_Standalone is NOT in the db folder.

Not Working:

1. Viewing db from MAMP, regardless if FM_API_for_PHP_Standalone is in the db folder or not.

2. Viewing db from my web server (shared hosting). FM_API_for_PHP_Standalone is in the db folder.

File is hosted remotely

Not Working:

1. Viewing db from my localhost, regardless if FM_API_for_PHP_Standalone is in the db folder or not.

2. Viewing db from MAMP, regardless if FM_API_for_PHP_Standalone is in the db folder or not.

3. Viewing db from my web server (http://www.mysite.com/Database). FM_API_for_PHP_Standalone is in the db folder.

I have included a text file with the various PHP error messages.

It seems to me that this is an issue with my placement of FM_API_for_PHP_Standalone, for when I host the db on a local server and use my localhost as a web server, then FMP can find the PHP files in my Library/FileMaker Server/Web Publishing directory. I thought I just needed to place the FM_API_for_PHP_Standalone in with the .php files, but that does not seem to work.

By the way, the web files were created with the PHP Site Assistant.

Can anyone shed any light on why this is not working properly? I would like to use the db that is hosted remotely and serve it on a shared hosting web server.

Thanks.

FMP_PHP_errors.txt

[Daniel Shanahan]

I've discovered several things. Succinctly:

1. In the file FM_API_for_PHP_Standalone, remove the folder "FileMaker" and the document "FileMaker.php" and put these two items in the root directory. For example, say I have a Widgets database called "Widgets" and I create files using PHP Site Assistant. I put all of those files in a folder called "Widgets" and I put that folder in MAMP (or WAMP or, eventually, a live hosting environment). Then, place the two items - "FileMaker" (the folder) and "FileMaker.php" (the document) - in the "Widgets" folder.

2. Many of the files created by PHP Site Assistant begin with HTML ("DOCTYPE HTML PUBLIC..."). This causes an output buffering error. (see http://fmwebschool.com/frm/index.php?topic=2697.0)

Either move that HTML line below the php code OR incorporate output buffering functions (ob_start() and ob_end_flush()/ ob_end_clean() ).

3. After I did numbers one and two above I received a new error - "Warning: require_once(Date.php)". I am not sure where this file is or where it is supposed to be. I simply commented it out (it is in the fmview.php file) and then everything worked properly.

Does anyone know where the Date.php file is or where it is supposed to be?

Thanks,

daniel