-
Notifications
You must be signed in to change notification settings - Fork 0
/
programmation.php
34 lines (28 loc) · 1.3 KB
/
programmation.php
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
<?php
try
{
$vendredi = $bdd->prepare('SELECT id, nom, genre, pays, image FROM artistes WHERE vendredi=1 ORDER BY id');
$samedi = $bdd->prepare('SELECT id, nom, genre, pays, image FROM artistes WHERE samedi=1 ORDER BY id');
$dimanche = $bdd->prepare('SELECT id, nom, genre, pays, image FROM artistes WHERE dimanche=1 ORDER BY id');
echo ' <h3>Programmation</h3>
<h4>Vendredi</h4>';
$vendredi->execute();
foreach($vendredi->fetchAll() as $donnees)
setArtiste($donnees['nom'],$donnees['genre'],$donnees['pays'],'artistes',$donnees['id'], $donnees['image']);
$vendredi->closeCursor();
echo '<h4>Samedi</h4>';
$samedi->execute();
foreach($samedi->fetchAll() as $donnees)
setArtiste($donnees['nom'],$donnees['genre'],$donnees['pays'],'artistes',$donnees['id'], $donnees['image']);
$samedi->closeCursor();
echo '<h4>Dimanche</h4>';
$dimanche->execute();
foreach($dimanche->fetchAll() as $donnees)
setArtiste($donnees['nom'],$donnees['genre'],$donnees['pays'],'artistes',$donnees['id'], $donnees['image']);
$dimanche->closeCursor();
}
catch(Exception $e)
{
error($e);
}
?>