PHP:
скопировать код в буфер обмена
скопировать код в буфер обмена
- <?PHP
- $host = "localhost";
- $db_username = "username";
- $db_password = "password";
- $db_name = "dbname";
- $writer = new XMLWriter();
- $writer->openURI('php://output');
- $writer->startDocument('1.0', 'windows-1251');
- $writer->setIndent(4);
- $writer->startElement('urlset');
- $writer->writeAttribute('xmlns', "http://www.sitemaps.org/schemas/sitemap/0.9");
- $writer->startElement("url");
- $writer->writeElement('loc', 'http://'.$_SERVER['HTTP_HOST'].'/');
- $writer->writeElement('changefreq', 'daily');
- $writer->writeElement('priority', '1.00');
- $writer->endElement();
- // Внутренние каталоги
- $sql = "SELECT `id`, `datetime` FROM `table_name`";
- $writer->startElement("url");
- $writer->writeElement('loc', 'http://'.$_SERVER['HTTP_HOST'].'/index+nums-'.$row[0].'.html');
- $writer->writeElement('lastmod', ''.$row[1].'');
- $writer->writeElement('changefreq', 'daily');
- $writer->writeElement('priority', '1.00');
- $writer->endElement();
- }
- // / Внутренние каталоги
- // Закрываем соединение
- // Закрываем urlset
- $writer->endDocument();
- $writer->flush();
- ?>