php+ajax 城市联动
- WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
- 2016-06-06 19:39:15873Durchsuche
php+ajax城市联动 ?php /* 表结构---- 表的结构 `web_city`--CREATE TABLE IF NOT EXISTS `web_city` ( `id` mediumint(8) NOT NULL AUTO_INCREMENT, `title` varchar(60) NOT NULL, `pid` mediumint(8) NOT NULL DEFAULT '0', PRIMARY KEY (`id`)) ENGINE=M
php+ajax 城市联动
<?php
/* 表结构
--
-- 表的结构 `web_city`
--
CREATE TABLE IF NOT EXISTS `web_city` (
`id` mediumint(8) NOT NULL AUTO_INCREMENT,
`title` varchar(60) NOT NULL,
`pid` mediumint(8) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
--
-- 转存表中的数据 `web_city`
--
INSERT INTO `web_city` (`id`, `title`, `pid`) VALUES
(1, '北京', 0),
(2, '东单', 1),
(3, '西单', 1);
*/
$my_db = mysql_connect("localhost","root","");
mysql_select_db("city", $my_db);
mysql_query("set names 'utf8'");
$sql = "select * from web_city where pid = 0";
$query = mysql_query($sql);
$provice = array();
while($row = mysql_fetch_assoc($query))
{
$provice[] = $row;
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>php+ajax 城市联动</title>
<script src="jquery-1.8.0.min.js"></script>
</head>
<body>
<script>
function select_city(){
var id = jQuery("#provice option:selected").val();
$("#city").html('<option value="">选择市</option>');
$.ajax({
type: "post",
url: "ajax.php",
data: "id="+id,
dataType: "json",
success: function(msg){
var tbody = "";
$.each(msg.optionss,function(n,value){
var trs = "";
trs += "<option value='"+ value.id +"'>"+value.title+"</option>";
tbody += trs;
})
$("#city").append(tbody);
}
});
}
</script>
<div>
<select name="provice" id="provice" onchange="select_city()">
<option value="">选择省/市</option>
<?php foreach($provice as $val){?>
<option value="<?php echo $val['id'];?>"><?php echo $val['title'];?></option>
<?php }?>
</select>
<select name="city" id="city">
<option value="">选择市</option>
</select>
</div>
</body>
</html>
<?php
$my_db = mysql_connect("localhost","root","");
mysql_select_db("city", $my_db);
mysql_query("set names 'utf8'");
if(isset($_POST['id'])){
$id = $_POST['id'];
$sql_city = "select * from web_city where pid = $id";
$query_city = mysql_query($sql_city);
$city = array();
while($row = mysql_fetch_assoc($query_city))
{
$city[] = $row;
}
echo json_encode(array('optionss'=>$city));
}
?>
Stellungnahme：
Der Inhalt dieses Artikels wird freiwillig von Internetnutzern beigesteuert und das Urheberrecht liegt beim ursprünglichen Autor. Diese Website übernimmt keine entsprechende rechtliche Verantwortung. Wenn Sie Inhalte finden, bei denen der Verdacht eines Plagiats oder einer Rechtsverletzung besteht, wenden Sie sich bitte an admin@php.cn
Vorheriger Artikel：php获取远程文件的内容和大小Nächster Artikel：php 面包屑导航