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);$reg=array();
for($i=0;$i<$n;$i++){
if($data[$i][2]!=='-' and $data[$i][3]!=='-'){
if (isset($id[$data[$i][0]])){$id_veic=$id[$data[$i][0]];}else{$id_veic='Não Encontrado';}
$reg[$data[$i][0]]=$id_veic;
}
}
echo '<pre>';
print_r($reg);
echo 'FIM<br>';
exit();
?>