ajax php-sql填充依赖的组合框 - ajax php sql populate dependent comboboxes

ajax php sql populate dependent comboboxes

本文关键字：组合依赖 php-sql 填充 ajax | 更新日期: 2023-09-27

我只是所有php ajax的初学者。我从数据库中填充了一个组合框，但无法填充第二个。

我需要根据Proses值填充Machine组合框。最后用Id填充Envanter no。谢谢你的帮助！这是我的代码

我的数据库表主

进程|机器| ID
Bolzen|M1|1
Bolzen|M2|2
Bolzen|M3|3
Platte|M4|5
Platte|M4|7

这是我的代码

<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>

我建议您使用Jquery来生成ajax请求，这更容易。要知道这个过程应该如何，你可以阅读下面帖子中的例子：

http://www.snilesh.com/resources/jquery/jquery-dynamic-selectbox/

http://www.codingcereal.com/2009/09/autopopulate-select-dropdown-box-using-jquery/

我希望导游能帮助你。