[FX.php List] 5 minute timeout?

David Ness dness at bondedbuilders.com
Tue Aug 29 09:12:15 MDT 2006


My fx.PHP solution has a feature where the user can 'batch upload' data
to a FileMaker table using a properly formatted csv file. I've got
everything working great, except I can't get the page to stop timing out
after 5 minutes. I get about 320 records posted (of a test set of 1000),
then the script stops, throwing the following error to the php error
log:

[29-Aug-2006 10:53:48] PHP Warning:  fsockopen() [<a
href='function.fsockopen'>function.fsockopen</a>]: unable to connect to
10.10.10.4:80 (A connection attempt failed because the connected party
did not properly respond after a period of time, or established
connection failed because connected host has failed to respond.

10.10.10.4 being my FM WPE.

The basic structure of the php code is:

$handle = fopen("uploadedfilename.csv", "r");
while (($importdata = fgetcsv($handle, 0, ",")) != FALSE) {
	set_time_limit( 50000 );
	$newApplication->AddDBParam('builder_reference_number',
$importdata[0]  );
	$newApplication->AddDBParam('builder_number', $importdata[1] );
	$newApplication->AddDBParam('homeowner_firstname',
$importdata[2]  );
	$newApplication->AddDBParam('homeowner_lastname', $importdata[3]
);
	$newApplicationResult = $newApplication->FMNew();
} // end of while
fclose($handle);


As you can see, I've tried playing around with the usual subjects;
max_execution_time, max_input_time, and set_time_limit.

My ini info is located at:
http://www.bondedbuilders.com/builderportal_development/phpinfo.php


I use a MS IIS v6 server, and don't see any options there (though I'm
not ruling out the solution being there), and I also wondered if the
solution lies in placing some statement in the HTML HEADER of the page,
which I haven't found.

If you know of any potential solutions to this timeout problem, please
offer them up!

Thanks!

--
David Ness,
Database Systems Programmer
 
Bonded Builders Warranty Group
1500 Kings Highway
Port Charlotte, FL 33980
800.749.0381 x3123 (National Toll Free)
941.255.3274 x3123 (Local)


More information about the FX.php_List mailing list