I have created a script that load and parses a txt file. The script works fine if run it from the local computer/server, but if i run the script for client machine the browser hangs.
Code: Select all
<?php
include 'connect.php';
if ($_FILES["file"]["error"] > 0)
{
echo "Error: " . $_FILES["file"]["error"] . "<br />";
}
elseif($_FILES["file"]["name"]=="DATATOGO.txt" or $_FILES["file"]["name"]=="DATATOGO.TXT")
{
echo 'Lanco Lab File';
$fileopen = $_FILES["file"]["tmp_name"];
$row = 1;
if (($handle = fopen($fileopen, "r")) !== FALSE)
{
$row++;
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
$num = count($data);
$row++;
//sorts Dates into YYYY/MM/DD
$new_dateorig2 = date("Y-m-d", strtotime($data[2] ));
$new_dateorig3 = date("Y-m-d", strtotime($data[3] ));
//changes Co-Op number in CSV to proper number
if($data[13]==1)
{
$data[13]=100000;
$sql="SELECT * FROM lanco_lab_quality_orig WHERE farm_id='$data[0]' AND pu_date='$new_dateorig2' AND tank_number='$data[1]' AND source='$data[17]'";
$result=mysql_query($sql);
$count=mysql_num_rows($result);
if($count>=1)
{
$sql="UPDATE lanco_lab_quality_orig SET farm_id='$data[0]', tank_number='$data[1]', pu_date='$new_dateorig2', plate_date='$new_dateorig3', butterfat='$data[4]', protein='$data[5]', other_solids='$data[6]', scc='$data[7]', antibiotic='$data[8]', cryo='$data[9]', pi='$data[10]', temp='$data[11]', spc='$data[12]', coop_num='$data[13]', start_date='$data[14]', plate_loop='$data[15]', mun='$data[16]', status='new', source='$data[17]' WHERE farm_id='$data[0]' AND pu_date='$new_dateorig2' AND tank_number='$data[1]' AND source='$data[17]'; UPDATE lanco_lab_quality SET farm_id='$data[0]', tank_number='$data[1]', pu_date='$new_dateorig2', plate_date='$new_dateorig3', butterfat='$data[4]', protein='$data[5]', other_solids='$data[6]', scc='$data[7]', antibiotic='$data[8]', cryo='$data[9]', pi='$data[10]', temp='$data[11]', spc='$data[12]', coop_num='$data[13]', start_date='$data[14]', plate_loop='$data[15]', mun='$data[16]', status='new', source='$data[17]' WHERE farm_id='$data[0]' AND pu_date='$new_dateorig2' AND tank_number='$data[1]' AND source='$data[17]';";
}
elseif($count==0)
{
$sql="INSERT into lanco_lab_quality_orig (farm_id, tank_number, pu_date, plate_date, butterfat, protein, other_solids, scc, antibiotic, cryo, pi, temp, spc, coop_num, start_date, plate_loop, mun, status, source) values('$data[0]','$data[1]','$new_dateorig2','$new_dateorig3','$data[4]','$data[5]','$data[6]','$data[7]','$data[8]','$data[9]','$data[10]','$data[11]','$data[12]','$data[13]','$data[14]','$data[15]','$data[16]', 'new', '$data[17]'); INSERT into lanco_lab_quality (farm_id, tank_number, pu_date, plate_date, butterfat, protein, other_solids, scc, antibiotic, cryo, pi, temp, spc, coop_num, start_date, plate_loop, mun, status, source) values('$data[0]','$data[1]','$new_dateorig2','$new_dateorig3','$data[4]','$data[5]','$data[6]','$data[7]','$data[8]','$data[9]','$data[10]','$data[11]','$data[12]','$data[13]','$data[14]','$data[15]','$data[16]', 'new', '$data[17]');";
}
else
{
echo $count;
}
$queries = preg_split("/;+(?=([^'|^\\\']*['|\\\'][^'|^\\\']*['|\\\'])*[^'|^\\\']*[^'|^\\\']$)/", $sql);
foreach ($queries as $query){
if (strlen(trim($query)) > 0) mysql_query($query);
}
}
}
}
}
elseif($_FILES["file"]["name"]=="DATATOGOPIONLY.txt" or $_FILES["file"]["name"]=="DATATOGOPIONLY.TXT")
{
echo 'lanco PI File';
$fileopen = $_FILES["file"]["tmp_name"];
$row = 1;
if (($handle = fopen($fileopen, "r")) !== FALSE)
{
$row++;
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
$num = count($data);
$row++;
//sorts Dates into YYYY/MM/DD
$new_dateorig2 = date("Y-m-d", strtotime($data[2] ));
$sql="SELECT * FROM lanco_lab_quality WHERE farm_id='$data[0]' AND pu_date='$new_dateorig2' AND tank_number='$data[1]' AND source='$data[4]'";
$result=mysql_query($sql);
$count=mysql_num_rows($result);
if($count>=1)
{
$import="UPDATE lanco_lab_quality SET pi='$data[3]', status='new' WHERE farm_id='$data[0]' AND pu_date='$new_dateorig2' AND tank_number='$data[1]' AND source='$data[4]'";
$import1="UPDATE lanco_lab_quality_orig SET pi='$data[3]', status='new' WHERE farm_id='$data[0]' AND pu_date='$new_dateorig2' AND tank_number='$data[1]' AND source='$data[4]'";
}
elseif($count==0)
{
$import="INSERT into lanco_lab_quality (pi) values('$data[3]')";
$import1="INSERT into lanco_lab_quality_orig (pi) values('$data[3]')";
}
else{echo $count;}
mysql_query($import) or die(mysql_error());
mysql_query($import1) or die(mysql_error());
}
}
}
elseif($_FILES["file"]["name"]=="DATATOGOMUNtxt" or $_FILES["file"]["name"]=="DATATOGOMUN.TXT")
{
echo 'lanco MUN File';
}
else
{
echo 'This is not a lanco File.';
}
?>