dongweng9474 2017-04-03 12:35
浏览 34

我想创建一个动态下拉列表(不带有oci / mysql)

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 ''.$jto.'';)

I have tried a lot of options but none worked

    enter code here

    <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>";
            /*?><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*/
            }           
$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 STARTS HERE */
$de=$_GET['dedd'];
//$staff=$_POST['callLL'];
if($de!="")
{
$jtosql="SELECT DISTINCT SDO_OD FROM cdr_phone_control where de_od='$de'";
    $jtoqr=odbc_exec($conn, $jtosql);
    echo "<select>";
    while(odbc_fetch_row($jtoqr))
                { 
            $jto=odbc_result($jtoqr,"SDO_OD");
            //echo "<option>".$jto."</option>";
            /*?><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
            }
echo "</select>";   

[enter image description here][1]



  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 完成下列问题完成下列问题
    • ¥15 C#算法问题, 不知道怎么处理这个数据的转换
    • ¥15 YoloV5 第三方库的版本对照问题
    • ¥15 请完成下列相关问题!
    • ¥15 drone 推送镜像时候 purge: true 推送完毕后没有删除对应的镜像,手动拷贝到服务器执行结果正确在样才能让指令自动执行成功删除对应镜像,如何解决?
    • ¥15 求daily translation(DT)偏差订正方法的代码
    • ¥15 js调用html页面需要隐藏某个按钮
    • ¥15 ads仿真结果在圆图上是怎么读数的
    • ¥20 Cotex M3的调试和程序执行方式是什么样的?
    • ¥20 java项目连接sqlserver时报ssl相关错误