一下是视图层代码
<!DOCTYPE html>
<html>
<head lang="en">
<meta charset="UTF-8">
<title></title>
</head>
<body>
<table>
<select id="countrys" οnchange="sheng('countrys','sheng')"> //括号里第一形参 需要与id一致 方便下面接受id
<option value="-1">请选择</option>
<?php foreach($a as $v){
echo "<option value='".$v['region_id']."'>".$v['region_name']."</option>"; //单引号解析$ 双引号不解析 所以需要拼结
}?>
</select>
<select name="" id="sheng" οnchange="sheng('sheng','shi')"> // id需要与上面括号第二形参一致 用户接受数据
<option value="-1">请选择</option>
</select>
<select name="" id="shi" οnchange="sheng('shi','xian')">
<option value="-1">请选择</option>
</select>
<select name="" id="xian">
<option value="0">请选择</option>
</select>
</table>
</body>
</html>
<script src="<?php echo base_url('jquery-2.1.4.min.js') ?>"></script>
<script>
function sheng(cursel,nextsel){
var id=$("#"+cursel).val();
//alert(id);
$.ajax({
type:"POST",
url:"<?php echo site_url('Welcome/country') ?>",
data:"id="+id,
dataType:"json",
success: function(msg)
{
var str="<option value='-1'>请选择</option>";
for(i in msg)
{
str+="<option value='"+msg[i]['region_id']+"'>"+msg[i]['region_name']+"</option>";
}
$("#"+nextsel).html(str);
}
});
}
</script>
控制器代码
<pre name="code" class="php"><?php
defined('BASEPATH') OR exit('No direct script access allowed');
class Welcome extends CI_Controller {
public function index()
{
$data['a']=$this->db->get_where('ecs_region',array('parent_id'=>0))->result_array(); //数据库用的表 是ecshop的地区表 查询0的地区
// var_dump($data);
$this->load->view('lian.html',$data);
}
public function country(){
$id=$_POST['id'];
$sheng=$this->db->get_where('ecs_region',array('parent_id'=>$id))->result_array();//查询对应下id的地区
echo json_encode($sheng); //转为json格式
}
}