Le portail francophone de la géomatique

<?php

$conn = pg_pconnect ("host=localhost port=5432 dbname=ma_db user=postgres password=*****");
if (!$conn) {
  echo "Une erreur est survenue.\n";
  exit;
}

// Selects all the rows in the markers table.
$query = 'SELECT gid,name,substr(st_askml(geom,10),28) as geometrie from mon_schema.ma_table';
$result = pg_query($query);

if (!$result) {
  echo "Une erreur est survenue.\n";
  exit;
}

// Creates an array of strings to hold the lines of the KML file.
$kml = array('<?xml version="1.0" encoding="UTF-8"?>');
$kml[] = '<kml xmlns="http://earth.google.com/kml/2.2">';
$kml[] = ' <Document>';
$kml[] = ' <Style id="yellowLineGreenPoly">';
$kml[] = ' <LineStyle>';
$kml[] = ' <color>ff0000ff</color>';
$kml[] = ' </LineStyle>';
$kml[] = ' <PolyStyle>';
$kml[] = ' <color>ffff0000</color>';
$kml[] = ' </PolyStyle>';
$kml[] = ' </Style>';

// Iterates through the rows, printing a node for each row.
while ($row = pg_fetch_assoc($result))
{
  $kml[] = ' <Placemark id="placemark' . $row['gid'] . '">';
  $kml[] = ' <name>' . htmlentities($row['name]) . '</name>';
  $kml[] = ' <visibility>0</visibility>';
  $kml[] = ' <description>Ma description</description>';
  $kml[] = ' <styleUrl>#yellowLineGreenPoly</styleUrl>';
  $kml[] = ' <MultiGeometry>';
  $kml[] = ' <LineString>';
  $kml[] = ' <extrude>0</extrude>';
  $kml[] = ' <tessellate>1</tessellate>';
  $kml[] = ' <altitudeMode>relativeToGround</altitudeMode>';
  $kml[] = $row['geometrie'];
  $kml[] = ' </Placemark>';
 
} 

// End XML file
$kml[] = ' </Document>';
$kml[] = '</kml>';
$kmlOutput = join("\n", $kml);
header('Content-type: application/vnd.google-earth.kml+xml');
header("Content-Disposition: attachment; filename=mon_kml.kml");
echo $kmlOutput;
?>