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
| <?PHP
include'function.php';
//requête SQL:
$annonce_sortie = $connection->prepare('SELECT * FROM annonce');
$annonce_sortie->execute(array());
while($result = $annonce_sortie->fetch(PDO::FETCH_OBJ)){
$idA = $result->idA;
$pseudo = $result->pseudo;
$sexe = $result->sexe;
$jours = $result->jours;
$annonce = $result->annonce;
}
$tab_choix = array();
$annonce_sortie_choix = $connection->prepare('SELECT * FROM choix_annonce WHERE idA=:idA AND jours=:jours');
$annonce_sortie_choix->execute(array('idA'=>$idA,'jours'=>$jours));
while($result_choix = $annonce_sortie_choix->fetch(PDO::FETCH_OBJ)){
$choix = $result_choix->choix;
$tab_choix = explode(',',$choix);
}
$profil = $connection->prepare('SELECT * FROM profil_photo WHERE id_gal=:id_gal');
$profil->execute(array(':id_gal'=>$pseudo));
while($results = $profil->fetch(PDO::FETCH_OBJ)){
$_image_profil = $results->gal;
}
echo'<div class="contenu_profil">
<div class="gauche_profil">';
miniature('image_profil/'.$_image_profil.'', 150, 100);
if(isset($_image_profil) == FALSE){
echo'<img src="images/no_photo.png" width="150" height="100" border="0" />';
}else{
echo'<img src="MINI11image_profil/'.$_image_profil.'" border="0" />';
}
echo'</div>';
?>
<table width="100%">
<tr>
<td style="text-align:left;"></td>
</tr>
<tr>
<td>
<div align="right">
<table width="60%">
<tr>
<td width="20%">Pseudo :</td>
<td width="80%"><?PHP echo $pseudo; ?></td>
</tr>
<tr>
<td>Recherche</td>
<td>
<?PHP
foreach($tab_choix as $choix)
echo '<b>'.$choix.'</b>';
?></td>
</tr>
<tr>
<td>Annonce</td>
<td><?PHP echo $annonce; ?></td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
</table>
</td>
</tr>
<tr>
<td>
boutton
</td>
</tr>
</table>
</div> |
