jquery实现省市二级联动菜单

最新推荐文章于 2024-05-06 21:09:29 发布

zyx1660

最新推荐文章于 2024-05-06 21:09:29 发布

阅读量248

点赞数

分类专栏： jquery 文章标签： php jquery mysql ViewUI

本文链接：https://blog.csdn.net/zyx1660/article/details/84301794

版权

jquery 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

pro_city.php 初始页面：

<html>
<head>
    <meta http-equiv="Content-Type" content="text/html;charset=utf-8" />
    <title>省市二级联动</title>
</head>
<body>
<script type="text/javascript" src="jquery/jquery-1.4.2.js"></script>
<script type="text/javascript">
    $(document).ready(function(){
         $("#province").change(function(){
             $("#city").load("show.php?id="+$("#province").val());
             });
        });
</script>

<span>省市二级联动</span><br/>
<select name="province" id="province">
     <option value="-1">请选择省份</option>
<?php
$conn = mysql_connect("localhost","root","root");                //连接数据库
mysql_query("set names utf8");
mysql_select_db("bbs");
$rs = mysql_query("select id,cname,parentid from areas where parentid='0'");
while($row = mysql_fetch_array($rs))
{
?>
   <option value="<?php echo $row['id']?>"><?php echo $row['cname']?></option>
<?php
}
?>
</select>

<span id="city">
      <select name="city1" id="city1">
        <option value='-2'>请选择城市</option>
      </select>
</span>
</body>
</html>

show.php

<?php
header("content-type:text/html;charset=utf-8");

$province_id = $_GET['id'];
if($province_id=='10000000' || $province_id=='11000000' || $province_id=='18000000' || $province_id=='31000000')
{
      //直辖市
      $sql = "select id,cname from areas where id='{$province_id}'";
}
else
{
    $sql = "select id,cname from areas where parentid={$province_id}";
}

$conn = mysql_connect("localhost","root","root");            //连接数据库
mysql_query("set names utf8");
mysql_select_db("bbs");
$rs = mysql_query($sql);

$show = "<select name='city1' id='city1'>";
while($row = mysql_fetch_array($rs))
{
   $show .= "<option value=".$row['id'].">".$row['cname']."</option>";
}
$show .= "</select>";

if($province_id=='-1')    //选中”请选择省份“时，城市列表显示"请选择城市"
{
      $show="<select><option>请选择城市</option></select>";
}
echo $show;    //返回字符串显示到页面
?>

zyx1660

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
jquery实现省市二级联动菜单

pro_city.php 初始页面：&lt;html&gt; &lt;head&gt; &lt;meta http-equiv="Content-Type" content="text/html;charset=utf-8" /&gt; &lt;title&gt;省市二级联动&lt;/title&gt; &lt;/head&gt;
复制链接

扫一扫

专栏目录