ErichWetzel

Does anyone know how to point a PHP custom web publishing page from a standalone web server to the FMS13 database server? We are moving from FMSA11 to FMS13. In the past the Web Publishing Engine was on our standalone web server and the database machine was separate. In order to take advantage of the new features of 13 we put FMS13 as a single machine. Our testing database has FMS13 on a single machine installation. Our testing business web site is on a stand alone web server on the same subnet at the FMS13 machine. I need to know if anyone has experience with this type of setup. It seems to me that the standalone web site should be able to call the database server for data. But initial testing does not seem to permit that. I bet I am doing something wrong. Our web site PHP pages do not seem to be getting the FileMaker.php if i read the error below correctly. The same PHP pages seem to work when the WPE is on the Web site server like our current setup. Having the WPE on our web site machine is not possible if we want to use the new features of FMS since it needs to create its own web server. The PHP page has an include file defining the database that has been pointed to the IP of the FMS13 single machine, and by extension of course its WPE. Any ideas would be appreciated. Thanks. -Erich Error result below : Into errorHandler() at line 15 ---ERRNO--- 2 ---ERRSTR--- require_once(FileMaker.php): failed to open stream: No such file or directory ---ERRFILE--- /Volumes/Data/websitedata/inspiration.php ---ERRLINE--- 7 ---ERRCONTEXT--- Array ( [_GET] => Array ( ) [_POST] => Array ( ) [_COOKIE] => Array ( ) [_FILES] => Array ( ) ) Backtrace of errorHandler() Array ( [0] => Array ( [file] => /Volumes/Data/websitedata/inspiration.php [line] => 7 [function] => errorHandler [args] => Array ( [0] => 2 [1] => require_once(FileMaker.php): failed to open stream: No such file or directory [2] => /Volumes/Data/websitedata/inspiration.php [3] => 7 [4] => Array ( [_GET] => Array ( ) [_POST] => Array ( ) [_COOKIE] => Array ( ) [_FILES] => Array ( ) ) ) ) [1] => Array ( [file] => /Volumes/Data/websitedata/inspiration.php [line] => 7 [function] => require_once ) ) Fatal error: require_once(): Failed opening required 'FileMaker.php' (include_path='.:') in /Volumes/Data/websitedata/inspiration.phpon line 7

No problem. My fault. I left the VPN I was using open. This gave two routes to the same domain. Works great. Thanks for your help getting me into PHP with FileMaker. I'm trying to give a good rating to the responses in the topic. Clicking the link does nothing. What am I missing? Also do these forums allow a topic to be listed as solved?

This is strange. Half an hour later the result is returned with only a slight pause. The previous post may be irrelevant. I'll test again later to see if it keeps the current pace.

Got it. Thanks for helping me get started. I think that this will be my last startup question... I have set everything up for a simple test and have a problem with the execution speed. It is taking between 10 and 20 seconds to return the email address in the code below. Full test with a longer PHP page that tests the message contents and sends an email is essentially the same. That seems awful long to me. The FM Server and Web Server are on the same subnet and have very little traffic at any time. Any idea what would be going on here. I can't have users waiting for a result. With our XSLT pages, the result page time feels immediate and those have much more data in them. HTML page relevant code: PHP page entire code: <?php $comments = $_POST['message'] ; $infemail = $_POST['infemail'] ; $decname = $_POST['decfullname'] ; $recordid = $_POST['recordid']; require_once ('FileMaker.php'); $fm = new FileMaker('Active Accounts','192.168.1.2'); $record = $fm->getRecordById('web',$recordid); $mail = $record->getField('Web Inf email'); echo $mail; exit; ?>

Genx, Thank you. That looks like what I need. Good point about the authentication. Another point I thought of: My PHP script is currently in the site root folder. If I put the user and password into the PHP script I am currently using, and the result of the script is redirection to a static html page, is the FM user and password available from the web? I am gradually going to move our XSLT pages to PHP since it is easier for me. The FMS documentation suggests putting the details for the database connection in a different place than in the pages being accessed from the web. What would you suggest as the most secure standard procedure?

I am new to FileMaker via PHP so please be patient with me. We have a FileMaker XSLT page which shows data from a single record. I have used a form to post the recordID from the XSLT page to a PHP script. The PHP script sends an email and then redirects to a static page which indicates that the email message has been sent. In the PHP script I am trying to figure out how to use the recordID to call our FMSA 10 for the contents of the email field which will be used of course as the TO: address for the generated email. I see from the documentation that I will need to tell the PHP page how to contact the FMSA10 and then presumably actually call for the data. So for contact, complete as appropriate for our installation: $fm = new FileMaker(); $fm->setProperty('database', 'questionnaire'); $fm->setProperty('hostspec', 'http://192.168.100.110'); $fm->setProperty('username', 'web'); $fm->setProperty('password', 'web'); First question: For the server contact, can the username and password be blank? For the XSLT pages our accessible fields are all accessible to anyone since they are posted on the web and the XSLT pages did not require a login. Then: I plan to tell a variable to hold the email address, so I need help with: $mail = code to get field contents I will not need no result escaping since the script can only be called from the XSLT generated page if there is an address in the field. Second question: Assuming the database contact is setup correctly, how do I call for the content of a single field? Thanks for taking a look at this issue. -Erich Wetzel