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
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
|
<?php
include("../commun/params.inc.php");
$IdAd="";
$IdBat="";
$cid="";
$IdAdm="";
$retour="";
$requete="";
$IdBatiment="";
$enreg="";
$champs="";
$valeur="";
$Nom="";
$Prenom="";
$Mail="";
$TelFixe="";
$TelMobile="";
$NomProp="";
$PrenomProp="";
$AccessCompteurs="";
$Numero="";
$Voie="";
$TypeVoie="";
if(isset($_POST["IdAdm"])){
$IdAdm=$_POST["IdAdm"];
$cid=mysql_connect(MYSQL_SERVER,MYSQL_LOGIN,MYSQL_PASSWORD) or die(mysql_error());
mysql_select_db(MYSQL_DATABASE,$cid) or die(mysql_error());
// extraction des données du locataire et du bâtiment
$requete="select a.IdBat as IdBat,a.IdAdm as IdAdm,a.TelFixe as TelFixe,a.TelMobile as TelMobile,a.Mail as Mail,
b.Numero as Numero,b.AccesCompteurs as AccessCompteurs,
v.Voie as Voie,
t.TypeVoie as TypeVoie
from TAdministres as a,TBatiments as b,TVoies as v,TTypesVoie as t
WHERE b.IdBatiment=a.IdBat && v.IdVoie=b.IdVoie && t.IdTypeVoie=v.IdTypeVoie
&& IdAdm='$IdAdm';";
$retour=mysql_query($requete,$cid) or die(mysql_error());
$enreg=mysql_fetch_array($retour);
foreach($enreg as $champ=>$valeur)
$$champ=$valeur;
// extraction des données du propriétaire
$requete="select a.Nom as NomProp,a.Prenom as PrenomProp
from TAdministres as a,TBatiments as b
where a.IdAdm=b.IdProprietaire && b.IdBatiment='$IdBat'
;";
$retour=mysql_query($requete,$cid) or die(mysql_error());
$enreg=mysql_fetch_array($retour);
foreach($enreg as $champ=>$valeur)
$$champ=$valeur;
}
?>
<!DOCTYPE HTML>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Document sans titre</title>
<style type="text/css">
.calque {
font: 14px Verdana, Geneva, sans-serif;
color: #000;
-moz- background-color:rgba(255,255,235,0.8);
-moz- border-radius:10px;
-moz-border-radius:10px;
-moz-box-shadow: 10px 10px 8px rgba(0,0,0,0.2);
-moz-box-shadow: 10px 10px 8px rgba(0,0,0,0.2);
border-style:solid;
border-width:1px;
border-top-color:#d0d0d0;
border-left-color:#d0d0d0;
border-right-color:#606060;
border-bottom-color:#606060;
background: #CCC;
background: #CCC;
margin-right: auto;
margin-left: auto;
width: 400px;
position:relative;
}
#form1{
top:50px;
}
#affichage{
top:100px;
}
</style>
<script type="text/javascript">
function traitement(){
if(document.getElementById("IdAdm").value!="")
document.forms["f1"].submit();
else
alert("Choisissez d'abord une fiche");
}
</script>
</head>
<body>
<div id="menu"></div>
<div id="form1" class="calque">
<form action="requeteAdresse.php" method="post" enctype="multipart/form-data" name="f1" id="f1">
<label>
<div align="center">fiche recherchée </div>
</label>
<br>
<br>
<div align="center">
<select id="IdAdm" name="IdAdm" onchange="javascript:traitement();">
<option value="">Choisissez une personne</option>
<?php
$cid=mysql_connect(MYSQL_SERVER,MYSQL_LOGIN,MYSQL_PASSWORD) or die(mysql_error());
mysql_select_db(MYSQL_DATABASE,$cid) or die(mysql_error());
$requete="select IdAdm,Nom,Prenom FROM TAdministres order by Nom,Prenom;";
$retouradm=mysql_query($requete,$cid);
mysql_close($cid);
while($enreg=mysql_fetch_array($retouradm)){
foreach($enreg as $champ=>$valeur)
$$champ=$valeur;
echo "<option value='$IdAdm'>$Nom $Prenom</option>";
}
?>
</select>
</div>
<br>
<br>
</div>
</form>
</div>
<div class="calque" id="affichage">
Adresse : <?php echo "$Numero $TypeVoie $Voie";?>
<br>
Mail : <?php echo "$Mail";?>
<br>
Fixe : <?php echo "$TelFixe";?>
<br>
Portable : <?php echo "$TelMobile";?>
<br>
Accés compteurs : <?php echo ($AccessCompteurs)?"Public":"Prive";?>
<br>
Propriétaire : <?php echo "$NomProp $PrenomProp";?>
<br>
</div>
</body>
</html> |
