FX.php script to test connection

[Misty]

Can someone give me a basic script to test the FM connection. I've tried an fx script and a filemaker.php script, and can't tell by the errors if it's connecting or not. Here are the two files I've tried:

<?php

error_reporting (E_ALL);

define('DEBUG', true);

require_once('FX.php');

require_once('FMErrors.php');

define('FM_IP', 'xxx.xxx.x.xxx');

define('FM_PORT', '80');

define('FM_VERSION', 'FMPro7');

define('FM_USERNAME', 'xxx');

define('FM_PASSWORD', 'xxx');

$returnCount=200;

$instanceName=new FX(FM_IP, FM_PORT, FM_VERSION);

$instanceName->SetDBData('Web_Forms', 'Orders_ListView', $returnCount);

$instanceName->SetDBUserPass(FM_USERNAME, FM_PASSWORD);

$instanceName->AddDBParam('Order_Number', "TSR179412");

$Result=$instanceName->FMFind();

echo $Result."<br>";

echo "Hello Trish 1";

The page I get has this:

Accessing FileMaker Server 7+ data.

Using FileMaker URL: http://web:[email protected]&-find

Catchable fatal error: Object of class FX_Error could not be converted to string in E:InetpubwwwrootFormsBuildings.php on line 24

Clicking on the link takes me nowhere, so I’m not sure if it’s getting connected or not.

The second script I tried was with filemaker.php:

<?php

require_once ('FileMaker.php');

$fm = new FileMaker();

$fm->setProperty('database', 'WEB_Forms');

$fm->setProperty('hostspec', 'http://xxx.xxx.x.xxx/');

$fm->setProperty('username', 'xxxxxxx');

$fm->setProperty('password', 'xxxxxxx');

$connected = $fm->listLayouts();

If(FileMaker::isError($connected)){

echo "not connected";

} else {

echo 'connected';

}

?>

and get this response:

Warning: require_once(C:Program FilesFileMakerFileMaker ServerWeb Publishingpublishing-enginephpincludesImplementationParser/../../Layout.php) [function.require-once]: failed to open stream: No such file or directory in C:Program FilesFileMakerFileMaker ServerWeb Publishingpublishing-enginephpincludesImplementationParserFMResultSet.php on line 2

Fatal error: require_once() [function.require]: Failed opening required 'C:Program FilesFileMakerFileMaker ServerWeb Publishingpublishing-enginephpincludesImplementationParser/../../Layout.php' (include_path='.;C:Program FilesFileMakerFileMaker ServerWeb Publishingpublishing-enginephpincludes;E:InetpubwwwrootFormsFX;E:InetpubwwwrootFormsFileMaker;E:InetpubwwwrootFormsFileMakerImplementation') in C:Program FilesFileMakerFileMaker ServerWeb Publishingpublishing-enginephpincludesImplementationParserFMResultSet.php on line 2

13 minutes ago · Like

[doughemi]

The error occurred before the php script connected to your database. In your Filemaker.php script, it appears that you do not have the correct path to FileMaker,php in your require_once() statement. There should be a FileMaker directory at the same level as FileMaker.php which contains a number of other required files which FileMaker.php is expecting to find. These would both have to be in the same directory as yourscript.php (because of your require_once path). That directory will have to be in the correct directory on the server, most likely E:Inetpubwwwroot.

I am not familiar with FX.php, so I can't help on that side.

[Misty]

Finally fixed! I uninstalled FMS, rebooted and reinstalled FMS back onto the E: drive ... reset my IIS, and voila! All is tested and working as intended!