Simple sitemap creator script for a PHP /SQL website
$30-250 USD
In Progress
Posted about 14 years ago
$30-250 USD
Paid on delivery
Project is to create an XML sitemap for a database driven website.
Local PHP script have to read the SQL database for entries which will allow to create the URLs for the XML sitemap.
Script connects to the database, builds the sitemap, creates [login to view URL] compressed copy, and pings google, yahoo
([login to view URL]://[login to view URL])
([login to view URL]://[login to view URL])
Part 1: Static entries in the sitemap. I provide this part.
<url>
<loc>http://www.name.com/</loc>
<lastmod>2009-12-30T21:40:10+00:00</lastmod>
<changefreq>weekly</changefreq>
<priority>1</priority>
</url>
Part 2: City entries in the sitemap:
Simply read corresponding "city-url" table from database and build the URLs as follows:
<url>
<loc>http://www.name.com/en.php/properties/xxxxx/-/-/</loc> // xxxxx is the city name url taken from the SQL database
<lastmod>2009-12-30T21:40:10+00:00</lastmod> // current date
<changefreq>weekly</changefreq> // static text: weekly
<priority>0.9</priority> // static text: 0.9
</url>
Part 1: Property entries in the sitemap:
<url>
<loc>http://www.name.com/en.php/property/xxxxx</loc> // xxxxx is the entry number taken from the SQL database
<lastmod>2009-12-30T21:40:10+00:00</lastmod> // current date
<changefreq>weekly</changefreq> // static text: weekly
<priority>0.7</priority> // static text: 0.7
</url>
Server is a Apache server, with cpanel access. This is a small task, I need it ASAP.
Good evening,
I can start this right away and have it to you within an hour or so.
I have been a web developer in PHP/MySQL for over 7 years and perform tasks like this on a daily basis.
Can also be contacted on MSN, Skype or via email for instant communication.
Hope to hear from you soon!
Steve