GENERATING SITEMAP FROM URLS STORED IN table

Question

i want a php script that can generate sitemap.xml , I have 5000 urls are stored in the table . So is there a way so that I can fetch urls form the table and generate sitemap and store as sitemap.xml ?

Answer 1

Sure there is a way:

1) Connect to table and request all urls

During iteration:

2) Sanitize them as XML doesn't allow any special chars

3) Wrap it in xml <url> section

4) Echo the wrapped url, push it to some file or store it in another var for later use. I would strongly advise not to use live generation and go for cron and static XML file.

Details how the sitemap should look like can be found here https://support.google.com/webmasters/answer/183668?hl=en