PHP and relationships with separate files

[KellyMc]

Hi,

I'm building an application that receives user-submitted data from a php form, then emails a receipt to the user and a report to an address outside the organization. The emails get sent by a script called from php on the form's submit page.

For one of the emails, some content and the recipient's address are stored in a related table in a separate file. Both the application doing the emailing and the separate file with the addresses are on Filemaker Server 11 and both are enabled for php via the guest account.

The problem is that any data, including the recipient address, that lives in the related file does not seem to show up when the script is called via php. It works fine when I run the script from the client. As a result, these emails won't go out because they have no address to go to.

It seems like maybe the relationship between the original file and the related file doesn't work in PHP. Does anyone have any experience with this sort of thing or any ideas?

Thanks!

Kelly

[TAiS46]

Hello,

I have the same problem, dose someone have a solution?

I have try a lot of ways, setting up an layout with the field from the extern database

but it won't work!

I hope someone can help us?

Thanks

[doughemi]

Does the external file have a valid account and proper access privileges for the account name used by the PHP API?

[TAiS46]

Yes, but I think there is a Problem:

$obj = new FileMaker($database, $hostname, $username, $password);



$script_object = $obj->newPerformScriptCommand($config->layout_order_item, "test", $pos["articleordernumber"]);

$script_result = $script_object->execute();

with new Filemaker() I will only get acces to the $database I choose, but not to the other "relation" database.

We must find a way to login into the other database without loosing the connection to the first, am I right?

[TAiS46]

Ok, I have solve the problem.

I will try to describe it with my bad english

I have 3 Databases ...

What I have not observed is, that I have in Database 2 an relation to Database 3!

I have give Database 3 not the correct rights!

[webko]

Real question: Why would you use separate files these days? You can have an effectively unlimited number of tables in any given file anyway, so why confuse the issue?