excuse moi j'avais pas vu de les mettre dans les 2 fichiers!
mais ca ne marche toujours pas il me met erreur sur la page!
index.php
[code]<script type='text/javascript'>
//var xhr = null;
// Renvoie le texte de l'objet ActiveXObject le plus récent depuis une liste
var pickRecentProgID = function (idList){
// found progID flag
var bFound = false;
for(var i=0; i < idList.length && !bFound; i++){
try{
var oDoc = new ActiveXObject(idList[i]);
o2Store = idList[i];
bFound = true;
}catch (objException){
// trap; try next progID
};
};
if (!bFound)
throw ("Aucun ActiveXObject n'est valide sur votre ordinateur, pensez à mettre à jour votre navigateur");
idList = null;
return o2Store;
}
// Retourne un nouvel objet XmlHttpRequest
var GetXmlHttpRequest_AXO=null
var GetXmlHttpRequest=function () {
if (window.XMLHttpRequest) {
return new XMLHttpRequest()
}
else if (window.ActiveXObject) {
if (!GetXmlHttpRequest_AXO) {
GetXmlHttpRequest_AXO=pickRecentProgID(["Msxml2.XMLHTTP.5.0", "Msxml2.XMLHTTP.4.0", "MSXML2.XMLHTTP.3.0", "MSXML2.XMLHTTP", "Microsoft.XMLHTTP"]);
}
return new ActiveXObject(GetXmlHttpRequest_AXO)
}
return false;
}
// Compatibilité avec le script du tutoriel AJAX (developpez.com)
getXhr=GetXmlHttpRequest;
/**
* Méthode qui sera appelée sur le click du bouton
*/
//requete1
function go(){
var xhr = getXhr();
xhr.onreadystatechange = function(){
if(xhr.readyState == 4 && xhr.status == 200){
leselect = xhr.responseText;
document.getElementById('designation').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;
des = document.getElementById('designation');
val_des = sel.options[des.selectedIndex].value;
xhr.send("Id_ref="+id_ref+"&designation="+val_des);
}
</script>
</head>
<body>
<form action="envoi_elec.php" method="post" enctype="multipart/form-data">
<legend>commande</legend><br><br>
<label>Ref</label>
<select name='ref' id='Id_ref' onchange='go();'>
<option value='ref_pdt'>reference</option>
<?php
//requete3
include ('connexion.php');
$res = mysql_query("SELECT * FROM ref_elec");
while($row = mysql_fetch_assoc($res)){
echo "<option value='".$row["ref_pdt"]."'>".$row["ref_pdt"]."</option>";
}
?>
</select>
<label>Des</label>
<div id='designation' style='display:inline'>
<select name='designation' id="designation">
<option value='designation'>designation</option>
</select>
</div>
<label> Nbre pièces </label>
<input type="text" name="piece" size="1">
<br><br>
<input type="submit" value="envoyer">
</form>
[/code]
ajax1.php
[code]<?php
//requete1
if(isset($_POST["Id_ref"])){
if ($db=mysql_connect($a,'$b','$c') ) {
if (mysql_select_db('$b',$db) ) {
$requete = 'SELECT des.id, des.des_pdt, des.Qte, des.Id_ref FROM ref_elec as ref
LEFT JOIN des_elec as des ON des.Id_ref = ref.id WHERE ref.ref_pdt = "' . mysql_escape_string($_POST['Id_ref']) . '"';
if ($res = mysql_query($requete) ) {
echo "<select name='designation'>";
while($row = mysql_fetch_assoc($res)){
echo "<option value='".$row["des_pdt"]."'>".$row["des_pdt"]."</option>";
}
echo "</select>";
}
if ($res = mysql_query($requete) ) {
echo ' <label> colis </label>';
echo "<select name='qte' id='designation'>";
while($row = mysql_fetch_assoc($res)){
echo "<option value='".$row["Qte"]."'>".$row["Qte"]. "</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_ref non défini";
}
?>[/code]
