$vw){ foreach($vw as $vDay){ if(!empty($vDay)){ $tabDate[]=$vDay; } } } if(isset($_GET['filtreCarte']) && !empty($_GET['filtreCarte']) && in_array($_GET['filtreCarte'],$tabDate)){ $current_date=$_GET['filtreCarte']; }else $current_date='all'; $query="select * from eta where lat!='' and lon!=''"; $db = connect_base(); $queryRequest = $db->prepare( $query ); $queryRequest->execute(); $data=$queryRequest->fetchAll(); $info=array(); foreach($data as $cle=>$val){ $query="select * from capitaines where num_eta=:num_eta"; $db = connect_base(); $queryRequest = $db->prepare( $query ); $queryRequest->bindParam( ':num_eta', $val['id_eta'], PDO::PARAM_INT ); $queryRequest->execute(); if($queryRequest->rowCount()>0){; $info[$val['id_eta']]['nom']=decrypter($maCleDeCryptage,$val['nom_eta']); $info[$val['id_eta']]['adresse']=decrypter($maCleDeCryptage,$val['adresse1']); $info[$val['id_eta']]['cp']=decrypter($maCleDeCryptage,$val['cp']); $info[$val['id_eta']]['ville']=decrypter($maCleDeCryptage,$val['ville']); $info[$val['id_eta']]['lat']=$val['lat']; $info[$val['id_eta']]['lon']=$val['lon']; foreach($arrWeek as $kw=>$vw){ foreach($vw as $vDay){ if(!empty($vDay)){ $info[$val['id_eta']][$vDay] = 0; } } } } } $query="select * from agenda where statut='libre'"; $db = connect_base(); $queryRequest = $db->prepare( $query ); $queryRequest->execute(); $data=$queryRequest->fetchAll(); foreach($data as $cle=>$val){ $info[$val['numEta']][$val['jour']]++; } foreach($info as $cle=>$val){ foreach($arrWeek as $kw=>$vw){ foreach($vw as $vDay){ if(!empty($vDay)){ if($val[$vDay]>0) $info[$cle]['all']=1; } } } if(!isset($info[$cle]['all'])) $info[$cle]['all']=0; } ?> FAFIH
Métiers Hotel-Resto

UNE JOURNÉE NATIONALE POUR DÉCOUVRIR un métier et se préparer un avenir
Filtrer sur une date :