How to create google sitemap for my dynamic site?

Hello DP members,

I need some suggestions regarding, how to create google sitemap for my dynamic website? This site contains about 1100 pages and no site map generator creates this much of URLs, Can any body suggest me which google sitemap generator is appropriate to create sitemap for this website?

Any suggestion would be appriciated.

Thanks

 

If it's dynamic I code a PHP/ASP script to generate the sitemap file on the fly. This helps you ensure that all the pages are included, the way you want. Hope it helps.

 

Is there any tool available to generate the sitemap for my dynamic website containing 1100 pages at once ?

 

Please also suggest the PHP name that can generate SiteMap on Fly.

Also suggest how do we create a google site map for sites that require authentication?

 

did you try xml-sitemaps.com ? i am currently using its plugin for wordpress, it also support for vbulletin , and other CMS as well as you can also get a stand alone script for any website. it is developed in php

 

1100 pages are nothing.

You could try my site map generator program.

Else check: http://code.google.com/sm_thirdparty.html

 

If you wanted to generate your sitemap on the fly using ASP here's the code I used - just the clever (?!) bits:

<%@LANGUAGE="VBSCRIPT"%><%Response.ContentType = "application/xml"%><?xml version="1.0" encoding="UTF-8"?>
<urlset xmlns="http://www.google.com/schemas/sitemap/0.84">
<!--#include file="../Connections/atlantisDSN.asp" -->
<%set conn=Server.CreateObject("ADODB.Connection")
conn.open connString%><%set eventsRS=conn.execute("SELECT * FROM events WHERE events_archive IS NULL ORDER BY events_date_year, events_date_month, events_date_day")
while not eventsRS.eof%>
<url>
<loc>http://www.atlantisnightclub.co.uk/events/show_events.asp?id=<%=eventsRS("events_id")%></loc>
<lastmod><%=eventsRS("events_updated")%></lastmod>
<changefreq>weekly</changefreq>
<priority>0.8</priority>
</url><%strDate = eventsRS("events_updated")
if not eventsRS.eof then eventsRS.movenext
wend%>
</urlset>

 

You need write Asp or PHP code to create your sitemap dynamic, as i do not know the struct of your database, I can not tell you the details.

 

Do u 've it in web-based?

 

for destop program you can use this software for create generate sitemap
here is software
http://johannesmueller.com/gs-files/GSiteCrawler-106-full.EXE

or you can use these site create sitemaps too, here they are;
http://tools.webmasters.sk/sitemap-creator.php
http://pingoat.com/goat/google_sitemap
http://www.sitemapdoc.com/

 

Try my free online sitemap generator at www.hkhangfong.com/service.htm, a desktop version is also available at www.hkhangfong.com/service/freesoftwares.htm

 

yea u can use php or asp script to generate sitemaps for your dynamic site...

 

Any one has PHP script to generate sitemap???

I also want to know if charaters like '?' and '=' are allowed in sitemap file.

 

@manwanis

Read the sitemap documentation
https://www.google.com/webmasters/tools/docs/en/protocol.html#escaped

 

I have a dynamic site but it does not have that many pages yet. I use a component, the Joomap component to generate my website's sitemap.

 

Put this code in your header:

<?php
$query - "SELECT pagename FROM table WHERE pagename='$_SERVER[PHP_SELF]'";
$result = mysql_query($query);
if( mysql_num_rows($result) == 0 ) {
mysql_query("INSERT INTO table(pagename) VALUES('$_SERVER[PHP_SELF]')");
}
?>
... it will record the page.

You can submit to sitemaps a textfile with each link on a new page, so create a new file generating the new query:

<?php
$query = "SELECT * FROM table GROUP BY pagename";
$result = mysql_query($query);
while( $row = mysql_fetch_array($result) ) {
echo "$row[pagename]<br />";
}
?>

... then simply copy and paste the results to a .txt file, and submit it to google maps.

--
this prosumes two things: you have php, and your visitors navigate your site. if the latter isnt the case... Get clicking.