使用PHP将txt转换为sitemap.xml

Question

Supposed that I have text database include is:

http://example.com,monthly,0.3
http://example.com/one,daily,0.5
http://example.com/two,weekly,0,8

I would like to convert to my text database to sitemap.xml.

$fp = fopen('./database.txt', 'r');
$xml = new XMLWriter;
$xml->openURI('./sitemap.xml');
$xml->setIndent(true); 
$xml->startElement('urlset');
while ($line = fgetcsv($fp)) {
   if (count($line) < 4) continue;
   $xml->startElement('url');
   $xml->writeElement('loc', $line[0]);
   $xml->writeElement('changefreq', $line[1]);
   $xml->writeElement('priority', $line[2]);
echo $xliff->getDocument();
   $xml->endElement();
}
$xml->endElement();

I tried this code, I couldn't add this part...

<?xml version="1.0" encoding="UTF-8"?>
<urlset 
  xmlns='http://www.sitemaps.org/schemas/sitemap/0.9' 
  xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance'     
  xsi:schemaLocation='http://www.sitemaps.org/schemas/sitemap/0.9 http://www.sitemaps.org/schemas/sitemap/0.9/sitemap.xsd">

Answer 1

You could use http://php.net/manual/en/function.xmlwriter-start-attribute-ns.php or use DOM:

$fp = fopen('./database.txt', 'r');
$dom = new DOMDocument();
$dom->formatOutput = true;
$urlset = $dom->createElementNS('http://www.sitemaps.org/schemas/sitemap/0.9', 'urlset');
$dom->appendChild($urlset);
while ($line = fgetcsv($fp)) {
    var_dump($line);
    $url = $dom->createElement('url');
    $urlset->appendChild($url);
    $url->appendChild($dom->createElement('loc', $line[0]));
    $url->appendChild($dom->createElement('changefreq', $line[1]));
    $url->appendChild($dom->createElement('priority', $line[2]));
}
echo $dom->saveXML();