php 省市区 带数据 可设默认值 带无限联动

<?php class china_city { /*获取分类名称*/ //所属分类 function classname($tablename,$classid){ $query = mysql_query("select title from ".$tablename." where id=".$classid); if(mysql_num_rows($query) != 0){ $rs = mysql_fetch_array($query); $classname = $rs['title']; return $classname; } else { return ""; } mysql_free_result($query); } //获取分类 //----------- function queryRank($id, $rank, $tablename) { if($id == "" || !is_numeric($id)) { return -1; } $query = mysql_query("select * from ".$tablename." where id=".$id); $qrs=mysql_fetch_array($query); if(mysql_num_rows($query) != 0) { if ($qrs["parentid"] != 0) { @$rank = $rank + 1; return $this->queryRank($qrs["parentid"], $rank, $tablename); } else { return $rank; } } else { return -1; } mysql_free_result($query); } //----------- //添加分类 无限分类联动 function addSelect($tableName,$parentid=0){ $rs_sql = mysql_query("select max(rank) as d_rank from $tableName"); $rs_total = mysql_num_rows(mysql_query("select rank from $tableName")); if($rs_total > 0 ) { echo '<script type="text/javascript">$(function(){ changeSelect('.$parentid.', "class1"); });</script>'; $rs = mysql_fetch_array($rs_sql); for($i=1;$i<= $rs['d_rank'];$i++) { if($i<$rs['d_rank']){ echo '<select name="class'.$i.'" id="class'. $i.'" onchange="changeSelect(this.value,'."'".'class'.($i+1)."'".')" datatype="*" nullmsg="请选择!" ></select> '; } else { echo '<select name="class'.$i.'" id="class'.$i.'" datatype="*" nullmsg="请选择!"></select> '; } } } else { echo '<script type="text/javascript">$(function(){ changeSelect(0, "class1"); });</script>'; echo '<select name="class1" id="class1" datatype="*" nullmsg="请添加信息!"></select> '; } mysql_free_result($rs_sql); } //添加页面，无极限分类 function addSelectNum($tableName,$num){ $rs_sql = mysql_query("select max(rank) as d_rank from $tableName"); $rs_total = mysql_num_rows(mysql_query("select rank from $tableName")); if($rs_total > 0 ) { echo '<script type="text/javascript">$(function(){ changeSelect(0, "class1"); });</script>'; $rs = mysql_fetch_array($rs_sql); for($i=1;$i<= ($rs['d_rank']+$num);$i++) { if($i<($rs['d_rank']+$num)){ echo '<select name="class'.$i.'" id="class'. $i.'" onchange="changeSelect(this.value,'."'".'class'.($i+1)."'".')" datatype="*" nullmsg="请选择!" ></select> '; } else { echo '<select name="class'.$i.'" id="class'.$i.'" datatype="*" nullmsg="请选择!"></select> '; } } } else { echo '<script type="text/javascript">$(function(){ changeSelect(0, "class1"); });</script>'; echo '<select name="class1" id="class1" datatype="*" nullmsg="请添加信息!"></select> '; } mysql_free_result($rs_sql); } function queryTopID($id, $tableName){ if($id == "") { return;} $q_sql = mysql_query("select * from $tableName where id=$id"); $q_rs = mysql_fetch_array($q_sql); if($q_rs['parentid'] != 0) { @$rank = $rank + 1; return $this->queryTopID($q_rs["parentid"],$tableName); } else { return $q_rs["id"]; } mysql_free_result($q_sql); } function getSelArray($id, $tableName) { $tempid=$id; $rank = $this->queryRank($id, 0, $tableName); if($rank == -1) { return; } $array = array($rank); for($i = $rank; $i >= 0; $i--){ $arr_sql = mysql_query("select * from $tableName where id=$tempid"); $arr_rs = mysql_fetch_array($arr_sql); $tempid = $arr_rs['parentid']; $array[$i] = $arr_rs['id']; mysql_free_result($arr_sql); } return $array; } //编辑无限分类 function editSelect($classid, $tableName,$disabled=0){ $e_sql = mysql_query("select max(rank) as e_rank from $tableName"); if(mysql_num_rows($e_sql) != 0) { $selArr = $this->getSelArray($classid, $tableName); if(is_array($selArr)){ echo '<script type="text/javascript">$(function(){ changeSelect(0, "class1", '. $this->queryTopID($classid, $tableName).'); });</script>'; } $e_rs = mysql_fetch_array($e_sql); for($i=1; $i <= $e_rs["e_rank"]; $i++){ if($i <= count($selArr)){ $ni = $i + 1; if($i == count($selArr)){ echo "<select name='class$i' id='class$i' onchange='changeSelect(this.value, \"class$ni\")' datatype='*' nullmsg='请选择!'></select> "; } else { if($disabled == 0) {/*禁止选项*/ echo "<select name='class$i' id='class$i' onchange='changeSelect(this.value, \"class$ni\", $selArr[$i])' datatype='*' nullmsg='请选择!'></select> "; } else { echo "<select readonly onmouseover=this.disabled='ture' onmouseout=this.disabled='false' name='class$i' id='class$i' onchange='changeSelect(this.value, \"class$ni\", $selArr[$i])' datatype='*' nullmsg='请选择!'></select> "; } } } if(count($selArr)<$i && $i<$e_rs["e_rank"]){ $ni = $i + 1; echo "<select name='class$i' id='class$i' onchange='changeSelect(this.value, \"class$ni\")' datatype='*' nullmsg='请选择!'></select> "; } if($i == $e_rs["e_rank"] ){ echo "<select name='class$i' id='class$i' datatype='*' nullmsg='请选择!'></select>"; } } mysql_free_result($e_sql); } } //编辑无限分类 function editSelectNum($classid,$templateid,$tableName){ echo '<script type="text/javascript">$(function(){ changeSelect(0, "class1", '.$templateid.'); });</script>'; echo "<select name='class1' id='class1' onchange='changeSelect(this.value, \"class2\",42)' datatype='*' nullmsg='请选择!'></select> "; echo "<select name='class2' id='class2' datatype='*' nullmsg='请选择!'></select>"; } //获取无限分类ID function SelectID(){ for($i=1;$i>0;$i++){ if(@$_POST['class'.$i] == '') { return @$_POST['class'.($i-1)]; } } } }//End ?>