je voudrais créer un flux rss dinamique pour mon album de photo en ligne (mg2).
J'ai trouvé ce tuto sur le web mais je suis un peu perdu...si quelqu'un peut m'aider...
merci
- Code: Tout sélectionner
<?php
header ("Content-type: text/xml");
echo ("<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n");
?>
<rss version='2.0'>
<channel>
<title>arnauld en Chine</title>
<description>mes photos</description>
<link>http://www.arnauld.fr/rss.php</link>
<language>en-us</language>
<?php
$db_host = "localhost";
$db_name = "mg2db-idatabase.php"; //database name
$db_user = "arnob"; //database user
$db_pass = "..."; //user password
$db_connection = @mysql_pconnect($db_host,$db_user,$db_pass) or die("Sorry, cannot connect to database.");
@mysql_select_db($db_name,$db_connection) or die(dbdown());
$result = mysql_query ("SELECT * FROM `%%TABLE%%` ORDER BY `id` DESC LIMIT 0,10 ") or die (mysql_error());
while ($row = mysql_fetch_array ($result)) {
$desc = $row[2];
$desc = str_replace("\n","<br />",$desc);
echo (" <item>
<title>");
echo $row[1];
echo ("</title>
<description>");
echo $desc; //content you want the person to read
echo ("</description>
<link>http://yoursite.com/index.php?article=");
echo $row[0];
echo ("</link>
</item>\n\n");
}
mysql_free_result ($result);
?>
</channel>
</rss>