<?php require_once('../../Connections/bd.php'); ?> <?php header('Content-type:text/html;charset=ISO-8859-1'); //Liste des villes du département mysql_select_db($database_bd1, $bd1); $code='WHERE dpt_ville="' . $_GET["tb2"] . ' " '; $query_ville1 = "SELECT * FROM mdm_ville_cat " . $code . "ORDER BY nom_ville" ; $ville1 = mysql_query($query_ville1, $bd1) or die(mysql_error()); $row_ville1 = mysql_fetch_assoc($ville1); $totalRows_ville1 = mysql_num_rows($ville1); $t=""; for ($nb=0;$nb<$totalRows_ville1;$nb++) { $i=mysql_result($ville1,$nb,"id_ville"); $t.="\t".$i; } echo $t; ?>
<?php //Liste des departements mysql_select_db($database_bd1, $bd1); $query_departement1 = "SELECT * FROM mdm_departement_cat ORDER BY nom_dpt ASC"; $departement1 = mysql_query($query_departement1, $bd1) or die(mysql_error()); $row_departement1 = mysql_fetch_assoc($departement1); $totalRows_departement1 = mysql_num_rows($departement1); ?> <select name="tb1" id="tb1" size=3 onchange='appel();'> <?php for ($nb=0;$nb<$totalRows_departement1;$nb++) { $i=mysql_result($departement1,$nb,"id_dpt"); $j=mysql_result($departement1,$nb,"nom_dpt"); echo '<option value="' . $i . '">'.$j.'</option>'; } ?></select> <select name="tb2" id="tb2" size=3></select>
<script type="text/javascript"> function xmlhttp() { var x; try { x = new ActiveXObject("Microsoft.XMLHTTP"); } catch (e) { try { x = new ActiveXObject("Msxml2.XMLHTTP"); } catch (e) { try { x = new XMLHttpRequest(); } catch (e) { x=false; } } } return x; } function appel() { var xml = xmlhttp(); if(!xml) { alert("XmlHttpRequest non supporté"); } else { xml.onreadystatechange = function() { if(xml.readyState==4) { var opt=xml.responseText.split("\t"); tb2.length=0; for ( var n=1;n<opt.length;n++ ) { tb2.length++; tb2.options[tb2.length-1].text=opt[n]; } } } xml.open("GET", "./javascript/ajax1.php?tb2="+tb1.options[tb1.selectedIndex].text, true); xml.send(null); } } </script>
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionvar t1=document.getElementById("tb1");
xml.open("GET", "./javascript/ajax1.php?tb2="+t1.options[t1.selectedIndex].text, true);