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> |
Partager