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
| <?php
try{
$bdd = new PDO('mysql:host=localhost;dbname=emda', 'root', '');
}
catch(Exception $e){
die('Erreur : '.$e->getMessage());
}
$reponse = $bdd->query('SELECT * FROM news, musique, video ORDER BY id DESC') or die(print_r($bdd->errorInfo()));
while ($data = $reponse->fetch()) {?>
<div class="contenu_onglet" id="contenu_onglet_drop">
<h1>Drop</h1>
<div class="drop">
<h2 class="titre"><?php echo $data['titre'] ?></h2>
<center><p class="contenu"><?php echo $data['contenu']?></p></center>
</div>
</div>
<div class="contenu_onglet" id="contenu_onglet_mix">
<h1>Mix</h1></br>
<div class="mix">
<h2 class="titre_m"><?php echo $data['titre_m']; ?></h2>
<em class="artiste"><?php echo $data['artiste']; ?></em></br>
<audio class="musique" src="<?php echo $data['lien']; ?>" controls></audio>
</div>
</div>
<div class="contenu_onglet" id="contenu_onglet_video">
<h1>Vidéo</h1>
<?php echo $data['lien_v'] ?>
</div>
<div class="contenu_onglet" id="contenu_onglet_special"><h1>Spéciale</h1></div>
<?php } ?> |
Partager