Copio il semplice codice PHP per leggere record da un database e creare una fonte xml RSS.
Tralascio il codice per collegarsi al database e la query. Uso nomi inventati per i campi della tabella del db. Il link della fonte RSS è ovviamente la pagina dove inseriamo il codice (es: fonte_rss.xml.php).
Attenzione alla sintassi xml, il parser xml di mozilla è ad es. molto sensibile ai caratteri di andata a capo.
La prima riga della fonte xml è scritta in tal modo in quanto il tag di apertura xml inizia come il tag di apertura per il codice php e il parser php lo interpreterebbe erroneamente come codice php.
<? print '<'.'?xml version="1.0" ?><rss version="2.0"><channel>'; ?>
<title>
titolo
</title>
<link>
http://www.sito.it
</link><description>
descrizione
</description>
<language>it</language>
<copyright>
autore news
</copyright>
<?
//connessione mysql
while ($row=mysql_fetch_array($result))
{
$page.='<item><title>'.$row[titolo].'</title>';
$page.='<description>'.$row[description].'</description><link>'.$row[link].'<link></item>\n' ;
}
print $page;
?>
</channel>
</rss>
papa johns menu
on February 14 2012
Great website…
[...]we like to honor many other internet sites on the web, even if they aren’t linked to us, by linking to them. Under are some webpages worth checking out[...]……
fighting games online
on February 14 2012
Links…
[...]Sites of interest we have a link to[...]……
Marriage Records
on February 14 2012
Awesome website…
[...]the time to read or visit the content or sites we have linked to below the[...]……
sista minuten resor
on February 14 2012
Links…
[...]Sites of interest we have a link to[...]……
SEO blog
on February 15 2012
Recent Blogroll Additions……
[...]usually posts some very interesting stuff like this. If you’re new to this site[...]……
what kills bed bugs
on February 15 2012
Sources…
[...]check below, are some totally unrelated websites to ours, however, they are most trustworthy sources that we use[...]……
online ebooks download
on February 15 2012
Websites we think you should visit…
[...]although websites we backlink to below are considerably not related to ours, we feel they are actually worth a go through, so have a look[...]……
Mathieu De Ruyck
on February 15 2012
Recent Blogroll Additions……
[...]usually posts some very interesting stuff like this. If you’re new to this site[...]……
extreme overclocking
on February 15 2012
You should check this out…
[...] Wonderful story, reckoned we could combine a few unrelated data, nevertheless really worth taking a look, whoa did one learn about Mid East has got more problerms as well [...]……
best blogs
on February 15 2012
Sources…
[...]check below, are some totally unrelated websites to ours, however, they are most trustworthy sources that we use[...]……
Mathieu De Ruyck
on February 15 2012
Websites we think you should visit…
[...]although websites we backlink to below are considerably not related to ours, we feel they are actually worth a go through, so have a look[...]……
cleaning supplies
on February 15 2012
Sites we Like……
[...] Every once in a while we choose blogs that we read. Listed below are the latest sites that we choose [...]……
Work at home business
on February 15 2012
Read was interesting, stay in touch……
[...]please visit the sites we follow, including this one, as it represents our picks from the web[...]……
fatburner
on February 15 2012
Trackback…
[...]here are some links to some sites that we think you should visit[...]…
section 79
on February 15 2012
Online Article……
[...]The information mentioned in the article are some of the best available [...]……
grandfather clocks
on February 15 2012
Read was interesting, stay in touch……
[...]please visit the sites we follow, including this one, as it represents our picks from the web[...]……
body jewelry wholesale
on February 15 2012
Recommeneded websites…
[...]Here are some of the sites we recommend for our visitors[...]……
Fat Burning Furnace
on February 15 2012
Links…
[...]Sites of interest we have a link to[...]……
weight loss center
on February 15 2012
Sources…
[...]check below, are some totally unrelated websites to ours, however, they are most trustworthy sources that we use[...]……
free youtube downloader
on February 15 2012
Websites you should visit…
[...]below you’ll find the link to some sites that we think you should visit[...]……
jobs in india
on February 15 2012
Sites we Like……
[...] Every once in a while we choose blogs that we read. Listed below are the latest sites that we choose [...]……
here
on February 15 2012
You should check this out…
[...] Wonderful story, reckoned we could combine a few unrelated data, nevertheless really worth taking a look, whoa did one learn about Mid East has got more problerms as well [...]……
Camomile Tea Benefits
on February 15 2012
Cool sites…
[...]we came across a cool site that you might enjoy. Take a look if you want[...]……
garmin navigator
on February 15 2012
Links…
[...]Sites of interest we have a link to[...]……
Eye Candy Pics
on February 16 2012
Blogs ou should be reading…
[...]Here is a Great Blog You Might Find Interesting that we Encourage You[...]……
compare auto insurance quotes
on February 16 2012
Awesome website…
[...]the time to read or visit the content or sites we have linked to below the[...]……
Privesky Striebro
on February 16 2012
Great website…
[...]we like to honor many other internet sites on the web, even if they aren’t linked to us, by linking to them. Under are some webpages worth checking out[...]……
edwards car
on February 16 2012
You should check this out…
[...] Wonderful story, reckoned we could combine a few unrelated data, nevertheless really worth taking a look, whoa did one learn about Mid East has got more problerms as well [...]……
Hampshire solar PV
on February 16 2012
Recommeneded websites…
[...]Here are some of the sites we recommend for our visitors[...]……
Digital Dictation
on February 16 2012
Links…
[...]Sites of interest we have a link to[...]……
webcam mit sex
on February 16 2012
Great website…
[...]we like to honor many other internet sites on the web, even if they aren’t linked to us, by linking to them. Under are some webpages worth checking out[...]……
shoes for girls
on February 16 2012
Cool sites…
[...]we came across a cool site that you might enjoy. Take a look if you want[...]……
Portable Solar Panels
on February 16 2012
Websites we think you should visit…
[...]although websites we backlink to below are considerably not related to ours, we feel they are actually worth a go through, so have a look[...]……
pussy
on February 16 2012
Websites worth visiting…
[...]here are some links to sites that we link to because we think they are worth visiting[...]……
realistische dildos
on February 16 2012
Check this out…
[...] that is the end of this article. Here you’ll find some sites that we think you’ll appreciate, just click the links over[...]……
Anonymous
on February 16 2012
News info…
I was reading the news and I saw this really cool topic…
Scott Tucker Racing
on February 16 2012
Check this out…
[...] that is the end of this article. Here you’ll find some sites that we think you’ll appreciate, just click the links over[...]……
Scott Tucker Payday Loans
on February 16 2012
Recommeneded websites…
[...]Here are some of the sites we recommend for our visitors[...]……
Scott Tucker Racing
on February 16 2012
Websites you should visit…
[...]below you’ll find the link to some sites that we think you should visit[...]……
mma schools
on February 16 2012
Read was interesting, stay in touch……
[...]please visit the sites we follow, including this one, as it represents our picks from the web[...]……
solar incentives
on February 16 2012
Cool sites…
[...]we came across a cool site that you might enjoy. Take a look if you want[...]……
house for sale in singapore
on February 16 2012
Recommeneded websites…
[...]Here are some of the sites we recommend for our visitors[...]……
fl unemployment claim weeks
on February 16 2012
Great website…
[...]we like to honor many other internet sites on the web, even if they aren’t linked to us, by linking to them. Under are some webpages worth checking out[...]……
social media marketing for small business
on February 16 2012
Great website…
[...]we like to honor many other internet sites on the web, even if they aren’t linked to us, by linking to them. Under are some webpages worth checking out[...]……
Bad Credit car Lease
on February 16 2012
Gems form the internet…
[...]very few websites that happen to be detailed below, from our point of view are undoubtedly well worth checking out[...]……
fashion blog
on February 17 2012
Related……
[...]just beneath, are numerous totally not related sites to ours, however, they are surely worth going over[...]……
Resell SEO
on February 17 2012
Websites we think you should visit…
[...]although websites we backlink to below are considerably not related to ours, we feel they are actually worth a go through, so have a look[...]……
home workout routines
on February 17 2012
Sources…
[...]check below, are some totally unrelated websites to ours, however, they are most trustworthy sources that we use[...]……
make up bag
on February 17 2012
Websites we think you should visit…
[...]although websites we backlink to below are considerably not related to ours, we feel they are actually worth a go through, so have a look[...]……
best value airsoft guns
on February 17 2012
Cool sites…
[...]we came across a cool site that you might enjoy. Take a look if you want[...]……
Relationship
on February 17 2012
Awesome website…
[...]the time to read or visit the content or sites we have linked to below the[...]……
Hassan Pullara
on February 17 2012
sopa news…
[...]As soon while you recognize that you will be late, you rush regarding the door, just take your existing wallet, cell [...]…
Sell website
on February 17 2012
Read was interesting, stay in touch……
[...]please visit the sites we follow, including this one, as it represents our picks from the web[...]……
Cleta Komer
on February 17 2012
Awesome website…
[...]the time to read or visit the content or sites we have linked to below the[...]……
boston area plumber
on February 17 2012
Visitor recommendations…
[...]one of our visitors recently recommended the following website[...]……
pensis stretcher
on February 17 2012
Trackback…
[...]just below, are various completely unrelated sites to ours, however, they are absolutely worth looking over[...]…
dental crown
on February 17 2012
Recent Blogroll Additions……
[...]usually posts some very interesting stuff like this. If you’re new to this site[...]……
http://earth4energy-myreview.com
on February 17 2012
Great website…
[...]we like to honor many other internet sites on the web, even if they aren’t linked to us, by linking to them. Under are some webpages worth checking out[...]……
compound microscope history
on February 17 2012
Gems form the internet…
[...]very few websites that happen to be detailed below, from our point of view are undoubtedly well worth checking out[...]……
custom woodworking business
on February 17 2012
Websites you should visit…
[...]below you’ll find the link to some sites that we think you should visit[...]……
Exercises To Burn Belly Fat
on February 17 2012
You should check this out…
[...] Wonderful story, reckoned we could combine a few unrelated data, nevertheless really worth taking a look, whoa did one learn about Mid East has got more problerms as well [...]……
wedding favors
on February 17 2012
Great website…
[...]we like to honor many other internet sites on the web, even if they aren’t linked to us, by linking to them. Under are some webpages worth checking out[...]……
fish oil supplements
on February 17 2012
Recent Blogroll Additions……
[...]usually posts some very interesting stuff like this. If you’re new to this site[...]……
Africa Honeymoon Destinations
on February 17 2012
Recommeneded websites…
[...]Here are some of the sites we recommend for our visitors[...]……
Ahh Bra
on February 17 2012
Great website…
[...]we like to honor many other internet sites on the web, even if they aren’t linked to us, by linking to them. Under are some webpages worth checking out[...]……
Lipotonix Plus
on February 17 2012
Sites we Like……
[...] Every once in a while we choose blogs that we read. Listed below are the latest sites that we choose [...]……
john vespucci
on February 17 2012
Links…
[...]Sites of interest we have a link to[...]……
how to make your breasts bigger
on February 21 2012
Trackback…
[...]here are some links to some sites that we think you should visit[...]…
ROV Courses
on February 21 2012
Directions…
Here are some actions I should keep in mind….
facebook of sex
on February 22 2012
dating usa…
Hello, i believe that i noticed you visited my weblog so i got here to ๏ฟฝgo back the desire๏ฟฝ.I’m attempting to find things to enhance my website!I guess its adequate to use a few of your ideas!!…
Iodoform packing strip
on February 22 2012
extended medical supplies…
[...]look at the content or websites we have linked to below[...]…
?嗉頃
on February 26 2012
Cool notebook from asia, fun ppl around the world !…
[...]blow are some sites that we think it will be worth your time[...]…