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
|
$date=$_SESSION['availability_annee'].'-'.$_SESSION['availability_mois'].'-'.$dates;
if(!empty($_SESSION['availability_mois']) AND !empty($_SESSION['availability_annee'])){
#Si $dates est plus grand que START mais pas plus grand que END
$select_availability = 'SELECT * FROM holiday WHERE "'.$date.'" >= start AND end >= "'.$date.'"';
$query_availability = mysql_query($select_availability) or die('Erreur SQL : <br>'.$select_availability.'<br>'.mysql_error());
/*$nb_availability = mysql_num_rows($query_availability);
if ($nb_availability < 1) {
$nb_availability=0;
}
*/
while($result_availability=mysql_fetch_array($query_availability)){
$qui = ucfirst(strtok($result_availability['who'],"."));
$approuved = $result_availability['statut'];
$reason = $result_availability['reason'];
$start = $result_availability['start'];
if($approuved=="approved"){
$qui='<b><font color="green">'.$qui.'</font></b>';
}else if($approuved=="pending"){
$qui='<b><font color="orange">'.$qui.'</font></b>';
}else{
$qui='<b><font color="red">'.$qui.'</font></b>';
}
echo $qui.'<br>';
}
} |
Partager