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(); |
