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
| <?php
try
{
$bdd = new PDO('mysql:host=host;dbname=bdd', 'user', 'pass');
}
catch (Exception $e)
{
die('Erreur : ' . $e->getMessage());
}
$reponse = $bdd->query('SELECT id, pseudo FROM users ');
while($donnees = $reponse->fetch()) {
$idpseudo = $donnees['id_pseudo'];
$reponse2 = $bdd->query("SELECT id_tag FROM `like` WHERE id_pseudo = '.$idpseudo.'");
while($likes = $reponse2->fetch()) {
$idtag = $likes['id_tag'];
$reponse3 = $bdd->query("SELECT nom FROM tags WHERE id = '.$idtag.' ");
while($tags = $reponse3->fetch()) {
?>
<p>Id : <?php echo $donnees['id']; ?> Pseudo : <?php echo $donnees['pseudo']; ?> Tag : <?php echo $tags['nom']; ?></p>
<?php
}
}
}
?> |
