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