Fatal error: Script timing out after 60 seconds.

[vaibhavkansara]

$ffile=file(".\\110607csv.csv");
$ffopen = fopen (".\\110607csv.csv","r");
echo count($ffile)."<br>\n";
 
while ($data = fgetcsv ($ffopen,1000,",")) 
{
   for($i=0; $i<sizeof($ffile); $i++) 
{ echo $i."<br>\n";
      $line = trim($ffile[$i]); 
      $arr = explode(",", $line); 
//echo $line;
//$sql = "insert into ats values ('".implode("','", $arr) ."')";
$sql = "insert into ats (no,empno,emp_name,shift,arrvl,out1,in2,out2,in3,out3,late,early,wrkhr,exthr,prs,remarks)
    values('$arr[0]','$arr[1]','$arr[2]','$arr[3]','$arr[4]','$arr[5]','$arr[6]','$arr[7]','$arr[8]','$arr[9]','$arr[10]','$arr[11]','$arr[12]','$arr[13]','$arr[14]','$arr[15]')";
 
$result = mysql_query($sql) or die("Invalid query: " .mysql_error());
}}

[Please use CODE tags when posting source code. Thanks! --pbmods]

it gives the error like

Fatal error: Maximum execution time of 60 seconds exceeded in C:\Program Files\typo3\htdocs\attendence\connection.php on line 86

so please give me urgent response
thanks in advance

[pbmods]

Changed thread title to better describe the problem.

Heya, vaibhavkansara.

Have you tried MySQL's LOAD DATA INFILE command?