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
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
|
<table class="tabletournee" id="myTable">
<?php
try
{
$bdd = new PDO('mysql:host=localhost;dbname=medrano2017;charset=utf8', 'root', '');
$bdd->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
}
catch(Exception $e)
{
die('Erreur : '.$e->getMessage());
}
$reponse = $bdd->query('SELECT id_event,
id_tournee,
evenement.ville_event AS ville,
evenement.lien_resa_event AS lienresa,
evenement.adresse_event AS adresse,
tournee.description_tournee AS descriptiontournee,
tournee.nom_tournee AS nomtournee,
(SELECT MIN(s.dateheure_seance) FROM seance s WHERE s.id_event = evenement.id_event) AS premiereSeance,
(SELECT MAX(s.dateheure_seance) FROM seance s WHERE s.id_event = evenement.id_event) AS derniereSeance
FROM tournee
JOIN evenement USING(id_tournee)
ORDER BY premiereSeance,derniereSeance');
$compteur =0;
$datecourante = date('Y-m-d H:i:s');
while ($donnees = $reponse->fetch())
{
setlocale(LC_ALL, 'French', 'fr-FR.utf8','fra', 'fr-FR', 'fr_FR', 'fr', 'fr_FR@euro');
$datedebut = strftime("%d %B", strtotime($donnees['premiereSeance']));
$datefin = strftime("%d %B %Y", strtotime($donnees['derniereSeance']));
$reponse1 = $bdd->query("SELECT dateheure_seance AS seances FROM seance s WHERE s.id_event = '".$donnees['id_event']."'");
if( $donnees['derniereSeance'] >= $datecourante )
{
?>
<tr class="infotournee infotournee<?php echo ($compteur%2); $compteur++; ?>">
<td id="event<?php echo $donnees['id_event']; ?>"><p style="color:white;" class="villetournee"><?php echo ''.$donnees['ville'].'';?></p> <p class="nomtournee"><?php echo ''.$donnees['nomtournee'].'';?></p></td>
<td><?php echo (strpos($datedebut,' '.$datefin))? 'Le '.utf8_encode($datedebut) : 'Du '.utf8_encode($datedebut).'<br/>au '.utf8_encode($datefin); ?></td>
<td><?php echo ''.$donnees['adresse'].'';?></td>
<td><a href="#spoiler<?php echo $donnees['id_event']; ?>" class="spoiler-link lienresa">PLUS D'INFOS</a><a class="lienresa" href="#">RESERVER</a></td>
</tr>
<tr>
<td colspan="4">
<div class="spoilers">
<div class="spoiler" id="spoiler<?php echo $donnees['id_event']; ?>">
<p>
<?php
$dates=array();
while ($donnees1 = $reponse1->fetch(PDO::FETCH_ASSOC)){
$timeStringDate=strtotime($donnees1['seances']);
$dt=strftime(date ('l d F',$timeStringDate));
if(!array_key_exists($dt, $dates)){
$dates[$dt]=array();
}
$dates[$dt][]=date ('H\hi',$timeStringDate);
}
$reponse1->closeCursor();
foreach ($dates as $day => $hours) {
echo $day . " à ";
$last="";
if(count($hours)>1){
$last=" et ".array_pop($hours).".";
}
echo join(", ",$hours).$last."<br>";
}
?>
</p>
</div>
</div>
</td>
</tr>
<?php
}
}
$reponse->closeCursor();
?>
</table> |
