Refreshing a dropdown list when selecting another dropdown list.

Refreshing a dropdown list when selecting another dropdown list. - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Libraries & Helpers (https://forum.codeigniter.com/forumdisplay.php?fid=22)
+--- Thread: Refreshing a dropdown list when selecting another dropdown list. (/showthread.php?tid=10906)

Pages: 1 2 3

Refreshing a dropdown list when selecting another dropdown list. - El Forum - 11-14-2009

[eluser]Bui Duc Long[/eluser]
[quote author="hugle" date="1258065297"]hi,

I have done something similar you are asking, using CI and jQuery,
you can take a look here:
http://demo3.invista.lt/search/page/1/loans/giving_and_requesting

If you liek it, I can share the code Smile

[/quote]

hey mate, I like it Big Grin

Refreshing a dropdown list when selecting another dropdown list. - El Forum - 11-17-2009

[eluser]doob[/eluser]
Maybe this can help you.

View 1

Code:
<select name="state" id="selectstate">

    <option value="1">State 1</option>

    <option value="2">State 2</option>

    <option value="3">State 3</option>

    <option value="4">State 4</option>

</select>

<div id="citieswrapper">

<select name="city" id="selectcity">

    <option value="">- Select state</option>

</select>

</div>

jQuery

Code:
$("#selectstate").bind("change",function(){

    $("#citieswrapper").load("/ajax/get_city", {state_id: $(this).val()} );

});

Controller

Code:
&lt;?php

class Ajax extends Controller {

    function Ajax()

    {

        parent::Controller();

        $data = array();

    }

    function index()

    {

    }

    function get_city()

    {

        // Load location model

        $this->load->model('location_model', 'location');

        // Which state to load?    

        $state_id = $this->input->post('state_id');

        $data['cities'] = $this->location->get_cities_in_state($state_id)->result();

        $this->load->view('ajax/city_list', $data);

    }

}

Model

Code:
&lt;?php

class Location_Model extends Model 

{

    function Location_Model()

    {

        parent::Model();

        $this->_city_table = "cities";

    }

    function get_cities_in_state($state_id)

    {

        $this->db->where('state_id', $state_id);

        $this->db->order_by('city_name');

        return $this->db->get($this->_city_table);

    }

View: ajax/city_list.php

Code:
<select name="city">

    &lt;?php foreach($cities as $city) : ?&gt;

        <option value="&lt;?php echo $city->city_id; ?&gt;">&lt;?php echo $city->city_name; ?&gt;</option>

    &lt;?php endforeach; ?&gt;

</select>

DB-table: cities

Code:
id        state_id        city_name

1        1                City 1

2        1                City 2

3        2                A city in state 2

4        3                Another city in state 2

5        4                City in state 4

6        4                City two in state 4

Refreshing a dropdown list when selecting another dropdown list. - El Forum - 12-04-2009

[eluser]alberta[/eluser]
Hi,

I have used the above code and it works fine. I have used it in form but problem is that when form is submitted, value returned by second drop down menu i.e filtered city is empty.

Where is the problem ?

Thanks