第二個(gè)下拉列表應(yīng)根據(jù)第一個(gè)下拉列表中的選擇進(jìn)行填充，但我在第二個(gè)下拉列表中得到值“未定義”。從 SQL Server 獲取數(shù)據(jù)。查看 Google 開(kāi)發(fā)工具，我可以看到當(dāng)我單擊第一個(gè)下拉列表中的某個(gè)項(xiàng)目時(shí)，ajaxfile.php 會(huì)正確執(zhí)行查詢。索引文件 <!doctype html> <?PHP$server = "server";$options = array( "UID" => "user", "PWD" => "pass", "Database" => "database");$conn2 = sqlsrv_connect($server, $options);if ($conn2 === false) die("<pre>".print_r(sqlsrv_errors(), true));echo " ";?><html><head><meta charset="utf-8"><title>Untitled Document</title></head><body> <section id="formaT2" class="formaT2 formContent"> <div class="row"> <div class="col-md-2 col-3 row-color remove-mob"></div> <div class="col-md-5 col-9 bg-img" style="padding-left: 0; padding-right: 0;"> <h1>Form</h1> <div class="rest-text"> <div class="contactFrm"> <p class="statusMsg <?php echo !empty($msgClass)?$msgClass:''; ?>"><?php echo $statusMsg; ?></p> <form action="connection.php" method="post"> <div>machinery</div> <select id="machinery"><option value="0">--Please Select Machinery--</option><?php // Fetch Department$sql = "SELECT Machinery FROM T013";$machanery_data = sqlsrv_query($conn2,$sql);while($row = sqlsrv_fetch_array($machanery_data) ){ $machinery = $row['Machinery']; // Option echo "<option value='".$machinery."' >".$machinery."</option>"; } ?></div></select> <div class="clear"></div> <div>Sub Machinery</div> <select id="sub_machinery"> <option value="0">- Select -</option> </select> <input type="submit" name="submit" id="submit" class="strelka-send" value="Insert"> <div class="clear"> </div> </form> </div> </div> </div> </div> </section> </script>
1 回答
- 1 回答
- 0 關(guān)注
- 186 瀏覽
添加回答
舉報(bào)
0/150
提交
取消