级联为什么没有在国家和国家工作
问题描述:
enter image description here级联为什么没有在国家和国家工作
为什么发生这种情况,他们分别是视图模型控制器。
我的代码没有运行,但它从数据库中获取数据。 我如何解决这个问题,请帮助我。
并提前致谢。
function getcountry()
{
$this->db->select('*');
$query = $this->db->get('et_country');
return $query->result();
}
function getstate($country_id='')
{
$array = array('status' => 'Active','country_id' => $country_id);
$this->db->select('id,name,country_id');
$this->db->where($array);
$query = $this->db->get('et_state');
return $query->result();
}
function getcity($state_id='')
{
$array = array('status' => 'Active','state_id' => $state_id);
$this->db->select('id,name,state_id');
$this->db->where($array);
$query = $this->db->get('et_city');
return $query->result();
}
public function create_subadmin()
{
$this->load->model('Auction_model');
$data['country'] = $this->Auction_model->getcountry();
$this->load->view('admin/Auction/add_Auction',$data);
}
public function ajax_state_list($country_id)
{
$this->load->model('Auction_model');
$data['state'] = $this->Auction_model->getstate($country_id);
$this->load->view('admin/Auction/add_Auction',$data);
}
public function ajax_city_list($state_id)
{
$this->load->model('Auction_model');
$data['city'] = $this->Auction_model->getcity($state_id);
$this->load->view('admin/Auction/add_Auction',$data);
}
<script>
function getstatedetails(id)
{
//alert('this id value :'+id);
$.ajax({
type: "POST",
url: '<?php echo site_url('admin/Auction_controller/ajax_state_list').'/';?>'+id,
data: id='cat_id',
success: function(data){
// alert(data);
$('#old_state').html(data);
},
});
}
</script>
<script>
function getcitydetails(id)
{
$.ajax({
type: "POST",
url: '<?php echo site_url('admin/Auction_controller/ajax_city_list').'/';?>'+id,
data: id='st_id',
success: function(data){
$('#old_city').html(data);
},
});
}
</script>
<div class="form-group">
<label>Country</label><br>
<select name="country_id" class="form-control" id="country_details" onChange="getstatedetails(this.value)">
<option value="<?php echo $rs->name ?>" selected="selected" >Select</option>
<?php
foreach ($country_id as $rs) {
?>
<option value="<?php echo $rs->id; ?>"><?php echo $rs->name ?></option>
<?php } ?>
</select>
</div>
<div class="form-group">
<label>State</label><br>
<select name="state_id" class="form-control" id="old_state" onChange="getstatedetails(this.value)">
<option value="<?php echo $rs->name ?>" selected="selected" >Select</option>
<?php
foreach ($state_id as $rs) {
?>
<option value="<?php echo $rs->id; ?>"><?php echo $rs->name ?></option>
<?php } ?>
</select>
</div>
<div class="form-group">
<label>City</label><br>
<select name="city_id" class="form-control" id="old_city" onChange="getcitydetails(this.value)">
<option value="" selected="selected" >Select</option>
<?php
foreach ($city_id as $rs) {
?>
<option value="<?php echo $rs->id; ?>"><?php echo $rs->name ?></option>
<?php } ?>
</select>
</div>
答
尝试改变AJAX调用这样的:
VAR值= { 'CAT_ID':ID };
$.ajax({
url: "<?php echo site_url('admin/Auction_controller/ajax_state_list').'/';?>"+id,
type: "post",
data: values,
success: function(data) {
$('#old_state').html(data);
}
});
它仍然无法正常工作,请你给我一些其他答案 –
你会得到什么错误?你可以检查吗? –
它不会有任何错误发生的是当我选择国家它会取得国家,但它使国家选项空白。即使在选择任何国家 –