1 2 3 4 5 ( 0 Votes )

Categorie parinte: Webmaster

Categorie: PHP

Creat la Duminică, 02 Octombrie 2011 11:17

Scris de Zeus

Afişări: 317

$databaseServer = "localhost";
  $databaseUsername = "username";
  $databasePassword = "password";
  $databaseName = "database_name";
  $databaseTable = "database_table";
?>
<?php
header('Content-Type: application/xml');
echo '<?xml version="1.0" encoding="utf-8"?>'."\n"; 
if ( isset( $xsl ) && $xsl != '' )
echo '<?xml-stylesheet type="text/xsl" href="http://'.$_SERVER['SERVER_NAME'].$xsl.'"?>'."\n";
?>
<urlset 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" xmlns="http://www.sitemaps.org/schemas/sitemap/0.9">
<?php
  $sql = "SELECT * FROM `".$databaseTable."`";
  $link = @mysql_connect($databaseServer,$databaseUsername,$databasePassword);
  @mysql_select_db($databaseName,$link);
  $result = mysql_unbuffered_query($sql,$link);
  while($row = mysql_fetch_array($result,MYSQL_ASSOC))
  {
    // create the loc (URL) value based on the $row array, for example:
    $loc = 'www.site.ro/index.php?file='.$row['id'];
    print "<url>";
    print "<loc>".$loc."</loc>";
    print '<lastmod>' . gmdate("Y-m-d", $row['date']) .'</lastmod>';
    print '<changefreq>daily</changefreq>'; 
    print '<priority>0.6</priority>';
    print "</url>";
  }
  print "</urlset>";
?>