创建和动态填充选择 [英] Creating and populating a select dynamically
问题描述
我有2个表,省和行政区。我想填充选择字段选项,在此基础上省选在另一个选择区名称。各区表有ProvinceID域来引用它属于哪个省。我知道这是可行的,我只是不明白。我也想创建和更新新区选择而无需刷新页面。
I have 2 tables, Provinces and Districts. I would like to populate a select field with options as District names based on which Province is chosen in another select. The Districts table has a ProvinceID field to reference which Province it belongs to. I know this is doable, I just can't figure it out. I also want to create and update the new Districts select without refreshing the page.
更新:我写这在PHP和MySQL,使用jQuery尽可能少。
UPDATE: I'm writing it in PHP and MySQL, using jQuery as sparingly as possible.
推荐答案
其实,我想通了这一点,在我自己的使用jQuery和岗位。在主选择,我添加的onchange =getDistricts(),并用这个该功能:
I actually figured this out on my own using jQuery and post. On the primary select, I added onchange="getDistricts()" and used this for that function:
function getDistricts()
{
var province_id = $("#provinces").val();
$.post("handler.php",
{
"mode" : "get_districts",
"pid" : province_id
},
function(data)
{
$("#districts").html(data);
}, "text");
}
然后在handler.php,我有捕捉模式,并运行以下code的情况:
And then in handler.php, I have a case that catches the mode, and runs the following code:
<query on districts table>
while($row = $sql->fetchrow($result);
{
$id = $row['id'];
$name = $row['name'];
$html .= "<option value='$id' id='$id'>$name</option>";
}
echo $html;
我不是这个解决方案的粉丝,并且真的希望更好的东西,但它确实是我需要做的时刻。我希望这可以帮助别人了。
I'm not a fan of this solution, and would really like something better, but it does what I need it to do for the moment. I hope this can help someone else out.
这篇关于创建和动态填充选择的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!