doucai5315 2013-07-19 12:26
浏览 31
已采纳

ajax php sql填充依赖的组合框

I'm just a beginner for all this php ajax things. I populate one of my combobox from database but I can't populate second one.

I need to populate Machine combobox according to Proses value. And finally fill Envanter no with Id. Thanks for help! Here is my code

My database table main

Process | Machine | ID
Bolzen | M1 | 1
Bolzen | M2 | 2
Bolzen | M3 | 3
Platte | M4 | 5
Platte | M4 | 7

Here is my code

<html>
<body>
<div id="content"  style="background-color:#EEEEEE;position:absolute; overflow:hidden; left:138px; top:101px; width:770px; height:450px">
 <form action="" name="myform" id="myform">
  <p><center> MFT1.2 SPC Girisleri Ölcüm Programi</center></p>
    <center><p> Tarih:&nbsp&nbsp <span id="mydate"> </span>
    &nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp
    <script type="text/javascript">
    date();
    </script>
    Machine No:
    <select name="Machine">
        <option value="000" selected = "selected"></option>


            </select>           
    </center></p>

    <center><p>
    Vardiya:&nbsp&nbsp
        <select name="Vardiya">
            <option value="000" selected="selected" >
            </option>
            <option>
              1. Vardiya
            </option>
            <option>
              2. Vardiya
            </option>
            <option>
              3. Vardiya
            </option>
        </select>   
    &nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp            
    Envanter No:
    <input type="text" name="envanter" disabled="disabled"/>
    </center></p>
    <center><p>

    Proses:&nbsp&nbsp

            <?php
        // Load field datas into List box

            $cn=mysql_connect("localhost","root","12345678") or die("Note: " . mysql_error());
            $res=mysql_select_db("OlcumTakip",$cn) or die("Note: " . mysql_error());
            $res=mysql_query("select DISTINCT Proses from main;") or die("Note: " . mysql_error());
            ?>
        <select name="Proses">
            <option value="000" selected = "selected"></option> 
        <?php
        while($ri = mysql_fetch_array($res))
        {
        echo "<option value=" .$ri['Proses'] . ">" . $ri['Proses'] . "</option>";
        }
        echo "</select> ";

        mysql_close($cn);
        ?>      

    </center></p>
    <input type="submit" value="Submit" style ="margin-left:350px"/>
 </form>
</div>
</body>
</html>
  • 写回答

1条回答 默认 最新

报告相同问题？

悬赏问题

  • ¥15 c语言怎么用printf（“\b \b”）与getch（）实现黑框里写入与删除？
  • ¥20 怎么用dlib库的算法识别小麦病虫害
  • ¥15 华为ensp模拟器中S5700交换机在配置过程中老是反复重启
  • ¥15 java写代码遇到问题，求帮助
  • ¥15 uniapp uview http 如何实现统一的请求异常信息提示？
  • ¥15 有了解d3和topogram.js库的吗？有偿请教
  • ¥100 任意维数的K均值聚类
  • ¥15 stamps做sbas-insar，时序沉降图怎么画
  • ¥15 买了个传感器，根据商家发的代码和步骤使用但是代码报错了不会改，有没有人可以看看
  • ¥15 关于#Java#的问题，如何解决？