PHP|Débutant :: Forums

$avance_type = $_POST['type'];
$avance_reference = $_POST['reference'];
$avance_capacite = $_POST['capacite'];
$avance_energie = $_POST['energie'];
$avance_marque = $_POST['marque'];
$avance_annee = $_POST['annee'];
$avance_valve = $_POST['valve'];
$avance_nserie = $_POST['nserie'];
$avance_model = $_POST['model'];
$avance_volt = $_POST['volt'];
$avance_location = $_POST['location'];
$avance_typemat = $_POST['typemat'];

 //

$select ="SELECT * FROM infos_tbl WHERE   type LIKE '%$avance_type%' AND  location LIKE '%$avance_location%'   AND marque LIKE '%$avance_marque%'  AND volt LIKE '%$avance_volt%' AND annee LIKE '%$avance_annee%' AND capacite LIKE '%$avance_capacite%' AND energie LIKE '%$avance_energie%' AND reference LIKE '%$avance_reference%' AND nserie LIKE '%$avance_nserie%' AND model LIKE '%$avance_model%' AND valve LIKE '%$avance_valve%' AND  typemat LIKE '%$avance_typemat%' ";
$result=mysql_query($select)  or die(mysql_error());
$total = mysql_num_rows($result);
 mysql_close();
 
?>

<table width="100%"  border="0">
  <tr>
    <td width="1%" height="102"> </td>
    <td width="33%" bgcolor="#FFFFFF"><div align="right"><img src="logo.JPG" width="256" height="89"></div></td>
    <td width="47%"><p> </p>
    <table width="353" border="0" bordercolor="#0000FF" bgcolor="#0000FF">
      <tr>
        <td bgcolor="#FFFFFF"> <div align="center"><strong> Articles répondants aux critères recherchés </strong></div></td>
      </tr>
    </table>    </td>
    <td width="19%"> <table width="100%"  border="0">
      <tr>
        <td nowrap bgcolor="#FFFFFF"><div align="right"> </div></td>
        <td bordercolor="#FF0000" bgcolor="#FFFFFF">  </td>
      </tr>
    </table>
    <div align="left">
      <p>Nombre<span class="Style1">:<?php echo $total ?></span></p>
      </div></td>
  </tr>
</table>
<table width="100%" border="0" bordercolor="#FFFFFF" bgcolor="#FFFFFF">
  <tr>
    <td height="1" bordercolor="#FFFFFF" bgcolor="#FFFFFF"> </td>
  </tr>
</table>
<table width="80%"  border="1" align="center" cellspacing="1" bordercolor="#0000FF" bgcolor="#ffffff">
  <tr>
    <td align="center" valign="middle" bordercolor="#FFFFFF" bgcolor="#FFFFFF"><div align="center">
  <link rel="stylesheet" href="2col_rightNav.css" charset="ISO-8859-1" type="text/css"/>
  <?php
 if($total) {
   // début du tableau
    echo '<table>'."\n";
        // affichage
        echo '<tr >';
        echo '<td bgcolor="#3737FF"><b><div align="center"><strong><font color="#FFFFFF"><strong>Type</strong></font></strong></div></b></td>';    //<td><div align="center">ok</div></td>
    echo '<td bgcolor="#3737FF"><b><div align="center"><strong><font color="#FFFFFF"><strong>Reference</strong></font></strong></div></b></td>';
    echo '<td bgcolor="#3737FF"><b><div align="center"><strong><font color="#FFFFFF">Nserie</font></strong></div></b></td>';
    echo '<td bgcolor="#3737FF"><b><div align="center"><strong><font color="#FFFFFF">Marque</font></strong></div></b></td>';
    echo '<td bgcolor="#3737FF"><b><div align="center"><strong><font color="#FFFFFF">Model</font></strong></div></b></td>';
        echo '<td bgcolor="#3737FF"><b><div align="center"><strong><font color="#FFFFFF">Annee</font></strong></div></b></td>';
    echo '<td bgcolor="#3737FF"><b><div align="center"><strong><font color="#FFFFFF">Capacite</font></strong></div></b></td>';
    echo '<td bgcolor="#3737FF"><b><div align="center"><strong><font color="#FFFFFF">Energie</font></strong></div></b></td>';
    echo '<td bgcolor="#3737FF"><b><div align="center"><strong><font color="#FFFFFF">Typemat</font></strong></div></b></td>';
    echo '<td bgcolor="#3737FF"><b><div align="center"><strong><font color="#FFFFFF">Valve</font></strong></div></b></td>';
        echo '<td bgcolor="#3737FF"><b><div align="center"><strong><font color="#FFFFFF">Volt</font></strong></div></b></td>';
    echo '<td bgcolor="#3737FF"><b><div align="center"><strong><font color="#FFFFFF">Location</font></strong></div></b></td>';
        echo '</tr>'."\n";
    // lecture et affichage des résultats , 1 résultat par ligne
 

  $gris = false;  
    while($row = mysql_fetch_array($result)) {
      if ($gris) $gris=false; else $gris=true;  
            if ($gris)
      {
     
echo "<tr bgcolor='#E8E8E8'  onclick=\"recup_id('<?php echo $row['id'];?>')\"
 style=\"cursor:pointer;\"  onMouseover=\"this.style.backgroundColor='#99FF99'\"  onmouseOut=\"this.style.backgroundColor=''\" >";
   
      }

      else
      {
      echo "<tr bgcolor='#F8F8F8'     style=\"cursor:pointer;\"  onMouseover=\"this.style.backgroundColor='#99FF99'\"  onmouseOut=\"this.style.backgroundColor=''\"> ";
      }
        echo '<td >'.$row['type'].'</td>';
    echo '<td >'.$row['reference'].'</td>';
    echo '<td >'.$row['nserie'].'</td>';
    echo '<td >'.$row['marque'].'</td>';
    echo '<td >'.$row['model'].'</td>';
        echo '<td >'.$row['annee'].'</td>';
    echo '<td >'.$row['capacite'].'</td>';
    echo '<td >'.$row['energie'].'</td>';
    echo '<td >'.$row['typemat'].'</td>';
    echo '<td >'.$row['valve'].'</td>';
        echo '<td >'.$row['volt'].'</td>';
    echo '<td >'.$row['location'].'</td>';
    echo "</tr>";
    }
    echo '</div></table id=tableau>'."\n";
    // fin du tableau.
  //
}
else echo 'Pas d\'enregistrements correspondant a votre recherche';
 ?>

    <p> </p>
   
  </div></table>

le formulaire qui une fois executer va m'afficher resultat detaillé est:
<form action= "FicheUpdate2.php" method="post" enctype="multipart/form-data">
<fieldset>
<legend><b></b></legend>
<table> <tr> <td>reference  : </td>
    <td><input name="reference" type="text" value="" size="20" maxlength="10"/></td></tr>
<tr><td>Modifier : </td> <td><input type="submit" value="Modifier"/></td></tr>
</table>
</fieldset>
</form>