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
| <?php
require_once("/home/bexter/htdocs/bbintra/configthm.inc.php");
//if(!empty($EXCEL)) header("Content-type: application/vnd.ms-excel");
?>
<body>
<?php
echo '<table>'."\n";
if (!empty($_POST))
{ //Si post rempli : ok on rentre dans le script.
//echo '<tr>';
foreach ($_POST as $ref => $valref)
{
$q= "select ref, aspi_cuve, aspi_diam_asp ,aspi_nb_mot,aspi_refroid ,auto_larg_suceur ,auto_larg_travail , auto_moteur_aspi , auto_moteur_brosse ,auto_nb_brosse ,auto_rayon_braq ,auto_rdt_theo ,bal_brosse_centr , bal_decolmat ,bal_surf_filtr , bal_vidage ,batterie , batterie_pds ,brosse_diam , brosse_pente_max ,brosse_pression , brosse_type_avance , brosse_vit_max , brosse_vitesse_acc , gen_alim , gen_capac_recup , gen_capac_solution , gen_debit_air , gen_depression , gen_dim , gen_long_cable , gen_niv_son , gen_poids , gen_puissance ,hp_bielles , hp_debit_eau , hp_moteur , hp_pistons , hp_pompe , hp_pression , hp_reserv_annex , hp_reserv_gazo , hp_temp_deter , inj_long_flex , mono_entrain , nvap_carrosserie , nvap_chaudiere , nvap_temp_vap , nvap_vol_chaud , nvap_prod_vap , commentaire2 , commentaire3 FROM machine WHERE fam_stat2 IN (1 , 107, 109, 11 , 111, 113, 117, 13 , 15 , 17 , 21 , 23 , 241, 243, 245, 247, 249, 25 , 251, 253, 255, 27 , 29 , 3 , 305, 307, 309, 33 , 35 , 37 , 39 , 41 , 43 , 45 , 47 , 49 , 5 , 51 , 53 , 59 , 63 , 65 , 67 , 69 , 7 , 71 , 73 , 75 , 77 , 79 , 83 , 85 , 87 , 89 , 9 , 91 , 93 , 95 ) AND ref LIKE '$valref' ";
$req = mysql_query ($q)or die('Erreur SQL !<br>'.$q.'<br>'.mysql_error() );
$data = mysql_fetch_array($req);
foreach ($data as $ligne)
{
echo '<tr>';
foreach ($_POST as $colonne)
{
echo '<td>'.$tab[$ligne][$colonne]'.</td>';
}
echo '</tr>';
}
}
}
echo '</table>'."\n";
}
else
{
// si le POST est VIDE alors on affiche le formulaire.
?>
<div>
<form method="post" action="<?php $_SERVER['PHP_SELF'] ?>">
<fieldset>
<label for="ref_materiel">Reference materiel:</label>
<input type="texte", name="ref_materiel", size="12">
<label for="ref_materiel2">2 Reference materiel:</label>
<input type="texte", name="ref_materiel2", size="12">
<label for="ref_materiel3">3 Reference materiel:</label>
<input type="texte", name="ref_materiel3", size="12">
<input type=submit value=ok style='font-size:10px'>
<input type="submit" value="EXCEL" name="EXCEL">
</fieldset>
</form>
</div>
<?php
}
?>
</body>
</html> |
Partager