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");
  $sql1 = "SELECT  FROM_UNIXTIME(dia_hora, '%Y-%m-%d %H:%i') AS dia, dia_hora, temperatura, umidade FROM leitura 
    WHERE temperatura between '-20' and '-2' and id_veic='18'
    ORDER BY id";
    //WHERE temperatura between '2' and '8' 
  $query1 = mysqli_query($conn, $sql1);
  $z=0;
  while($row = $query1->fetch_assoc()) { 
    if($z>10000){exit('FIM<br>');}
    $dia_hora = $row['dia_hora'];
    $dia      = $row['dia'];
    $temp     = $row['temperatura'];
    $umid     = $row['umidade'];
    $sql2 = "INSERT INTO avulsa (dia_hora, temperatura, umidade) VALUES (".$dia_hora.", ".$temp.", ".$umid.")";
    if (!mysqli_query($conn, $sql2)) { 
      echo "Error: " . $sql2 . "<br>" . mysqli_error($conn);
    }else{
      echo 'Nº: '.$z.'-->Dia: '.$dia.' --> GRAVADO<br>';  $z++;      
    }
  }
  echo 'FIM<br>';
?>