|
| |
Agenda 2005
Agenda de l'UFF
<%
function mois($intMois)
{
switch($intMois)
{
case 1: return("janvier");break;
case 2: return("février");break;
case 3: return("mars");break;
case 4: return("avril");break;
case 5: return("mai");break;
case 6: return("juin");break;
case 7: return("juillet");break;
case 8: return("août");break;
case 9: return("septembre");break;
case 10: return("octobre");break;
case 11: return("novembre");break;
case 12: return("décembre");break;
}
}
// affichage du calendrier
require_once('util_db.php');
require_once('util_fonc.php');
$db=new Database;
// ouverture de la base de données
$link=$db->OpenDatabase();
// recherche du dernier numéro
$strRequete=sprintf("SELECT * FROM `agenda_national` ORDER BY DATE");
$result=mysql_query($strRequete, $link);
// on parle en français
if($result!=FALSE)
{
$row = mysql_fetch_row($result);
while($row!=FALSE)
{
list($NATURE,$DATE,$LIEU,$COMMENTAIRE,$ID) = $row;
// date au format yyyy-mm-dd
$currentMonth=substr($DATE,5,2);
$currentDay=substr($DATE,8,2);
$currentYear=substr($DATE,0,4);
$timeStamp=mktime(0,0,0,$currentMonth,$currentDay,$currentYear);
printf("");
printf("| %d | ", $currentDay);
printf("%s | ", mois($currentMonth));
printf("%s | ", $NATURE);
printf("%s | ", $LIEU);
if($COMMENTAIRE!="")
{
printf("détails | ",$ID,"agenda_national");
}
else
{
printf(" | ");
}
printf(" ");
// on ajoute l'évènement
$oldMonth=$currentMonth;
$oldYear=$currentYear;
$row = mysql_fetch_row($result);
}
}
else
{
}
%>
<%
// affichage du calendrier
require_once('util_db.php');
require_once('util_fonc.php');
$db=new Database;
// ouverture de la base de données
$link=$db->OpenDatabase();
// recherche du dernier numéro
$strRequete=sprintf("SELECT * FROM `agenda_region` ORDER BY DATE_MANIFESTATION");
$result=mysql_query($strRequete, $link);
if($result!=FALSE)
{
$row = mysql_fetch_row($result);
while($row!=FALSE)
{
list($NOM_ORGANISATEUR,$TYPE_MANIFESTATION,$DESCRIPTION_MANIF,$IDCONTACT,$DATE_MANIFESTATION,$IDREGION,$PUBLIC_CONCERNE,$INTERVENANTS,$OBJECTIF,$COMMENTAIRE,$LIEU,$ID)=$row;
// date au format yyyy-mm-dd
$currentMonth=substr($DATE_MANIFESTATION,5,2);
$currentDay=substr($DATE_MANIFESTATION,8,2);
$currentYear=substr($DATE_MANIFESTATION,0,4);
printf("");
printf("| %d | ", $currentDay);
printf("%s | ", mois($currentMonth));
printf("%s | ", $DESCRIPTION_MANIF);
printf("%s | ", $LIEU);
printf("%s | ", $NOM_ORGANISATEUR);
if($COMMENTAIRE!="")
{
printf("détails | ",$ID,"agenda_region");
}
else
{
printf(" | ");
}
printf(" ");
$oldMonth=$currentMonth;
$oldYear=$currentYear;
$row = mysql_fetch_row($result);
}
}
%>
|