jquery实现省市二级联动菜单

pro_city.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))
{
?>
  
}
?>
 

 
     
        请选择城市
     
 



show.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 = "";
  while($row = mysql_fetch_array($rs))
  {
   $show .= "".$row['cname']."";
  }
  $show .= "";

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