Geckozone

Code : Tout sélectionner

<rdf:RDF xmlns:dc="http://purl.org/dc/elements/1.1/"
xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
xmlns="http://purl.org/rss/1.0/">

<?php 
require("connect_sql.php");

$tablename = "ma table";
$today = Date("Ymd");
?>
  
  <!-- Données concernant le site -->
  <channel rdf:about="http://www.pspliberte.com/greg/site_sdav/index.php">
    <title>SDAV</title>
    <link>http://www.pspliberte.com/greg/site_sdav/index.php</link>
    <description>Site de l'Audeivisuel de la Province de Namur</description>
    <dc:language>fr</dc:language>
	
    <!-- Début de la Table des matières -->
	<items>
       <rdf:Seq>
         <!-- URL de chaque article -->
	       
			<?php
			$sql = "SELECT * FROM $tablename WHERE publish = 0 AND (publi_start <= '$today' AND publi_end >= '$today') ORDER BY publi_start DESC, title ASC";
			$result = mysql_query($sql) or die("ERREUR: La requête n'est pas valide: ".mysql_error());

			while ($test = mysql_fetch_object($result)) {
				print('<rdf:li resource="index.php?fuseaction=accueil.news_content&newsid='.$test->id.'" />');
			}
			?>
			   
       </rdf:Seq>
    </items>
    <!-- Fin de la Table des matières -->
  </channel>
			
    <!-- Début des Articles -->
			<?php
			
			$sql = "SELECT * FROM $tablename WHERE publish = 0 AND (publi_start <= '$today' AND publi_end >= '$today') ORDER BY publi_start DESC, title ASC";
			$result = mysql_query($sql) or die("ERREUR: La requête n'est pas valide: ".mysql_error());

			while ($test = mysql_fetch_object($result)) {
				print('<item rdf:about="index.php?fuseaction=accueil.news_content&newsid='.$test->id.'">');
				print('<title>'.$test->id.'</title>');
				print('<link>index.php?fuseaction=accueil.news_content&newsid='.$test->id.'</link>');
				print('<description>'.$test->desc.'</description>');
				print('</item>');
			}
			?>
			
	<?php mysql_close(); ?>
	
</rdf:RDF>

Code : Tout sélectionner

header("Content-Type: application/xml");