$sqlBusca .= ") AND ";
    }
    $sqlBusca = substr($sqlBusca, 0, -5);
    $sqlBusca .= ") AND ";
}
$sqlBusca .= "`VISIVEL` = 1 ORDER BY ";
if (isset($_GET['lat']) && isset($_GET['lon'])) {
    $sqlBusca .= "DISTANCIA, ";
}
$sqlBusca .= "m.nome, t.razao_social ";
if (isset($_GET['lat']) && isset($_GET['lon'])) {
    $sqlBusca .= "LIMIT 0, {$ntelec}";
}
$resBusca = query($sqlBusca);
header("Content-Type: text/x-csv; charset=UTF-8;");
header("Content-Disposition: attachment; filename=\"dados.csv\";");
$CsvBody = '"Razão social";"UF";"Município";"Endereço";"Licença";"Canal";"Frequência";"Indicador";"Latitude";"Longitude"' . "\r\n";
while ($telec = mysql_fetch_array($resBusca)) {
    $CsvBody .= '"' . limpaString($telec['razao_social']) . '";';
    $CsvBody .= '"' . (isset($telec['uf']) ? limpaString($telec['uf']) : '') . '";';
    $CsvBody .= '"' . (isset($telec['municipio']) ? limpaString($telec['municipio']) : '') . '";';
    $CsvBody .= '"' . (isset($telec['endereco']) ? limpaString($telec['endereco']) : '') . '";';
    $CsvBody .= '"' . imprimeLicenca($telec['licenca']) . '";';
    $CsvBody .= '"' . (isset($telec['canal']) ? $telec['canal'] : '') . '";';
    $CsvBody .= '"' . (isset($telec['frequencia']) ? $telec['frequencia'] : '') . '";';
    $CsvBody .= '"' . (isset($telec['indicador']) ? $telec['indicador'] : '') . '";';
    $CsvBody .= '"' . (isset($telec['latitude']) ? $telec['latitude'] : '') . '";';
    $CsvBody .= '"' . (isset($telec['longitude']) ? $telec['longitude'] : '') . '";';
    $CsvBody .= "\r\n";
}
echo $CsvBody;
示例#2
0
     $CsvBody .= limpaString($telec['endereco']) . "<br>";
 }
 if (isset($telec['municipio']) && isset($telec['uf'])) {
     $CsvBody .= limpaString($telec['municipio']) . ' - ' . $telec['uf'] . "<br>";
 } else {
     if (isset($telec['municipio'])) {
         $CsvBody .= limpaString($telec['municipio']) . "<br>";
     } else {
         if (isset($telec['uf'])) {
             $CsvBody .= limpaString($telec['uf']) . "<br>";
         }
     }
 }
 $CsvBody .= isset($telec['CEP']) ? $telec['CEP'] : '';
 $CsvBody .= "</td></tr>\r";
 $CsvBody .= '<tr><td class="nome">Licen&ccedil;a:</td><td class="valor">' . imprimeLicenca($telec['licenca']) . "</td></tr>\r";
 if (isset($telec['canal'])) {
     $CsvBody .= '<tr><td class="nome">Canal:</td><td class="valor">' . limpaString($telec['canal']) . "</td></tr>\r";
 }
 if (isset($telec['frequencia'])) {
     $CsvBody .= '<tr><td class="nome">Frequ&ecirc;ncia:</td><td class="valor">' . limpaString($telec['frequencia']) . "</td></tr>\r";
 }
 if (isset($telec['indicador'])) {
     $CsvBody .= '<tr><td class="nome">Indicador:</td><td class="valor">' . limpaString($telec['indicador']) . "</td></tr>\r";
 }
 if (isset($telec['latitude'])) {
     $CsvBody .= '<tr><td class="nome">Latitude:</td><td class="valor">' . $telec['latitude'] . "</td></tr>\r";
 }
 if (isset($telec['longitude'])) {
     $CsvBody .= '<tr><td class="nome">Longitude:</td><td class="valor">' . $telec['longitude'] . "</td></tr>\r";
 }