Convert Xml to rss

[uttam.paul69]

I want to convert my sitemap.xml to a .rss feed. How can I do this? Is there any software or online tool to do it? Plz help I need it hardly.

[tn69]

(04-12-2015 07:12 PM)uttam.paul69 Wrote:  I want to convert my sitemap.xml to a .rss feed. How can I do this? Is there any software or online tool to do it? Plz help I need it hardly.

your sitemap.xml is static or dynamic?
normally sitemaps have only urls. But for rss feed we need url,title,description sample format would be like this.

PHP Code:

<?xml version="1.0" encoding="UTF-8" ?>
<rss version="2.0">

<channel>
  <title>W3Schools Home Page</title>
  <link>http://www.w3schools.com</link>
  <description>Free web building tutorials</description>
  <item>
    <title>RSS Tutorial</title>
    <link>http://www.w3schools.com/rss</link>
    <description>New RSS tutorial on W3Schools</description>
  </item>
  <item>
    <title>XML Tutorial</title>
    <link>http://www.w3schools.com/xml</link>
    <description>New XML tutorial on W3Schools</description>
  </item>
</channel>

</rss> 


[uttam.paul69]

My sitemap is static

[tn69]

i assume you want rss for your blog site http://www.uttam-soft.tk/

here is your rss
http://feeds.feedburner.com/Uttam-soft

[uttam.paul69]

Hehe! I know that bro. Actually I need an rss feed for my other sites which are hosted on cpanel. I have a sitemap of 20,000 urls. So, I want to make a feed of that sitemap.

[tn69]

can you tell your sitemap url ?

[uttam.paul69]

Here it is: http://apkstore.gq/sitemap.xml

[tn69]

(04-13-2015 05:44 PM)uttam.paul69 Wrote:  Here it is: http://apkstore.gq/sitemap.xml

i think your site uses mysql database.
so you can do like this. this is a dynamic rss feed.

PHP Code:

<?php

mysql_connect('localhost','username','password');
mysql_select_db('database');
$query=mysql_query('select title,url,description from file_table order by id desc');
while($row=mysql_fetch_object($query))
{
$items.='<item>
    <title>'.$row->title.'</title>
    <link>'.$row->url.'</link>
    <description>'.$row->description.'</description>
  </item>';
}

echo '<?xml version="1.0" encoding="UTF-8" ?>
<rss version="2.0">
<channel>'.$items.'
</channel>
</rss>';
?>

modify this according to your site database table structure that holds file information.

[uttam.paul69]

Ok thanks