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
| <?php //trouver le premier jour de la semaine
$todayis = date("j", mktime(0, 0, 0, date("m"), date("d"), date("Y")));
$day = date("w", mktime(0, 0, 0, date("m"), 1, date("Y"))); $col=0;
$daynum = 1;
$daypermonth = date("j", mktime(0, 0, 0, date("m")+1, 0, date("Y")));
$nextdate = 0;
while($col<$day) {
printf("<td><div align=\"center\" class=\"calendrier_jour\"></div></td>\n");
$col++;
}
while($daynum<=$daypermonth) {
if ($col>6) {
$col = 0;
echo "</tr>"; /* fin de la ligne précédente */
echo "<tr height='68'>"; /* nouvelle ligne */
}
printf("<td><div align=\"center\" class=\"calendrier_jour\">");
$jour = sprintf("%02d", $daynum);
$date = date("Y-m-d", strtotime(date("Y-m-").$jour));
mysql_select_db($database_planning, $planning);
$sql = "SELECT * FROM calendrier WHERE date >= '".$date." 00:00:00' AND date <= '".$date." 23:59:59'";
$q = mysql_query($sql, $planning) or die(mysql_error());
if(mysql_num_rows($q) > 0) {
echo "Il y a ".mysql_num_rows($q)." évènement(s), le(s) voici : <br />";
while ($r = mysql_fetch_assoc($q)) {
echo $r['nom_dun_de_tes_champs']; // Nom du champ dont tu souhaites afficher la valeur
}
} else {
printf ("%02d", $daynum);
}
echo $daynum;
printf("</div></td>\n");
$daynum++;
$col++;
}
echo "<td colspan=".(7-$col)."></td></tr>";
?> |
Partager