- <?
- $dbhost = "VotreServeurMySQL";
- $dblogi = "VotreLogin";
- $dbpass = "VotrePassWord";
- $dbbase = "VotreBase";
-
- $db = @mysql_connect("$dbhost", "$dblogi", "$dbpass") OR DIE("Désolé, la Base est Down !");
- @mysql_select_db("$dbbase",$db) OR DIE;
-
- $query = "SELECT * FROM NOUVELLES ORDER BY DATENEWS DESC";
- $result = mysql_query ($query) or die("La requette a échouée : ".mysql_error());
- $nb_msg = mysql_num_rows($result);
-
- header("Content-Type: text/xml");
-
- $xml = '<'.'?xml version="1.0" encoding="UTF-8"?'.'><rss version="2.0"><channel>';
-
- $xml .='<title>Exemple de flux RSS en PHP</title>';
- $xml .='<link>http://www.phpcs.com</link>';
- $xml .='<description>Les dernières nouvelles</description>';
- $xml .='<managingEditor>adressemail@fournisseur.com</managingEditor>';
- $xml .='<language>fr</language>';
- $xml .='<generator>PHPCS</generator>';
- $xml .='<copyright>PHPCS</copyright>';
- $xml .='<webMaster>PHPCS Webmaster</webMaster>';
-
- while ($msg_data = mysql_fetch_array($result))
- {
- $id = $msg_data['ID'];
-
- $titre = $msg_data['AUTEUR']." - Nouvelle Du Site";
- $news = stripslashes(trim($msg_data['MESSAGE']));
- $news = str_replace("<BR>",'<BR/>',$news);
- $news = str_replace("&",'&',$news);
- $news = str_replace("<","<",$news);
- $news = str_replace(">",">",$news);
-
- $xml .='<item>';
- $xml .='<author>'.$msg_data['AUTEUR'].'</author>';
- $xml .='<title>'.$titre.'</title>';
- $xml .='<link>http://VotreSiteWeb/VotrePagedeLecture.php?ValeurID='.$id.'</link>';
- $xml .='<pubDate>'.$msg_data['DATENEWS'].' GMT</pubDate>';
- $xml .='<guid>http://VotreSiteWeb/VotrePagedeLecture.php?ValeurID='.$id.'</guid>';
- $xml .='<comments>http://VotreSiteWeb/VotrePagedeLecture.php?ValeurID='.$id.'</comments>';
- $xml .='<description>';
-
- $xml .= $news;
-
- $xml .='</description></item>';
- }
-
- mysql_close();
-
- $xml .='</channel></rss>';
-
- echo $xml;
-
- ?>
<?
$dbhost = "VotreServeurMySQL";
$dblogi = "VotreLogin";
$dbpass = "VotrePassWord";
$dbbase = "VotreBase";
$db = @mysql_connect("$dbhost", "$dblogi", "$dbpass") OR DIE("Désolé, la Base est Down !");
@mysql_select_db("$dbbase",$db) OR DIE;
$query = "SELECT * FROM NOUVELLES ORDER BY DATENEWS DESC";
$result = mysql_query ($query) or die("La requette a échouée : ".mysql_error());
$nb_msg = mysql_num_rows($result);
header("Content-Type: text/xml");
$xml = '<'.'?xml version="1.0" encoding="UTF-8"?'.'><rss version="2.0"><channel>';
$xml .='<title>Exemple de flux RSS en PHP</title>';
$xml .='<link>http://www.phpcs.com</link>';
$xml .='<description>Les dernières nouvelles</description>';
$xml .='<managingEditor>adressemail@fournisseur.com</managingEditor>';
$xml .='<language>fr</language>';
$xml .='<generator>PHPCS</generator>';
$xml .='<copyright>PHPCS</copyright>';
$xml .='<webMaster>PHPCS Webmaster</webMaster>';
while ($msg_data = mysql_fetch_array($result))
{
$id = $msg_data['ID'];
$titre = $msg_data['AUTEUR']." - Nouvelle Du Site";
$news = stripslashes(trim($msg_data['MESSAGE']));
$news = str_replace("<BR>",'<BR/>',$news);
$news = str_replace("&",'&',$news);
$news = str_replace("<","<",$news);
$news = str_replace(">",">",$news);
$xml .='<item>';
$xml .='<author>'.$msg_data['AUTEUR'].'</author>';
$xml .='<title>'.$titre.'</title>';
$xml .='<link>http://VotreSiteWeb/VotrePagedeLecture.php?ValeurID='.$id.'</link>';
$xml .='<pubDate>'.$msg_data['DATENEWS'].' GMT</pubDate>';
$xml .='<guid>http://VotreSiteWeb/VotrePagedeLecture.php?ValeurID='.$id.'</guid>';
$xml .='<comments>http://VotreSiteWeb/VotrePagedeLecture.php?ValeurID='.$id.'</comments>';
$xml .='<description>';
$xml .= $news;
$xml .='</description></item>';
}
mysql_close();
$xml .='</channel></rss>';
echo $xml;
?>