phpajax实现三级省市区联动-PHP源码

2. [代码][PHP]代码 跳至

public function getdiqudaima(){
		
			$rs = $this->db->table(&＃39;diqudaima&＃39;)
					   ->field("province,city,zonename,zonecode")
					   ->where("areaid=1 ")
					   ->getAll();
			$this->db->lastSql();
			return $rs;
		}
		public function getq($code,$n){
		$where = "and zonecode like &＃39;$code%&＃39;";
			$rs = $this->db->table(&＃39;diqudaima&＃39;)
					   ->field("province,city,zonename,zonecode")
					   ->where("areaid = $n ".$where)
					   ->getAll();
			return $rs;
		}

3. [代码][PHP]代码 跳至

public function showdiqu(){
			$test = load_model(&＃39;Test&＃39;);
			$data = $test->getdiqudaima();
			$this->output->set(&＃39;data&＃39;,$data);
			$this->output->display(&＃39;test.html&＃39;);
			
		}
		public function showcity(){
			$test = load_model(&＃39;Test&＃39;);
			$code = $this->input->getTrim(&＃39;code&＃39;);
			$datacity = $test->getq($code,2);
			echo json_encode($datacity);
		}
		public function showqu(){
			$test = load_model(&＃39;Test&＃39;);
			$code = $this->input->getTrim(&＃39;code&＃39;);
			$datacity = $test->getq($code,3);
			echo json_encode($datacity);
		}

4. [代码][PHP]代码 跳至

请选择市"); 		
				for(var p in obj){
					$("#city").append(""+obj[p].zonename+"");
				    
				}
			}
		);	
	}
	function getq(){
		var a = $("#pro").val();
		$.post("?c=Test&a=showqu",{code: a},
			function(data){
				var obj = eval(&＃39;(&＃39;+data+&＃39;)&＃39;);
				$("#zone").empty();
				$("#zone").prepend("请选择区"); 		
				for(var p in obj){
					$("#zone").append(""+obj[p].zonename+"");
				    
				}
			}
		);
	}
" _ue_custom_node_="true">