Is there any possibility to create a RSS feed from php and mysql..
I know that xml files do not allow php..but hope someone knows how to do this?

What are you trying to do? Are you trying to archive rss entries? This would be possible but would require a bit of work on the programmers end.

I would like to automate the process of entering new data at the rss feed from the mysql database using php..

I have a tutorial in my signature that should help.

I checked it out right now..That was the initial idea I had for that...and you can check this article here--> http://forums.digitalpoint.com/showthread.php?t=986765..

But I think you cannot use php inside xml, I just tried yesterday..

You can, but the file has to have a php file extension. There is no specification anywhere that states what file extension an RSS feed needs to have, so you can create your XML as normal and then echo your dynamic components in the appropriate places.

Please be more accurate, do you mean that I should create a feed with a php extension( I know this could be done)..but I cannot do the reverse, i tried yesterday but a file like: myfeed.xml does not recognize php.

though bookmarked your tutorial, I liked it very much..thanks

I've not tested it, but as far as I know, you cannot create a dynamic feed with a .xml extension because your server won't know to parse files with that extension as PHP and so the code won't function because it never executed. There may be a way to tell it to do that, but it's just as easy to use the .php file extension.

well, i know now what you mean but is it sure if a feed reader can a recognize a php file as a feed..I will make a try later on my browser..

It will validate as a feed.

Ok thanks again

As I tried right now, it won't work. There comes an error that does not recognize xml..

Parse error: syntax error, unexpected T_STRING in C:\wamp\www\rss.php on line 10

1. You may use mod_rewrite to rewrite requests to some /feed.xml to /feed.php
or
2. You may generate the static xml file periodically using cron jobs or on ob demand with your script

And don't forget to send correct Content-type if you prefer dynamic way, it should be something like text/xml but I may be wrong about it. Anyway php says text/html by default and thus the RSS client may not accept your feed.

Alsom what is in C:\wamp\www\rss.php on line 10 ?

Originally Posted by mtishetsky

Alsom what is in C:\wamp\www\rss.php on line 10 ?

It is the beginning of the xml, <?xml ( i turned off short tags, but no solution)..well you brought some new ideas, but don't know anything about mod_rewrite - is this part of any library?

PHP Code:

<?
echo '<?xml version="..." ?>';
?>
<items>
<? foreach ($data as $item): ?>
<item name="<?= $item->name ?>"><?= $item->value ?></item>
<? endforeach ?>
</items>

mod_rewrite is apache module

Still I would advise you to go static way and generate the xml file by cron or on demand. This will save you from loading your database with the repeating requests which still wil retrieve one and the same data during some period of time. Also this will allow you increase the speed of serving your feed.

well, thanks a lot, maybe its better if I switch to creating it manually..