Populating <select> with mysql data dynamically using CodeIgniter

Question

I'm stacked on this matter. I have a model that retrieves data from a mysql database

class load_model extends CI_Model{
function __construct(){
parent::__construct();
}
Function loadsuppliers()
{       
    $this->db->select('SupplierID, Name');
    $records=$this->db->get('supplier');
    $data=array();

    foreach ($records->result() as $row)
    {
        $data[$row->SupplierID] = $row->Name;
    }
    return ($data);
}

} ?>

This model submits value to a function in my controller

public function getSupplier()
{
    $this->load->model('load_model');
    $data['unit'] = $this->load_model->loadsuppliers();
    $this->load->view('SupplierMGT', $data);

}

and I want to display the retrieved data to my view as a combo box. I tried to check if I am able to retrieve database values using echo json_encode($data) and it returns {"unit":{"2":"test","3":"Delta"}} ,

Could you help me with this? I tried using

<?php foreach($unit as $result):
print_r($result); 
endforeach;?>

to check if i am able to pass the value but i failed.

what are you getting in $data['unit'] in controller?

ABorty
– ABorty

2013-07-29 13:42:39 +00:00
Commented Jul 29, 2013 at 13:42 — ABorty
– ABorty, Commented Jul 29, 2013 at 13:42

Nil'z · Accepted Answer · 2013-07-29 13:48:10Z

1

Small changes in the model:

function loadsuppliers()
{       
    $this->db->select('SupplierID, Name');
    $records=$this->db->get('supplier');
    $data=array();
    if($records->num_rows() > 0){
        $data   = $records->result_array();
    }
    return ($data);
}

In your view SupplierMGT.php write this:

<select name="" id="" multiple="">
    <?php
        if(isset($unit) && is_array($unit) && count($unit) > 0){
            foreach($unit as $key=>$each){

    ?>
    <option value="<?=$each['SupplierID']?>"><?=$each['Name']?></option>
    <?php
            }
        }
    ?>
</select>

answered Jul 29, 2013 at 13:48

Nil'z

7,4831 gold badge20 silver badges28 bronze badges

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

2 Comments

Umpong_1947676 Over a year ago

Oh Thanks for that, i did not notice that my code is somehow working.... This idea is really helpful @Niloy Saha

Nil'z Over a year ago

Happie to help. Accept the answer if it helped you.

Collectives™ on Stack Overflow

Populating <select> with mysql data dynamically using CodeIgniter

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related