How create an XML feed using php and mysql

Question

I created a rss feed for my site and the url looks like this: http://abcde.com/rss/rss.php

I want an url like this: http://abcde.com/rss/rss.xml

How to do this, please help me.

Thanks in advance.

What web server are you using? Most people use a rewrite rule in Apache — Lee Armstrong
– Lee Armstrong, Commented Aug 18, 2011 at 17:21

Code Magician · Accepted Answer · 2011-08-18 17:40:59Z

2

.htaccess rules?

If you want all .xml files to point to php files, use these.

RewriteEngine On
RewriteBase   /rss

RewriteRule  ^(.*).xml$ $1.php [R=301]

This should also work:

RedirectMatch perm ^/rss/(.+)\.xml$ http://yoursite.com/rss/$1.php

Otherwise, use the code Jason McCreary suggested:

RewriteEngine On
RewriteBase   /rss

RewriteRule  ^rss.xml$ rss.php [L]

Which will only rewrite rss.xml to rss.php.

edited Aug 18, 2011 at 17:40

answered Aug 18, 2011 at 17:22

Code Magician

24.1k7 gold badges63 silver badges77 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Code Magician Over a year ago

I'm assuming apache, I don't know the solution on other web servers. Apparently this is the solution on IIS stackoverflow.com/questions/60857/…

Jason McCreary Over a year ago

This is a bit aggressive. It's better to be specific, i.e. ^rss.xml$ rss.php [L] Otherwise, all .xml requests will be redirected to .php

Code Magician Over a year ago

Great point @Jason. When I did something similar, that was the desired behavior but I didn't consider the alternative.

user784540 · Accepted Answer · 2011-08-18 17:27:05Z

1

I recommend to generate a static xml file via php and give access to this file.

Invoking php script that reads back-end database every time to generate rss feed, especially when there are many users, may affect on your server performance.

Generate a static xml file and update it every time when you update your web-site.

And provide link to this static xml file.

answered Aug 18, 2011 at 17:27

user784540

Collectives™ on Stack Overflow

How create an XML feed using php and mysql

2 Answers 2

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related