Sitemap in PHP generat dinamic

Am tot cautat o solutie facuta, insa se pare ca nu e multa lume interesata de subiect. Lucrez acum la un site care are peste 200.000 pagini si care va avea in jur de 40 de sitemaps. Cum fac generararea? Iata codul mai jos:

//include baza de date
$db=mysql_connect($dbhost,$dbuser,$dbpass);
mysql_select_db($dbdatabase);

$mainPages = array(
“http://www.domeniu.ro/”,
“http://www.domeniu.ro/topuseri/”,
“http://www.domeniu.ro/toparticole/”);

//declara header si insceput sitemap
header (‘Content-type: text/xml’);
echo ‘’;
echo ‘’;

for($i=0; $iecho ‘
’. $mainPages[$i] .’
daily
1.0
’;
}

//genereaza categoriile
$map_result = mysql_query(“SELECT id FROM categorii”);
while ($map_row = mysql_fetch_array($map_result)) {
$category = “http://www.domeniu.ro/categorie/” . $map_row['id'] . “/”;

echo ”

”. $category  .”
weekly
1.0
”;
}

//genereaza elementele
$map_result = mysql_query(“SELECT id FROM articole WHERE aprobat = 1?);
while ($map_row = mysql_fetch_array($map_result)) {
echo ‘

http://www.domeniu.ro/articol/’. $map_row['id'] .’/
weekly
1.0
’;
}

//inchide sitemapul
echo ‘
’;

?>

View the original article here

 

Discover the revolutionary strategies to instantly drive unlimited traffic to your websites by exploiting proven traffic magnets! Dominate your market instantly! Affiliates: www.the-web-traffic-evolution.com/affiliates.html

Check it out!