kullandığım kodlar
<?php include ("h1.php");
$indexson = $veridb->get_results("SELECT * FROM mp3 where onay='evet' order by id desc Limit 0,100");
foreach ( $indexson as $sonx ) {
$id = stripslashes(strip_tags($sonx->id));
$isim = stripslashes(strip_tags($sonx->isim));
$katid = stripslashes(strip_tags($sonx->katid));
$hit = stripslashes(strip_tags($sonx->hit));
$sanatcidb = $veridb->get_row("SELECT * FROM mp3kat where id='$katid'");
$sanatci = stripslashes(strip_tags($sanatcidb->kim));
}
header('Content-type: text/xml;charset=UTF-8');
$xml = "<?xml version=\"1.0\" encoding=\"UTF-8\"?>"."\n"."<urlset xmlns=\"http://www.sitemaps.org/schemas/sitemap/0.9\">"."\n";
$xml .= "\t"."<url>"."\n\t\t"."<loc>"http://www.bedavamp3.gen.tr/<?=$id?>/<?=linkcevir($sanatci)?>-<?=linkcevir($isim)?>-dinle.html"</loc>"."\n\t"."</url>";
$xml.="</urlset>";
echo $xml;
?>