how to do dynamic drop down menu.

[Bhavani Dasari]

Hi,

I'm new to Codeigniter framework and I created a basic drop down menu but i need dyanamic drop down menu using xampp server in php .

Please guide me

Thanks

bhavani.

[Damir Sović]

Actually, it is not that hard.

1. In database create a table, say, "Items" with fields "code" as varchar(8) and "name" as varchar(45). Fill some data in it.

2. In Model (let's call it "Mydb_model"):

function getItems(){

    $this->db->select('name')

    $res = $this->db->get('items');

    return $res->row_array();

}

3. In Controllers, in function where You want to pass the items:

    $this->load->model('Mydb_model');

    $data["items"] = $this->Mydb_model->getItems();

    ...

    $this->load->view("myPageWhereIsDropdown", $data);

4. In View create page "myPageWhereIsDropdown.php" with code:

    echo form_dropdown('items', $items);

or, using foreach:

4. <select name="items">

<?php foreach($items as $item): ?>

<option name="<?php echo item['code']; ?>"><?php echo item['name'];</option>

<?php endforeach; ?>

(in this case, remove "select" line from Model