Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre question//requete1 function go(){ var xhr = getXhr(); xhr.onreadystatechange = function(){ if(xhr.readyState 4 && xhr.status 200){ leselect = xhr.responseText; document.getElementById('designation').innerHTML = leselect; document.getElementById('Qte').innerHTML = leselect; } } xhr.open("POST","./ajax1.php",true); xhr.setRequestHeader('Content-Type','application/x-www-form-urlencoded'); sel = document.getElementById('Id_ref'); id_ref = sel.options[sel.selectedIndex].value; xhr.send("Id_ref="+id_ref); } </script> </head> <form action="visualiser.php" method="post" enctype="multipart/form-data"> <fieldset style="width: 800px"> <legend>commande</legend> <label>reference</label> <select name='reference' id='Id_ref' onchange='go();'> <option value='reference'>reference</option> <?php //requete1 include ('connexion.php'); $res = mysql_query("SELECT * FROM reference"); while($row = mysql_fetch_assoc($res)){ echo "<option value='".$row["id"]."'>".$row["ref_pdt"]."</option>"; } ?> </select> <label> Nbre de pièce </label> </form> </html>
<?php //requete1 if(isset($_POST["Id_ref"])){ if ($db=mysql_connect('sql.arcotec.fr','arcotecfr','Flgv+532') ) { if (mysql_select_db('arcotecfr',$db) ) { $requete = "SELECT * FROM designation WHERE Id_ref=".$_POST["Id_ref"].""; if ($res = mysql_query($requete) ) { echo "<label> designation </label>"; echo "<select name='designation'>"; while($row = mysql_fetch_assoc($res)){ echo "<option value='".$row["Id"]."'>".$row["des_pdt"]."</option>"; } echo "</select>"; } else { echo "Erreur de requête"; } } else { echo "Erreur sélection de base de données"; } } else { echo "Erreur de connexion mysql"; } } else { echo "Id_re1 non défini"; } ?>