While loop to check if file has been created

[eraserhead99]

I am working on a script that calls some SP's on a Microsoft SQL server. The procedures are running fine, but what I'm trying to do is have a while loop run while the procedure is generating the file (pdf report). Then when that file exists it should go to the next in the foreach loop. For some reason when I run it with test files it works fine, but when I do it with the actual stored procedures the first file is generated and my script moves on to the second, which is also generated by the Microsoft stored procedure, but the PHP script never recognizes that the file is on the server (which I see as being generated) and the script never moves on from the second file. Could this have anything to do with max_execution_time?

$db->select(payroll);
$locations = $db_ms->get_results("SELECT location_code FROM tblloc");
foreach ($locations as $val) {
	$location = trim($val->location_code);
	$path = '\\\tc-fp1\reports$\##LOCATION##\Payroll\\';
	$linuxpath = '/var/www/html/system/intranet/reports/##LOCATION##/payroll/';
	$cats = array('labordistpath' => array('name' => 'LaborDist.pdf','id' => '1021'),
			'masterctlpath' => array('name' => 'MasterCtl.pdf','id' => '1023'),
			'payregisterpath' => array('name' => 'PayRegister.pdf','id' => '1025'));
	$db_ms->query("update dbopt set opt_value = '$location' where id = 'Location'");
	foreach ($cats as $subkey => $subval) {
		$fullpath = str_replace('##LOCATION##',$location,$path) . $subval['name'];
		$fulllinuxpath = str_replace('##LOCATION##',$location,$linuxpath) . $subval['name'];
		$db_ms->query("update dbopt set opt_value = '$fullpath' where id = '$subkey'");
		$db_ms->query("exec PDS_ES_SchedJob 0,'','PDSADMIN',null,'A','PRGM_ID=" . $subval['id'] . "'");
		echo $location . " -- " . $subval['name'] . " Is being generated";flush();
		while (filesize($fulllinuxpath) < 1) {
			echo '.';flush();sleep(5);
		}
		echo " DONE!<BR>";flush(); 
	}
}

[HP400]

You can set an infinite time limit with

set_time_limit(0);

and loop while (!file_exists($filename))

[eraserhead99]

The reason I don't use

and loop while (!file_exists($filename))

is because the server generates the file with a size of 0kb and then builds it, sometimes it can take over 5 minutes for the actual file to be finished. So there are three file options:

1. No file at all
2. File exists with a size of 0kb
3. File exists with the full file size

That's why I use the file size way of checking.

It appears this has everything to do with the time limit issue. When I add set_time_limit(0); the script never finishes the first run through. If I change it to something like set_time_limit(10) the first one again finishes (very small report) and then it still never recognizes that the second file is done, even though it does get generated after about 2 minutes.

[HP400]

What are the conditions for when the script will end? If it keeps looping then the script will never finish.

[eraserhead99]

It loops through each facility and inside each facility it loops through 3 reports, so when all facilities have run the script finishes. I have changed it for now to just check if the file exists and it's running through as designed, but like I said, it generates a 0kb file when the report is created but that doesn't mean that the report is actually done, some reports take up to 5 minutes to complete.