<?php  
## Veritabanı bağlantısı yapalım.  
@mysql_select_db("db_diririm", mysql_connect("db_dirim","db_sifre"));  
## Xml olarak göstermek için girilen komut  
header("Content-Type: text/xml");  
## Sitemap Bilgileri  
echo '<?xml version="1.0" encoding="UTF-8"?>';  
echo '  
<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">  
';  

## Site Menüleri  
echo '  
    <url>  
       <loc>http://konya.us/</loc>  
       <lastmod>'.date("Y").'-'.date("m").'-'.date("d").'T'.date("H:i:s").'+00:00</lastmod>  
       <changefreq>daily</changefreq>  
       <priority>0.5000</priority>  
    </url>  
      <url>  
       <loc>http://www.konya.us/haberler.html</loc>  
       <lastmod>'.date("Y").'-'.date("m").'-'.date("d").'T'.date("H:i:s").'+00:00</lastmod>  
       <changefreq>daily</changefreq>  
       <priority>0.8000</priority>  
  </url>  
  <url>  
       <loc>http://www.konya.us/formlar.html</loc>  
       <lastmod>'.date("Y").'-'.date("m").'-'.date("d").'T'.date("H:i:s").'+00:00</lastmod>  
       <changefreq>daily</changefreq>  
       <priority>0.8000</priority>  
  </url>  
';  

## Makaleleri Listele  
$haberler        = mysql_query("select * from haberler where durum='0' order by id DESC");  
    while($seoxml    = mysql_fetch_array($haberler)){  
      
echo'  
    <url>  
       <loc>http://konya.us/haberler-'.$seoxml["baslik"].'.html</loc>  
       <lastmod>'.date("Y").'-'.date("m").'-'.date("d").'T'.date("H:i:s").'+00:00</lastmod>  
       <changefreq>daily</changefreq>  
       <priority>0.5000</priority>  
    </url>  
';  
}  

echo '</urlset>';