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 38 39 40 41 42 43 44 45 46 47
|
<div id="cal"><h1>< Janvier 08 ></h1></div>
<div id="event">
<?php
$cnx = mysql_connect(SERVEUR, USER, PASS, DB) ;
$db = mysql_select_db(DB) ;
$sql = "SELECT rdv.id_rdv,
rdv.ville,
rdv.date,
rdv.lieu,
rdv.titre,
rdv.cie,
rdv.genre
FROM rdv
WHERE date >= '2008-01-01' AND date <= '2008-01-31'
ORDER BY rdv.date desc" ;
$requete = mysql_query( $sql, $cnx ) ;
while( $result = mysql_fetch_object( $requete ) )
{
echo("<h2>A ".$result->ville."</h2>\n") ;
$date = "$result->date";
$prefix = "Le ";
$suffix = " à";
$tab_month = array(1=>"janvier", "fevrier", "mars", "avril", "mai", "juin", "juillet", "aout", "septembre", "octobre", "novembre", "decembre");
$tab_day = array("dimanche", "lundi", "mardi", "mercredi", "jeudi", "vendredi", "Samedi");
$tab_date = explode(' ', $date);
$date_hour = explode(':', $tab_date[1]);
$tab_dmy = explode('-', $tab_date[0]);
$day = date("w", mktime(0, 0, 0, $tab_dmy[1], $tab_dmy[2], $tab_dmy[0]));
$date = $prefix . "$tab_day[$day] " . "$tab_dmy[2] ";
settype($tab_dmy[1], integer);
$date .= $tab_month[$tab_dmy[1]] ;
echo("$date<br />\n") ;
echo("<span class=\"ital\">- ".$result->lieu."</span><br />\n") ;
echo("<h1>> ".$result->titre."</h1>\n") ;
echo("<p class=\"evchapo\">".$result->cie."<br />".$result->genre."<a class=\"affsavoir\" href=\"rdv_plus.php?idRdv=".$result->id_rdv."\">En savoir +</a></p>\n") ;
}
?>
</div>
</div> |
Partager