How to create a sitemap using PHP & MySQL

php mysql sitemap
HELP picture HELP · Oct 25, 2010 · Viewed 22.7k times · Source

I was wondering how can I create a sitemap using PHP & MySQL and is there any sitemap design examples you know of?

Answer

Westy92 picture Westy92 · Feb 2, 2011

I use this on my site, it works well and you can point Google's webmaster tools to "this_file.php" and it works wonders!

<?php
header("Content-type: text/xml");
echo'<?xml version=\'1.0\' encoding=\'UTF-8\'?>';
echo'   <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">';

include '../include.php';
$sql = mysql_query("select blah from bleh");

while ($string = mysql_fetch_array($sql)){?>
            <url>
                <loc>http://www.domain.com/dir/<?echo $string['value'];?>/index.php</loc>
                <changefreq>weekly</changefreq>
            </url>
<?php } ?> 
</urlset>

Related questions

MYSQL select where field does not contain a certain string character

I use sql to select all my sites URLs from a table. $sql = 'select * from pages where "myURL field"; However I want to be a little more specific with my query. There are a few duplicate links in my table …

Read More
How can I prevent SQL injection in PHP?

If user input is inserted without modification into an SQL query, then the application becomes vulnerable to SQL injection, like in the following example: $unsafe_variable = $_POST['user_input']; mysql_query("INSERT INTO `table` (`column`) VALUES ('$unsafe_variable')"); That's …

Read More
Import file size limit in PHPMyAdmin

I have changed all the php.ini parameters I know: upload_max_filesize, post_max_size. Why am I still seeing 2MB? Im using Zend Server CE, on a Ubuntu VirtualBox over a Windows 7 host.

Read More