Jump to content

execute block my php script


tatoosa
 Share

This topic is 2271 days old. Please don't post here. Open a new topic instead.

Recommended Posts

hello,

i'm a beginner, i have problem with a php script, i run it (1/2  minutes), reaches the command execute() and then it stop with no error message.

this is the script:

 

$fm_a = new FileMaker($file, $host, $username, $password);
$a_table = $fm_a ->newFindCommand('layout_name');

$a_table->addFindCriterion('online', '1');
$a_result = $a_table->execute();
if (FileMaker::isError($iconografia_result)) {

.......

where i'm a wrong? 

thanx for your time and collaboration

Simone

 

Link to comment
Share on other sites

How do you know that the script reaches execute()?

I would have to do a print_r( $a_result ); on a new line immediately after the line that ends with execute();

  • Like 1
Link to comment
Share on other sites

To check that you have connection just paste this in your browser: http://<<username>>:<<password>>@<<IP-address-of-your WPE>>/fmi/xml/FMPXMLRESULT.xml?-dbnames

Example:  http://wpeuser:[email protected]/fmi/xml/FMPXMLRESULT.xml?-dbnames

Edited by ggt667
Link to comment
Share on other sites

This XML file does not appear to have any style information associated with it. The document tree is shown below.
<FMPXMLRESULT xmlns="http://www.filemaker.com/fmpxmlresult">
<ERRORCODE>4</ERRORCODE>
<PRODUCT BUILD="11/02/2015" NAME="FileMaker Web Publishing Engine" VERSION="14.0.4.412"/>
<DATABASE DATEFORMAT="" LAYOUT="" NAME="" RECORDS="" TIMEFORMAT=""/>
<METADATA/>
<RESULTSET FOUND=""/>
</FMPXMLRESULT>
 
 
 
Quote

 

Link to comment
Share on other sites

WPE is on, as you receive a message like this ERRORCODE 4 is returned.

Which URL did you use?

Edited by ggt667
Link to comment
Share on other sites

http://wpeuser:[email protected]/fmi/xml/FMPXMLRESULT.xml?-dbnames

with the correct data

sorry the upper case

This XML file does not appear to have any style information associated with it. The document tree is shown below.
<fmresultset xmlns="http://www.filemaker.com/xml/fmresultset" version="1.0">
<error code="954"/>
<product build="11/02/2015" name="FileMaker Web Publishing Engine" version="14.0.4.412"/>
<datasource database="" date-format="" layout="" table="" time-format="" timestamp-format="" total-count=""/>
<metadata/>
<resultset count="" fetch-size=""/>
</fmresultset>
Link to comment
Share on other sites

The one above from: https://fmhelp.filemaker.com/docs/14/en/fms14_cwp_guide.pdf page 46

You can also try this one: http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-layoutnames remember to change to a database you know is there.

Did you create a new account, for example web with a custom privilege set that has the checkbox fmxml and/or fmphp checked?

Edited by ggt667
Link to comment
Share on other sites

6 hours ago, tatoosa said:

now it works... but i think that fm goes in timeout..... can you advise a config for the fm .... i export about 20000 records with 40 field each

Each month? pr minute?

 

Make sure you create a new layout with only the fields you need for that one query: make sure you have no calculation or summary fields on the query layout.

Edited by ggt667
Link to comment
Share on other sites

Narrowing down the amount of data you work with is always good; but the part you are writing about is in the query, not in the layout.

Link to comment
Share on other sites

This topic is 2271 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.