| New file |
|---|
| 0,0 → 1,64 |
|---|
| <?php |
| |
| include("connect.php"); |
| |
| |
| $rss = "<?xml version=\"1.0\" encoding=\"iso-8859-1\"?> \n"; |
| $rss .= "<rss version=\"0.91\" xmlns:dc=\"http://purl.org/dc/elements/1.1/\">\n"; |
| $rss .=' |
| <channel> |
| <title>Observatoire des saisons</title> |
| <link>http://www.obs-saisons.fr</link> |
| <description>Observatoire des saisons</description> |
| <language>fr</language>'; |
| |
| |
| $query = "select distinct MESURE.SEQUENCE_ID, MESURE.MESURE_ID, ". |
| "EXTRACT(YEAR from MESURE_DATE), ". |
| "DATE_FORMAT(MESURE_DATE,'%d/%m/%Y') AS DATE_MESURE, EVENEMENT_NOM, NULL, ". |
| "ESPECE_NOM_SCIENTIFIQUE, ESPECE_NOM_VERNACULAIRE, STATION_NOM, STATION_LATITUDE, ". |
| "STATION_LONGITUDE, STATION_ALTITUDE, ENVIRONNEMENT_NOM, ". |
| "SEQUENCE.PARTICIPANT_ID, PARTICIPANT_NOM, PARTICIPANT_PSEUDO ". |
| "from MESURE, SEQUENCE, EVENEMENT, ESPECE, STATION, ENVIRONNEMENT, PARTICIPANT ". |
| "where MESURE.SEQUENCE_ID=SEQUENCE.SEQUENCE_ID ". |
| "and SEQUENCE.ESPECE_ID=ESPECE.ESPECE_ID ". |
| "and MESURE.EVENEMENT_ID=EVENEMENT.EVENEMENT_ID ". |
| "and STATION.STATION_ID=SEQUENCE.STATION_ID ". |
| "and PARTICIPANT.PARTICIPANT_ID=SEQUENCE.PARTICIPANT_ID ". |
| "and ENVIRONNEMENT.ENVIRONNEMENT_ID=SEQUENCE.ENVIRONNEMENT_ID ORDER BY MESURE_DATE DESC LIMIT 50"; |
| |
| |
| |
| |
| $res = mysql_query($query); |
| |
| |
| |
| while ($row =mysql_fetch_array($res)) { |
| $row['ESPECE_NOM_SCIENTIFIQUE'] = htmlspecialchars($row['ESPECE_NOM_SCIENTIFIQUE']); |
| $row['ESPECE_NOM_VERNACULAIRE'] = htmlspecialchars($row['ESPECE_NOM_VERNACULAIRE']); |
| $row['DATE_MESURE'] = htmlspecialchars($row['DATE_MESURE']); |
| $row['PARTICIPANT_PSEUDO'] = htmlspecialchars($row['PARTICIPANT_PSEUDO']); |
| $row['STATION_NOM'] = htmlspecialchars($row['STATION_NOM']); |
| |
| $rss.= ' <item> |
| <title>'.$row['ESPECE_NOM_VERNACULAIRE'] . ' par ' . $row['PARTICIPANT_PSEUDO'].'</title> |
| <author>'.$row['PARTICIPANT_PSEUDO'].'</author> |
| <link>http://www.obs-saisons.fr/</link> |
| <description>'.$row['ESPECE_NOM_VERNACULAIRE'] . ' saisi le ' .$row['DATE_MESURE'] . ' par ' . $row['PARTICIPANT_PSEUDO'] ." observe à " . $row['STATION_NOM'] . |
| '</description> |
| <dc:format>text/html</dc:format> |
| </item>'; |
| |
| |
| |
| } |
| |
| $rss.= '</channel> </rss>'; |
| |
| |
| header("Content-Type: text/xml; charset=ISO-8859-1"); |
| print $rss; |
| exit; |
| |
| ?> |