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
| $query="SELECT * FROM matériel WHERE 1 AND reference LIKE '$reference'";
$result=mysql_query($query)
or die("la requete à échouée");
print"\t <hr size='3'> \n";
mysql_free_result($result);
$result=mysql_query($query);
$line = mysql_fetch_assoc($result);
list($col_name, $col_value) = each($line);$a=$col_value;
list($col_name, $col_value) = each($line);$b=$col_value;
list($col_name, $col_value) = each($line);$c=$col_value;
list($col_name, $col_value) = each($line);$d=$col_value;
list($col_name, $col_value) = each($line);$e=$col_value;
list($col_name, $col_value) = each($line);$f=$col_value;
list($col_name, $col_value) = each($line);$g=$col_value;
list($col_name, $col_value) = each($line);$h=$col_value;
list($col_name, $col_value) = each($line);$i=$col_value;
list($col_name, $col_value) = each($line);$j=$col_value;
list($col_name, $col_value) = each($line);$k=$col_value;
list($col_name, $col_value) = each($line);$l=$col_value;
list($col_name, $col_value) = each($line);$m=$col_value;
list($col_name, $col_value) = each($line);$p=$col_value;
$m = stripslashes($m) ;
//echo date( " D d F Y" , strtotime("$k")) . "\n";
print"\t <form action='record.php' method='POST' name='formu'> \n";
print"\t <table> \n";
print"\t <tr><td>N° machine</td><td><input name='a' value='$a'></td><td>Etablissement</td><td><input name='e' value='$e'></td><td>Exemple : Restaurant + Nom</td></tr> \n";
print"\t <tr><td>Type machine<td><input name='b' value='$b' 'size'='1'></td></td><td>Signataire</td><td><input name='f' value='$f'></td></tr> \n";
print"\t <tr><td>Machine</td><td><input name='c' value='$c'></td><td>Adresse</td><td><input name='m' value='$m'></td></tr> \n";
print"\t <tr><td>Type contrat</td><td><input name='d' value='$d' 'size'='1'></td><td>Code postal</td><td><input name='k' value='$k'></td></tr> \n";
print"\t <tr><td>Traitement d'eau</td><td><input name='j' value='$j' 'size'='1'></td><td>Ville</td><td><input name='l' value='$l'></td></tr> \n";
print"\t <tr><td>Prochaine intervention</td><td><input name='i' value='$i'><input type='button' value='...' onClick='ouvreprochinter()'></td><td>N° téléphone</td><td><input name='g' value='$g'></td></tr> \n";
print"\t <tr><td>Jours de fermeture</td><td><input name='p' value='$p'></td><td>N° téléphone portable</td><td><input name='h' value='$h'></td></tr> \n";
print"\t </table> \n";
print"\t <br><input type='submit' value='Ajouter' name='B3'><input type='submit' value='Modifier' name='B3'><input type='submit' value='Supprimer' name='B3'><input type='reset' value='Rétablir' name='B2'><input type='submit' value='Imprimer PDF' name='B3' onClick='imp()'> \n";
print"\t </form> \n"; |
Partager