数据表如下:
CREATE TABLE IF NOT EXISTS `china` (
`region_id` smallint(5) unsigned NOT NULL,
`parent_id` smallint(5) unsigned NOT NULL DEFAULT ‘0‘,
`region_name` varchar(120) NOT NULL DEFAULT ‘‘,
`region_type` tinyint(1) NOT NULL DEFAULT ‘2‘,
`agency_id` smallint(5) unsigned NOT NULL DEFAULT ‘0‘
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
数据见文件:
测试页test.php,
在这个文件得先引入 jquery文件和相应的js文件(accoun_1.js),
用 ajax技术查找(ajax_1.php)
test.php文件如下
<?php
session_start();
$link = mysql_connect(‘localhost‘, ‘root‘, ‘123456‘) or die("Error: " . mysql_error());
mysql_select_db(‘trade‘, $link);
mysql_query("set names utf8", $link);
$province = array();
$sql = "select * from china where parent_id = 1";
$result = mysql_query($sql);
while($row = mysql_fetch_assoc($result))
{
$province[$row[‘region_id‘]] = $row;
}
?>
<script src="jquery-1.10.2.js" type="text/javascript"></script>
<script src="accoun_1.js" type="text/javascript"></script>
<center>
<form name="myform" action="deal.php" method="post">
<input type="hidden" value="ajax_1.php" id="site_url">
<div id="box">
<div class="tr china len2">
<span><b></b>省份:</span>
<select name="province" class="province option">
<option>-请选择省-</option>
<?php foreach ($province as $key => $value):?>
<option><?php echo $value[‘region_name‘];?></option>
<?php endforeach;?>
</select>
<select name="city" class="city option">
<option>-请选择市-</option>
</select>
<select name="county" class="county option">
<option>-请选择区/县-</option>
</select>
</div>
<div class="address len2">
<span><b></b>地址:</span>
<textarea name="address"></textarea>
</div>
</div>
<input type="submit" name="submit" value="submit" />
</form>
</center>
acoun_1.js文件如下:
// id = 1为省份,2为城市
$(document).ready(function(){
var Iprovince=$(‘#box .china .province‘);
var Icity=$(‘#box .china .city‘);
var Icounty=$(‘#box .china .county‘);
var address = $(‘#box .address textarea‘);
Iprovince.change(function(){
var province = $(this).val();
address.text(province);
var _url = ‘ajax_1.php‘;
$.ajax({
url:_url,
type: ‘post‘,
data:{‘prov‘: province, ‘id‘: 1},
success:function(data)
{
Icity.append(data);
}
});
});
Icity.change(function(){
var city = $(this).val();
address.text(address.text()+city);
var _url = ‘ajax_1.php‘;
$.ajax({
url:_url,
type:‘post‘,
data:{‘city‘:city, ‘id‘: 2},
success:function(data)
{
Icounty.append(data)
}
});
});
Icounty.change(function(){
var country = $(this).val();
address.text(address.text()+country);
})
});
ajax_1.php文件如下:
$(document).ready(function(){
var Iprovince=$(‘#box .china .province‘);
var Icity=$(‘#box .china .city‘);
var Icounty=$(‘#box .china .county‘);
var address = $(‘#box .address textarea‘);
Iprovince.change(function(){
var province = $(this).val();
address.text(province);
var _url = ‘ajax_1.php‘;
$.ajax({
url:_url,
type: ‘post‘,
data:{‘prov‘: province, ‘id‘: 1},
success:function(data)
{
Icity.append(data);
}
});
});
Icity.change(function(){
var city = $(this).val();
address.text(address.text()+city);
var _url = ‘ajax_1.php‘;
$.ajax({
url:_url,
type:‘post‘,
data:{‘city‘:city, ‘id‘: 2},
success:function(data)
{
Icounty.append(data)
}
});
});
Icounty.change(function(){
var country = $(this).val();
address.text(address.text()+country);
})
});
php 商务网站购物车联动地址,布布扣,bubuko.com
原文:http://www.cnblogs.com/lin3615/p/3817368.html