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
|
<?php
$hostname_telecom = "localhost";
$database_telecom = "suged";
$username_telecom = "root";
$password_telecom = "";
$telecom = mysql_connect($hostname_telecom, $username_telecom, $password_telecom) or die(mysql_error());
mysql_select_db($database_telecom ,$telecom) or die ('erreur de connexion base');
?>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<?php
//requête de travail
$requete="select déranger.référance déranger.observation abonné.nom abonné.prenom abonné.adresse position.téte position.amorcetéte Position.couleurtéte position.distribution position.amorcedist position.couleurdist from déranger A abonné B position C
where A.numtel=B.numtel and B.numtel=C.numtel ";
$resultat=mysql_query($requete) or die(mysql_error());
while ($row=mysql_fetch_row($resultat))
{
$nom=$row[0];
$prénom=$row[1];
$adresse=$row[2];
$référance=$row[3];
$observation=$row[5];
$téte=$row[6];
$amorcet=$row[7];
$couleurt=$row[8];
$distribution=$row[9];
$amorced=$row[10];
$couleurd=$row[11];
?>
<table width="85%" border="0">
<tr>
<td width="32%">Table Essai</td>
<td width="36%">Réferance drangement</td>
<td width="32%">kairouan le 05-Mar-2009</td>
</tr>
</table>
<table width="75%" border="0">
<tr>
<td><div align="center">N d'appel:</div></td>
</tr>
</table>
<p><span class="style2"><strong><font face="Comic Sans MS">Detail sur client
et type de dérangement</font></strong></span></p>
<table width="84%" border="0">
<tr>
<td width="61%" height="34">Nom et Prenom</td>
<td width="39%"><?php echo $nom ?></td>
</tr>
<tr>
<td height="39">Adresse</td>
<td><?php echo $adresse ?></td>
</tr>
<tr>
<td height="56">Position</td>
<td><table width="100%" border="0">
<tr>
<td>T</td>
<td>A</td>
<td>C</td>
<td>D</td>
<td>A</td>
<td>C</td>
</tr>
<tr>
<td><?php echo $téte ?></td>
<td><?php echo $amorcet ?></td>
<td><?php echo $couleurt ?></td>
<td><?php echo $distributon ?></td>
<td><?php echo $amorced ?></td>
<td><?php echo $couleurd ?></td>
</tr>
</table></td>
</tr>
<tr>
<td height="35">Date Reclamation</td>
<td> </td>
</tr>
<tr>
<td height="26">Signalé Par</td>
<td> </td>
</tr>
<tr>
<td height="27">Observation</td>
<td><?php echo $observation ?></td>
</tr>
<tr>
<td height="29">Responsable Essai</td>
<td> </td>
</tr>
<tr>
<td height="40">Constatation table essai</td>
<td><form name="form1">
<select name="menu1" onChange="MM_jumpMenu('parent',this,0)">
<option selected>Boucle+Terre</option>
<option>Boucle</option>
<option>Courant+Isolement</option>
<option>Carte abonné effectueuse</option>
<option>Courant étranger</option>
<option>Isolement</option>
<option>Melange</option>
<option>Reglette</option>
<option>Terre+Fil</option>
<option>unnamed1</option>
</select>
</form></td>
</tr>
<tr>
<td height="47">Aiguillage</td>
<td><form name="form2">
<select name="menu2" onChange="MM_jumpMenu('parent',this,0)">
<option selected>C.C.L</option>
<option>BON ESSAI</option>
<option>SUSPENDU</option>
</select>
</form></td>
</tr>
</table>
</body>
</html> |
Parse error: parse error, unexpected $end
Répondre avec citation
Partager