1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32
|
connect(); //Connection à la BDD
$requete = 'SELECT * FROM videos ORDER BY id DESC LIMIT 10' ; //Recupere la derniere video
$resultat = mysql_query($requete) or die(mysql_error()); // Exécution de la requête.
header("Content-Type: text/xml; charset=ISO-8859-1");
echo '<?xml version="1.0" encoding="ISO-8859-1"?>
<rss version="2.0" xmlns:media="http://search.yahoo.com/mrss/" xmlns:jwplayer="http://developer.longtailvideo.com/trac/wiki/FlashFormats">
<channel>
<title>Vidéothéque</title>
<link></link>'."\n";
while (list($id,$nom,$description,$temps,$debut,$dateSaisie,$lienVideo,$lienPhoto,$categorie,$enUne) = mysql_fetch_row($resultat))
{
echo '
<item>
<title>'.$nom.'</title>
<description>'.$description.'</description>
<media:group>
<media:content url="'.$lienVideo.'" type="video/x-flv"'.' duration="'.$temps.'" start="'.$debut.'" />
<media:thumbnail url="'.$lienPhoto.'" type="image/png" />
</media:group>
</item>'."\n";
}
echo '</channel>
</rss>';
mysql_close(); |
Partager