ایجاد نقشه سایت XML با استفاده از PHP

				
					// Sample Structure Of XML Sitemap
<?xml version="1.0" encoding="UTF-8"?>
<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9">
 <url>
  <loc>http://www.example.com/index.php </loc>
  <lastmod>2016-01-23T18:00:15+00:00</lastmod>
 </url>
</urlset>

// Database Structure 
CREATE TABLE 'post' (
 'link' text NOT NULL,
 'date' text NOT NULL,
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1


<?php

header('Content-type: application/xml');
  
$host="localhost";
$username="root";
$password="";
$databasename="sample";
$connect=mysql_connect($host,$username,$password);
$db=mysql_select_db($databasename);	
 
$get_result=mysql_query("select * from post");

echo "<?xml version='1.0' encoding='UTF-8'?>"."\n";
echo "<urlset xmlns='http://www.sitemaps.org/schemas/sitemap/0.9'>"."\n";

echo "
<url>
 <loc>http://talkerscode.com/</loc>
 <lastmod>2016-01-23T18:00:15+00:00</lastmod>
 <changefreq>daily</changefreq>
</url>
<url>
 <loc>http://talkerscode.com/about.php</loc>
 <lastmod>2016-01-23T18:00:15+00:00</lastmod>
 <changefreq>daily</changefreq>
</url>
<url>
 <loc>http://talkerscode.com/contact.php</loc>
 <lastmod>2016-01-23T18:00:15+00:00</lastmod>
 <changefreq>daily</changefreq>
</url>";

while($row=mysql_fetch_array($get_result))
{
 echo "<url>";
 echo "<loc>".$row['link']."</loc>";
 echo "<lastmod>".$row['date']."</lastmod>";
 echo "<changefreq>daily</changefreq>";
 echo "</url>";
}

echo "</urlset>";

?>