Get database value based on dropdown value in Codeigniter using AJAX

Question

I want to retrieve value from database based on dropdown value using the ajax.
Here I'm attaching the screenshot thats what exactly I need. Once we change the year the result should be changed.

So please help me to do this task. Thanks in Advance :)

Saugat Thapa · Accepted Answer · 2016-08-09 09:08:12Z

1

<script type="text/javascript">
jQuery(document).ready(function(){
  $("#district").change(function() {
    var vdcID = {"district_id" : $('#district').val()};
      $.ajax({
      type: "POST",
      data: vdcID,
      url: "<?php echo base_url(); ?>admin/ajax/showVdcById",
      dataType: 'json',
    success: function(data){
      $('#vdc').html("<option>Please Select VDC</option>  ");
        $.each(data, function(i, data){
             $('#vdc').append("<option value='"+i+"'>"+data+"</option>");
        });
       }
     });
   });
 });

this code might help you. it takes value from from a dropdown and updates value on another dropdown based on the id it sends to database

answered Aug 9, 2016 at 9:08

Saugat Thapa

3825 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Shihas Over a year ago

Thanks. This solution helped me to reach to the solution somewhat .

Shihas Over a year ago

Brother, it's helped me a lot and I would like to upvote but StackOverflow is not allowing me to do that. :( I don't have much reputation.

Swapnil Mahadik · Accepted Answer · 2016-08-09 12:02:58Z

1

Add onchange event updateMonths() to year select tag

function updateMonths()
    {
        var selectedYear    =   $('#year').val();

        if(selectedYear!= "")
        {

            $.ajax({
                      type: "POST",
                      data: { "year":selectedYear },
                      url: "<?php echo base_url(); ?>admin/ajax/getAllMonths",
                      dataType: 'json',
                        success: function(data){

                            $.each(data, function(i, data){

                                $('#month').append($('<option>', {
                                            value: i,
                                            text: data
                                    }));
                            });
                        }
                    }); 
        }       
    }

answered Aug 9, 2016 at 12:02

Swapnil Mahadik

7045 silver badges3 bronze badges

1 Comment

Shihas Over a year ago

i don't want to update the value in month drop down. I just want to pass the value to my controller when we select any of the year.

Mayank Pandeyz · Accepted Answer · 2016-12-27 05:58:38Z

1

There are two ways to do it:

On drop down change you can reload the entire page with appending the year in url of the page and show your result on the basis of that url appended year value.
You can use ajax call on change of year drop down and load the specific content in a div.

ajax method:

var dropdownSelection = $('#dropdown_id').val();
$.ajax({
    url         : 'proccess.php',
    method      : 'get',
    data       :
    {
        selection : dropdownSelection,

    },
    success    : function(response)
    {
        $('#div_result').html(response);
    }
});

edited Dec 27, 2016 at 5:58

answered Aug 9, 2016 at 8:26

Mayank Pandeyz

26.3k4 gold badges43 silver badges61 bronze badges

Collectives™ on Stack Overflow

Get database value based on dropdown value in Codeigniter using AJAX

3 Answers 3

2 Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related