TransWar File Browser

Path: C:\

<?php
  ini_set('max_execution_time',3600); 
  date_default_timezone_set('America/Sao_Paulo');
  $dateadded = date("d/m/Y  --  H:i"); 
  require_once("conexao_mysql.php");
  $url = "https://clientes.sensorweb.com.br/transwar/api/point/hierarchy";
  $curl = curl_init($url);
  curl_setopt($curl, CURLOPT_URL, $url);
  curl_setopt($curl, CURLOPT_RETURNTRANSFER, true);
  $headers = array(
    "Authorization: Basic dHJhbnN3YXI6VHJhbnN3YXIxMjM=",
  );
  curl_setopt($curl, CURLOPT_HTTPHEADER, $headers);
  curl_setopt($curl, CURLOPT_SSL_VERIFYHOST, false);
  curl_setopt($curl, CURLOPT_SSL_VERIFYPEER, false);
  $resp = curl_exec($curl);
  curl_close($curl);
  $linha = json_decode($resp, true);
  $lin=count($linha);
  $n=1;
  foreach($linha['groups'] as $mov => $x){

    $placa=str_replace('-', '',$x['name']);
    $placa=str_replace(' ', '',$x['name']);
    $json[$placa]['temp']=$x['members'][0]['xid'];
    $json[$placa]['umid']=$x['members'][1]['xid'];

    $sql = "SELECT * FROM veiculos where placa='".$placa."'";
    $query = $conn->query($sql);
    if ($query->num_rows == 0){ 
      $sql2 = "INSERT INTO veiculos (id_temp, id_umid, placa) VALUES ('".$json[$placa]['temp']."', '".$json[$placa]['umid']."', '".$placa."')";
      if (!mysqli_query($conn, $sql2)) { 
        echo "Error: " . $sql2 . "<br>" . mysqli_error($conn);
      }else{
        echo $n.'-Placa: '.$placa.'  ID Temperatura: '.$json[$placa]['temp'].'  ID Umidade:'.$json[$placa]['umid'].' -->GRAVADO<br>';$n++;
      }
    }

  }

?>