Unable to save dynamically generated XML sitemap using PHP

Question

I am using PHP to dynamically generate an XML sitemap. The generation part is running smooth but am somehow unable to save the results as an XML file. Here's the PHP I wrote:

$xml = new SimpleXMLElement('<?xml version="1.0" encoding="utf-8" ?><urlset xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:image="http://www.google.com/schemas/sitemap-image/1.1" xmlns="http://www.sitemaps.org/schemas/sitemap/0.9" xsi:schemaLocation="http://www.sitemaps.org/schemas/sitemap/0.9 http://www.sitemaps.org/schemas/sitemap/0.9/sitemap.xsd"/>');
$node = $xml->addChild('url');
$node->addChild('loc', 'http://www.pb.com/blog/');
$node->addChild('changefreq', "daily");
$node->addChild('priority', "1");
$connect = dbconn(PROJHOST, POSTSDB, POSTSUSR, POSTSPWD);
$sql = "SELECT * FROM tblposts ORDER BY id";
$query = $connect->prepare($sql);
if($query->execute()) {
    $rows = $query->fetchAll(PDO::FETCH_ASSOC);
    if($rows){
        foreach($rows as $row){
            $post_date = $row['post_date'];
            $node = $xml->addChild('url');
            $node->addChild('loc', trim("http://www.pb.com/blog/" . $row['post_name']));
            $node->addChild('lastmod', str_replace(' ', 'T', $row['post_date']) . "-05:00");
            $node->addChild('changefreq', "weekly");
            $node->addChild('priority', "0.6");
        }
    }
}
Header('Content-type: text/xml');
print($xml->asXML());

// $dom->preserveWhiteSpace = FALSE;
$xml->save('sitemap.xml');

The fatal error it's throwing is:

Call to undefined method SimpleXMLElement::save() in /xxx/xxx/xxx/sandboxgenerate_sitemap.php on line 79

Any alternative?

When you get probelms like this ___[Read the flippin Manual. Thats what its there for](http://php.net/manual/en/book.simplexml.php)___ Where is the save method? Nowhere — RiggsFolly, Jan 24 '17 at 14:34
Wow. Not making an excuse but the rudeness wasn't really warranted. Thanks for the help though. — TheLearner, Jan 24 '17 at 14:45
use the `file_put_contents()` function in PHP to write to a file. — mike510a, Jan 24 '17 at 14:56
See this question: _[how to write into a file in php](http://stackoverflow.com/questions/1768894/how-to-write-into-a-file-in-php)_ — mike510a, Jan 24 '17 at 14:57
@TheLearner Well really, it would have taken you less time to look at the manual than to type up the question — RiggsFolly, Jan 24 '17 at 16:38

score 1 · Answer 1 · answered Jan 24 '17 at 14:28

1

http://php.net/manual/de/class.simplexmlelement.php lists the methods, if you want to create a file then I think $xml->asXML('sitemap.xml') does the job.

answered Jan 24 '17 at 14:28

Martin Honnen

160,499
6
90
110

score 1 · Accepted Answer · answered Jan 24 '17 at 14:28

The SimpleXMLElement class does not have a method called save(). Instead use asXML(), like you did in the line above, and pass it the optional $filename parameter. Specifying this parameter will result in the XML being saved to the file rather than displayed. Further documentation here: http://php.net/manual/en/simplexmlelement.asxml.php

Unable to save dynamically generated XML sitemap using PHP

2 Answers2