给定一个房地产数据的MySQL表,我想生成一个具有以下输出的KML文件:
<?xml version="1.0" encoding="UTF-8"?>
<kml xmlns="http://www.opengis.net/kml/2.2">
<Document>
<Placemark>
<name>Property Address Pulled from Address Field</name>
<description>
Some descriptive data pulled from table inserted here.
</description>
<Point>
<coordinates>Latitude FROM Lat,Long FROM Lng</coordinates>
</Point>
</Placemark>
</Document>
</kml>
这是我到目前为止的代码。如您所见,我在编写一个循环来构建我的 KML 时遇到问题,如上所示。任何帮助都非常感谢!
<?php
require("phpsqlgeocode_dbinfo.php");
// Start XML file, create parent node
$dom = new DOMDocument('1.0', 'UTF-8');
$dom->formatOutput = true; //This was added from the PHP Doc. Nice output.
// Creates the root KML element and appends it to the root document.
$node = $dom->createElementNS('http://www.opengis.net/kml/2.2', 'kml');
$parNode = $dom->appendChild($node);
// Creates a KML Document element and append it to the KML element.
$dnode = $dom->createElement('Document');
$docNode = $parNode->appendChild($dnode);
// Opens a connection to a mySQL server
$connection=mysql_connect (localhost, $username, $password);
if (!$connection) {
die("Not connected : " . mysql_error());
}
// Set the active mySQL database
$db_selected = mysql_select_db($database, $connection);
if (!$db_selected) {
die ("Can''t use db : " . mysql_error());
}
// Search the rows in the markers table
$query = sprintf("SELECT * FROM markers");
$result = mysql_query($query);
if (!$result) {
die("Invalid query: " . mysql_error());
}
header("Content-type: application/vnd.google-earth.kml+xml");
// Iterate through the rows, adding KML nodes for each
while ($row = @mysql_fetch_assoc($result)){
$dnode = $dom->createElement("Placemark");
$newnode = $docNode->appendChild($dnode);
$newnode = $newnode->createElement("Name");
$newnode = $newnode->createElement("Description");
$newnode = $newnode->createElement("Coordinates");
}
echo $dom->saveXML() . "'n";
?>
据我所知(并且基于我对文档的阅读),createElement()
是DOMDocument
类(根文档$dom
)而不是DOMElement
的方法。
您已经创建了 3 个新元素,但您没有将它们中的任何一个追加为 $dnode
的子元素。 对每个$dom->createElement()
使用,并将其附加到正确的$dnode (Placemark)
// Iterate through the rows, adding KML nodes for each
while ($row = mysql_fetch_assoc($result)){
$dnode = $dom->createElement("Placemark");
$newnode = $docNode->appendChild($dnode);
// Append each $newnode after creating from $dom
// Set its nodeValue to a column from your fetch call
// before appending it to the parent node
// Substitute your correct column names from mysql_fetch_assoc()
$newnode = $dom->createElement("Name");
$newnode->nodeValue = $row['Name'];
$dnode->appendChild($newnode);
$newnode = $dom->createElement("Description");
$newnode->nodeValue = $row['Description'];
$dnode->appendChild($newnode);
//Coordinates are a child node of the 'Point' node
$pointnode = $dom->creteElement("Point");
$dnode-appendChild($pointnode);
$coordsnode = $dom->createElement("Coordinates");
$coordsnode->nodeValue = $row['Coordinates'];
$pointnode->appendChild($coordsnode);
}
echo $dom->saveXML() . "'n";
要强制使用.kml文件名,请使用Content-Disposition
标头:
header("Content-type: application/vnd.google-earth.kml+xml");
header("Content-disposition: inline; filename=$somefilename.kml");