从select中选择一个选项,然后使用Codeigniter在另一个选择框上显示数据


Choosing an option from select and then show data on another select box using Codeigniter

我不太擅长jquery和ajax,现在我在选择框方面遇到了困难。我使用CI,我的代码如下。

 <select name="brand" class="form-control" id="brand" required>
      <?php
        if($items) {
          foreach($items as $key) {
      ?>
      <option value="<?php echo $key->brand_id ?>">
        <?php echo $key->brand_name ?></option>
      <?php
        }
       }
      ?>
    </select>

并且,另一个选择框"类别"数据将根据"品牌"显示。如何使用jquery携带来自"品牌"的数据并在"类别"中显示数据?

您可以使用ajax。参见以下示例

$(function(){
  $('#brand').on('change', function(){
    var brand = $(this).val();
    $.ajax({
     type : 'post',
     url : '<?php echo base_url();?>controller_name/function_name',
     data : 'brand='+brand,
     dataType : 'json',
     success : function(msg){
        // here you can populate data into category select option
       var options;
       for(var i = 0; i<msg.length; i++)
       {
          options = '<option>'+msg.category[i].category_name+'</option'>;
       }
       $('#category').html(options); // your html part for category should look like this <select id="category"></category>
     }
   });
});
});

控制器部分的php代码(函数名showCategory)

function showCategory(){
  $brand = $this->input->post('brand');
  $data['category'] = $this->your_model->your_function_to_select_data();
  echo json_encode($data);
}
            <?php
            ?>
            <select name="brand" class="form-control" id="brand" required>
                  <?php
                    if($items) {
                      foreach($items as $key) {
                  ?>
                  <option value="<?php echo $key->brand_id ?>">
                    <?php echo $key->brand_name ?></option>
                  <?php
                    }
                   }
                  ?>
                </select>
                <p>Category:</p>
                <select name="category">
                <!--Content will be popullated from ajax call-->
                </select>
            <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1/jquery.js">    </script>
            <script type="text/javascript">
            (function($){
                $(function(){
                    $(document).on('change' , '[name=brand]', function(){
                        var brand_selected = $(this).val();
                        $.ajax({
                            url: '[your url to fetch category based on categoryid]' ,
                            dataType:"json",
                            data: {brand : brand_selected},
                            success: function(r){
                                /**
                                 * your response should be in json format
                                 * for easy work
                                 {catd_id: catname, cat_id :catname}
                                 */
                                 var html = '';
                                 if(r && r.length){
                                    $.each(r, function(i, j){
                                        html +='<option value="'+i+'">'+j+'</option>';
                                    })
                                 }
                                /**
                                 * finaly populat ethe category data
                                 */
                                 $('[name="category"]').html(html);
                            }
                        })
                    })
                })
            })(jQuery)
            </script>

根据您的口味更改份量。。。

使用此方法来检测select标记值的变化。

$( "#brand" ).change(function() {
  var myOption = $(this).val();
  // use ajax to get data for 'category' select by using "myOption"
});
然后当您得到ajax响应时,使用添加新的select标签

for (var i = 0 ; i < response.length; i++)
  {
    $('#category').append('<option>'+response[i]+'</option>')
  }

我仍然没有得到所需的答案。以下是我的看法。

<select name="brand" class="form-control" id="brand" required>
    <?php
        if($items) {
            foreach($items as $key) {
    ?>
    <option value="<?php echo $key->brand_id ?>">
        <?php echo $key->brand_name ?>
    </option>
    <?php
            }
        }
    ?>
</select>
<select name="category" class="form-control" id="category" required>
</select>

Ajax:

<script>
    $(function() {
        $("#brand").on('change', function() {
            var brand = $(this).val();
            $.ajax ({
                type: "post",
                url: "<?php echo base_url(); ?>receiving/showCategory",
                dataType: 'json',
                data: 'brand='+brand,
                success: function(msg) {
                    var options;
                    for(var i = 0; i<msg.length; i++) {
                        options = '<option>'+msg.category[i].category_name+'</option'>;
                    }
                    $('#category').html(options);
                }
            });
        });
    });
</script>

我的控制器:

    function showCategory() {
        if($this->session->userdata('success')) {
            $brand_id = $this->input->post('brand');
            $data['category'] = $this->item_model->category($brand_id);
            echo json_encode($data);
        } else {
            //If no session, redirect to login page
            redirect('login', 'refresh');
            $this->load->helper('url');
        }
    }

我的分类表包含:category_id、category_name、brand_id。