[FX.php List] 5 minute timeout?

[Dale Bengston]

Hi David,

Try using set_time_limit at the top of the html page being loaded  
instead of within the while loop. I think it's designed to work per- 
script, not per-iteration of a loop.

Regards,
Dale

On Aug 29, 2006, at 10:12 AM, David Ness wrote:

> 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)
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list