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
33
34
35
36
37
| <?require'prive/configuration.php';
echo"
<html>
<head>
<meta http-equiv=\"refresh\" content=\"$duree_rafraichissement\">
<link type=text/css href=style.css rel=stylesheet>
</head>
<body>";
$lapagemagik .= "<?xml version=\"1.0\" encoding=\"UTF-8\"?>" . "\n";
//$lapagemagik .= "<rss version=\"2.0\">" . "\n";
$lapagemagik .= "<textMain>" . "\n";
$lapagemagik .= "<options>".$scroll." ".$style."</options>" . "\n";
$lapagemagik .= "<textList>" . "\n";
$db = mysql_connect($hote, $login, $passe)
or die ("Connexion à la base de données impossible !");
mysql_select_db($base, $db);
$res=mysql_query("select * from $nom_de_la_table ORDER BY id DESC limit $Limitation");
while ($lapagemagik2=mysql_fetch_array($res)){
$madate=$lapagemagik2[date];// = la date de la news
$description=$lapagemagik2[news];// = le texte de la news
$lapagemagik .= "<item>" . "\n";
$lapagemagik .= "<textBody><![CDATA[".$madate." <br> ".$description." <br><br>]]></textBody>" . "\n";
$lapagemagik .= "</item>" . "\n";}
$lapagemagik .= "</textList>" . "\n";
$lapagemagik .= "</textMain>" . "\n";
//$lapagemagik .= "</rss>" . "\n";
$fp = fopen("$nom_du_flux.xml", 'w+');
fputs($fp, $lapagemagik);
fclose($fp);
echo"fichier XML créé ! <img src=xml.gif align=absmiddle><br>
<a href=$nom_du_flux.xml><font color=00ff00>Voir le fichier</a><br>
<a href=index.htm><font color=00ff00>Retour à l'accueil</a>";
mysql_close();
?>
</body>
</html> |
