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
| <?php
$mois = 2;
$annee = 2011;
$njours = date('t', mktime(0,0,0,$mois, 1, $annee));
// on recupère les événements dans la base
$result = mysql_query("SELECT id, evenement, date_evenement FROM ta_table WHERE MONTH(date_evenement) = " . $mois . " AND YEAR(date_evenement) = " . $annee;
while ($row = mysql_fetch_assoc($result) {
$tblEvenement[$row['date_evenement']][$row['id']] = $row['evenement'];
}
// on construit le calendrier
echo '<table border="1">
<tr>';
for ($j = 1; $j < $njours; $j++) {
$date = $annee . '-' . sprintf("%02d",$mois) . '-' . sprintf("%02d",$j);
echo '<td>' . $date;
if (isset($tblEvenement[$date])) {
foreach($tblEvenement[$date] as $id=>$evenement) {
echo '</br><a href="page.php?id=' . $id . '">' . $evenement . '</a>';
}
}
echo '</td>';
}
echo '</tr>
</table>';
?> |
Partager