我试图采取下拉框在PHP和选择一个项目从第一个框。然后,我希望从第一个下拉框中选择项目,并将其放入$lineIDSelection变量中,以便将其插入到下一个下拉框的查询中。我试图过去的主要事情是,当我点击我的下拉框中的一个选项,我需要能够提交它,或者更好的是,有它动态更新到一个变量。这是我正在使用的一段代码。
$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die("could not connect to the databse!");
$select_db = mysql_select_db('camdb') or die ('could not select camdb database!!');
$lineID = "SELECT * FROM camTable;";
$IDresult = mysql_query($lineID);
echo"line" . "<br/>";
echo "<select name='"line'">";
while ($row = mysql_fetch_array($IDresult)) {
echo "<option value='" . $row['line'] . "'>" . $row['line'] . "</option>";
}
echo "</select>" . "<br/>" . "<br/>";
$query = "SELECT DISTINCT Length FROM camTable;";
$result = mysql_query($query);
echo"Cam Length" . "<br/>";
echo "<select name='"Length'">";
while ($row = mysql_fetch_array($result)) {
echo "<option value='" . $row['Length'] . "'>" . $row['Length'] . "</option>";
}
echo "</select>" . "<br/>" ."<br/>";
Q.I then want the selected item from my first drop down box, and placed it into
my $lineIDSelection variable so that I can insert it into a query for the next
drop down box
可以通过Ajax实现:-
on -change在第一个下拉菜单上您将获得值,并基于第一个下拉菜单值,可以生成第二个下拉列表。
PHP:- assign id给下拉列表
echo "<select name='line' id='dropDown1'>";
Jquery:-
$('#dropDown1').change(function() {
var sel_item=$(this).val();
// sel_item is first dropdown selected value.
// pass it to ajax request
// in you ajax request get sel_item and assign it to $lineIDSelection
});