我正在创建一个程序,当您从下拉菜单中选择一个州时,它将在另一个下拉菜单中显示该州的城市列表,您可以从中选择。选择您的城市和州之后,输入一个地址,点击submit,它将在一个新的php文件上显示完整的地址。
我目前的问题是,我可以让州显示,但当州被选中时,它没有在第二个下拉菜单中给出该城市的选项列表。任何帮助都是感激的,谢谢!
您可以在此链接上查看行为。
select.php
<head>
<link rel="stylesheet" type="text/css" href="select_style.css">
<script type="text/javascript" src="js/jquery.js"></script>
<!DOCTYPE html>
<form action = "display.php">
<script type="text/javascript">
function fetch_select(val)
{
$.ajax({
type: 'post',
url: 'fetch.php',
data: {
get_option:val
},
success: function (response) {
document.getElementById("new_select").innerHTML=response;
}
});
}
</script>
</head>
<body>
<p id="heading">Address Generator</p>
<center>
<div id="select_box">
<select onchange="fetch_select(this.value);">
<option>Select state</option>
<?php
include ( "accounts.php" ) ;
( $dbh = mysql_connect ( $hostname, $username, $password ) )
or die ( "Unable to connect to MySQL database" );
print "Connected to MySQL<br>";
mysql_select_db( $project );
$select=mysql_query("select state from zipcodes group by state");
while($row=mysql_fetch_array($select))
{
echo "<option>".$row['state']."</option>";
}
?>
</select>
<select id="new_select">
</select>
<div id='2'> </div>
<br><br>
<input type = text name="address">Address
<br><br>
<input type = submit>
</form>fetch.php
<?php
include(accounts.php);
if(isset($_POST['get_option']))
{
( $dbh = mysql_connect ( $hostname, $username, $password ) )
or die ( "Unable to connect to MySQL database" );
print "Connected to MySQL<br>";
mysql_select_db( $project );
$state = $_POST['get_option'];
$find=mysql_query("select city from zipcodes where state='$state'");
while($row=mysql_fetch_array($find))
{
echo "<option>".$row['city']."</option>";
}
exit;
}
?>发布于 2017-04-28 18:20:41
1)首先,缺失了状态选项的值属性
echo "<option value='".$row["state"]."'>".$row["state"]."</option>";2)包含(accounts.php);accounts.php应以双引号括起来
3)城市期权的价值属性缺失
echo "<option value='".$row["city"]."'>".$row["city"]."</option>";4)代替每次回波,最后像这样级联和回波
$options="";
while($row=mysql_fetch_array($find))
{
$options.= "<option value='".$row["city"]."' >".$row["city"]."</option>";
}
echo $options;警告!
警告mysql_query,mysql_fetch_array,mysql_connect等PHP 5.5.0中不推荐扩展,PHP7.0.0中也删除了扩展。相反,应该使用MySQLi或PDO_MySQL扩展。
发布于 2017-04-28 18:32:54
我对你的代码做了一点修改。试着用优雅的方式来做。你写了太多多余的代码。您不需要一个<form>元素来执行询问的操作。无论如何,下面是修改过的代码。
<!DOCTYPE html>
<head>
<title>Address Generator</title>
</head>
<body>
<p id="heading">Address Generator</p>
<center>
<!-- <div id="select_box"> -->
<select name="select_box" id="select_box">
<?php
include ( "accounts.php" ) ;
( $dbh = mysql_connect ( $hostname, $username, $password ) ) or die ( "Unable to connect to MySQL database" );
print "Connected to MySQL<br>";
mysql_select_db( $project );
$select=mysql_query("select state from zipcodes group by state");
while($row=mysql_fetch_array($select))
{
echo "<option>".$row['state']."</option>";
}
?>
</select>
<select id="new_select">
</select>
<div id='2'> </div>
<br><br>
<input type = text name="address">Address
<br><br>
<script type="text/javascript" src="js/jquery.js"></script>
<script type="text/javascript">
$(document).ready(function() {
$('#select_box').on('change', function() {
var state = $(this).val();
$.ajax({
url: 'fetch.php',
type: 'POST',
data: {state: state},
success: function(response)
{
var response = JSON.parse(response);
$('#new_select').find('option').remove();
var option = '';
$.each(response.cities, function(key, val) {
option = option + "<option value='" + val + "'>" + val + "</option>";
});
$('#new_select').append(option);
}
});
});
});
</script>
</body></body>标记结束之前添加了Jquery。这并不妨碍当前代码的执行。然而,您可以始终预加载它,但这种策略是以后。<form>元素,所以我已经完全删除了它。您随时可以根据您的方便添加它。cities获得的对象response的对象数组上运行一个循环。JSON.parse()函数解析JSON数据。json_encode您的json变量,它将存储相应的citites数据。我希望这能帮到你。任何进一步的查询也是欢迎的。
https://stackoverflow.com/questions/43685873
复制相似问题