TransWar File Browser

Path: C:\

<?php
ini_set('max_execution_time',259200); 
ini_set ('memory_limit','-1');
date_default_timezone_set('America/Sao_Paulo');
$dateadded = date("d/m/Y  --  H:i");
echo 'Iniciado em: '.$dateadded.'<br>';
require_once("conexao_mysql.php");
$sql = "SELECT * FROM veiculos order by id_veic";
$query = $conn->query($sql);
if ($query->num_rows > 0)
{ while($row = $query->fetch_assoc()) 
  { 
    $id[$row['placa']] = intval($row['id_veic']);
  }
}
function LoadData($file)
{   $lines = file($file);
    $data = array();
    foreach($lines as $line)
        $data[] = explode(';',trim($line));
    return $data;
}
$data = LoadData('arquivos/09e10-12 - Copia.csv');
$n=count($data);
for($i=0;$i<$n;$i++){
  if($data[$i][2]!=='-' and $data[$i][3]!=='-'){
    $id_veic=$id[$data[$i][0]];
    $dia_hora=strtotime($data[$i][1]);
    $temp=floatval($data[$i][2]); 
    $umid=floatval($data[$i][3]);
    echo $dia_hora.'<br>';
      $sql2 = "INSERT INTO leitura (id_veic, dia_hora, temperatura, umidade) VALUES (".$id_veic.", ".$dia_hora.", ".$temp.", ".$umid.")";
      if (!mysqli_query($conn, $sql2)) { 
        echo "Error: " . $sql2 . "<br>" . mysqli_error($conn);
      }else{
        echo 'ID: '.$id_veic.' em '.$data[$i][1].' --> GRAVADO<br>';        
      }
  }
}
echo 'FIM<br>';
exit();
?>