Google Sitemap Generator

google_xml_sitemap_generator.php

<?php

require_once 'functions.php';
require_once 'rb-mysql.php';

///////////////////////// SETUP /////////////////////////
date_default_timezone_set('Asia/Tbilisi');
$baseurl = 'http://localhost:3000';
$dbuser = 'root';
$dbpassword = '';
$dbname = 'magma';

R::setup( 'mysql:host=localhost;dbname='.$dbname.'',''.$dbuser.'', ''.$dbpassword.'' );
$articles = R::getAll('select url, createdat from articles limit 50');


///////////////////////// WORKING WITH SITEMAP XML /////////////////////////
$xml = new DOMDocument("1.0", "UTF-8");
$xml->formatOutput = true;

//////////////////////////
$urlset = $xml->createElement('urlset');
$xml->appendChild($urlset);

foreach ($articles as $a) { 
    $article=$xml->createElement("url");
    $urlset->appendChild($article);
    
    $url = $xml->createElement('loc', $baseurl . '/' . $a['url']);
    $article->appendChild($url);
    
    $timestamp = $xml->createElement('lastmod', date("Y-m-d\TH:i:sP", $a['createdat']));
    $article->appendChild($timestamp);
    
    $priority = $xml->createElement('priority', 1);
    $article->appendChild($priority);
}

echo "<xmp>".$xml->saveXML()."</xmp>";
if (file_exists(__DIR__ . "/sitemap.xml")) unlink(__DIR__ . "/sitemap.xml");
$xml->save("sitemap.xml");