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 48 49 50 51 52 53 54 55 56
| <?php
$date = strtotime('01/01/2011');
$j = date('j',$date);
$m = date('m',$date);
$y = date('Y',$date);
$jour = date('w',$date);
$tab = array();
$week = date('W',$date)-date('W',strtotime($y.'-'.$m.'-01'));
$nbDaysMonth = cal_days_in_month(CAL_GREGORIAN, $m, $y);
for ($i = $j; $i <= $nbDaysMonth;$i++) {
$tab[$week][$jour] = $i;
$jour++;
if ($jour%7 == 0) {
$week++;
$jour=0;
}
}
mysql_connect('localhost', 'root', '') or die (mysql_error ());
mysql_select_db('uia_tarek') or die ("Erreur de connexion à uia_tarek");
$req = "SELECT jour FROM jours_feries WHERE jour LIKE '%/$y'";echo $req;
$res = mysql_query($req);
$feries = mysql_fetch_assoc($res);
print_r($feries);
//print_r ($tab);
?>
<html>
<head>
</head>
<body>
<table>
<tr>
<th>L</th>
<th>M</th>
<th>M</th>
<th>J</th>
<th>V</th>
<th>S</th>
<th>D</th>
</tr>
<?php
for ($a = 0; $a <= 5; $a++) {
echo '<tr>';
for ($b = 0; $b <= 6; $b++) {
echo '<td>';
if (isset($tab[$a][$b]) AND !in_array($tab[$a][$b],$feries)) echo $tab[$a][$b];
echo '</td>';
}
echo '</tr>';
}?>
</table>
</body>
</html> |
Partager