drh19790711 2019-07-31 01:11
浏览 53

codeigniter依赖的下拉列表

Dear I need your help! I have two drop-down lists that work correctly. One is ciudades and the other comunas, the problem is that I need the comunas list to be dependent on ciudades, for example that when selecting a ciudad from the list, I load the comunas associated with the id of the selected ciudad.

This is my code!

<!-- language: lang-or-tag-here -->

    <label>Ciudad:</label><select class="form-control" name="ciudad" required autocomplete="off">
  <option value="">Seleccione</option>
    <?php foreach($listaciudades as $ciudad):?>

        <option value="<?= $ciudad['idciudad']?>"
            <?php if ($ciudad == $ciudad['idciudad']) : ?> selected<?php endif; ?>
        >
            <?= $ciudad['nombre']?>
        </option>
    <?php endforeach; ?>
</select> 

   <p><label>Comuna:</label> <select id='comuna' name="comuna" autocomplete="off" required value="<?php echo $comuna; ?>"><?php echo form_error("comuna","<span class='help-block'>","</span>") ?>


    <option value="">Seleccione</option>
    <?php
    foreach($listacomunas as $comuna)
    {
        echo '<option value="'.$comuna['idcomuna'].'">'.$comuna['nombre'].'</option>';
    }
    ?>  
 </select>
  • 写回答

1条回答 默认 最新

  • doureng5668 2019-08-02 11:13
    关注
    You can apply ajax to achieve the desired result.
Lets try this sample code

addemp.php ( my view page)
--------------------------
<head><script type="text/javascript" src="<?php echo base_url();?>js/jquery-1.10.2.js"></script>
        <script src="http://code.jquery.com/jquery-1.9.1.js"></script>
        <script src="http://code.jquery.com/ui/1.10.3/jquery-ui.js"></script>
        <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.1.0/jquery.min.js"></script>
</head>
<div class="col-sm-4">
<div class="form-group">
<label>Country <label>                                        
<select class="select" id="selCountry" name="selCountry" onChange="getstate(this.value)" >
<option value="0">Select</option>
 <?php if($con){ foreach($con as $val) { ?>
<option value="<?php echo $val['id']; ?>" <?php if(isset($country)){if($country==$val['id']) echo 'selected="selected"'; }else{echo set_select('selCountry', $val['id'], False);} ?> ><?php echo $val['con_name']; ?></option>
  <?php }} ?>
</select>
<span style="color:red"><?php echo form_error('selCountry'); ?></span>
</div>
<div>
<div class="col-sm-4">
<div class="form-group">
<label>State/Province/Region<label> 
<select class="select" id="selState" name="selState" onChange="getcity(this.value)">
<option value="0" selected="selected">Select</option>
</select>
<span style="color:red"><?php echo form_error('selState'); ?></span>
</div>
</div>  
<script>
function getstate(id)
{       
//alert('this id value :'+id);
$.ajax({    
type: "POST",
url: '<?php echo base_url();?>index.php/employee/getState/'+id,
// data: id='country_id',
success: function(data){
//alert(data);
$('#selState').html(data);
},
});
}
</script>
<script type="text/javascript" src="<?php echo base_url();?>css_style/js/jquery-3.2.1.min.js"></script> 

Employee.php(mycontroller)
-------------------------
public function getState($id)
{
    $data['state'] = $this->Emp_model->getState($id);
    $this->load->view('ajax_state_view',$data); 
}


ajax_state_view.php ( my ajax view page)
---------------------------------------
<option value="0"> Select </option>
<?php if($state){ foreach($state as $val) { ?>
<option value="<?php echo $val['id']; ?>" ><?php echo $val['state_name']; ?></option>
<?php }} ?>


Emp_model.php ( my model page)
-------------------------------
public function getState($id) {
$where  =   array("country_id"=>$id);
this->db->select('*');
$this->db->from('state');
$this->db->where($where);           
$query = $this->db->get();
//echo $this->db->last_query();exit;
return $query->result_array();
}
    评论

报告相同问题？

悬赏问题

  • ¥20 基于MSP430f5529的MPU6050驱动，求出欧拉角
  • ¥20 Java-Oj-桌布的计算
  • ¥15 powerbuilder中的datawindow数据整合到新的DataWindow
  • ¥20 有人知道这种图怎么画吗？
  • ¥15 pyqt6如何引用qrc文件加载里面的的资源
  • ¥15 安卓JNI项目使用lua上的问题
  • ¥20 RL+GNN解决人员排班问题时梯度消失
  • ¥60 要数控稳压电源测试数据
  • ¥15 能帮我写下这个编程吗
  • ¥15 ikuai客户端l2tp协议链接报终止15信号和无法将p.p.p6转换为我的l2tp线路