Forum:

dynamic dropdown list php+oracle+java+ajax

Greenhorn

Posts: 2

posted 5 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

hi guys
i want to create a dynamic dropdown
showing SDE when DE is selected
My problem is that though the list of DE is displayed (snapshot attached)
but i don't get SDE
(As i think that I am unable to pass the onclick value
following line in code:---------
echo '<option value="'.$jto.'">'.$jto.'</option>';)

I have tried a lot of options but none worked (IN GREEN)

Experts kindly help ........................................................................

<form name="form1" action="" method="post">
<table>
<tr>
<td> select de</td>
<td><select id="dedd" onChange="change_de()">
<option>select</option>
<?php

$jtosql="SELECT DISTINCT DE_OD FROM cdr_phone_control";
    $jtoqr=odbc_exec($conn, $jtosql);
    while(odbc_fetch_row($jtoqr))
				{ 
		  	$jto=odbc_result($jtoqr,"DE_OD");
			
			echo '<option value="'.$jto.'">'.$jto.'</option>';
			//echo "<option>".$jto."</option>";
			[color=green]/*?><option value="<?php echo $jto; ?>">"<?php".$jto."?></option><?php
			?><option><?php echo ."$jto." ?></option><?php
			?><option value="<?php echo $jto ?>"><?php echo "$jto"; ?></option><?php
			?><a href="test52.php?page=<?php echo $b;?>" style="text-decoration:none"><input type="submit" value="<?php echo $b." "; ?>"</a><?php*[/color]/
			}   		
$page=$_GET["dedd"];			
			ECHO $jto;
		echo $jtoqr;
		echo $page;
	/*?><a href="test52.php?page=<?php echo $b;?>" style="text-decoration:none"><input type="submit" value="<?php echo $b." "; ?>"</a><?php*/		
?>
</select>
</td></tr>

<tr><td>select sde</td>
<td>
<div id="sde">
<select><option>select</option></select></div>
</td></tr>
</table>
</form>
<script type="text/javascript">
function change_de()
{
var xmlhttp=new XMLHttpRequest();
xmlhttp.open("GET","ajax.php?de="+document.getElementById("dedd").value,false);	
xmlhttp.send(null);
//alert(xmlhttp.responseText);
document.getElementById("sde").innerHTML=xmlhttp.responseText;

}
</script>

-------------------------------=================================ajax.php===========================------------------------------------

dropdown.jpg

Consider Paul's rocket mass heater.