<?php
//seo url yapı fonksiyonu
function seo($s) {

    $tr = array('ş','Ş','ı','I','İ','ğ','Ğ','ü','Ü','ö','Ö','Ç','ç','(',')',' ',',','?');
    $eng = array('s','s','i','i','i','g','g','u','u','o','o','c','c','','','-','','');
    $s = str_replace($tr,$eng,$s);
    $s = strtolower($s);
    $s = preg_replace('/&amp;amp;amp;amp;amp;amp;amp;amp;amp;.+?;/', '', $s);
    $s = preg_replace('/s+/', '-', $s);
    $s = preg_replace('|-+|', '-', $s);
    $s = preg_replace('/#/', '', $s);
    $s = str_replace(''', '-', $s);
    $s = str_replace('.', '', $s);
    $s = str_replace('|', '', $s);
    $s = trim($s, '-');
    return $s;
}

$servername = "localhost";
$username = "root";
$password = "root";
$dbname = "yurtlar";

$conn = new mysqli($servername, $username, $password, $dbname);

$sql = "SELECT * FROM il";
$result = $conn->query($sql);
?>

<?php header('Content-type: application/xml; ',true); ?>

<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">

<?php while($dil = $result->fetch_assoc()) { ?>

<url>
<loc><?=seo('http://localhost/test/il-'.$dil["il_adi"]).'-'.$dil["il_id"] ?></loc>
        <changefreq>weekly</changefreq>
<priority>0.7</priority>
</url>

<?php } ?>
</urlset>