How to populate dropdownlist from database in Codeigniter?

I have two tables: 1. STUDENT- fields are- (studentid,studentname,batch) 2. BATCH- fields are- (batchid,batchname)

I want to populate a dropdown list from the field "batchname" ( from the table "BATCH") and have the batchname selected based on the field-"batch" (from the table "Student")

My controller -

function update($id){
$this->load->model('mod_studentprofile');
$data['query']= $this->mod_studentprofile->student_get($id); //to retrieve information from the table "STUDENT" 
$data['query']= $this->mod_studentprofile->batch_get();

$data['main_content']='update_studentprofile';
$this->load->view('includes/template',$data);
}

My model -

 function batch_get()
{
  $query = $this->db->get('batch');
  return $q开发者_如何学Cuery->result();

}    

Now, I cannot figure out how to populate the dropdown in the "View". Would you please kindly help me with this?

Thanks in Advance.

You need to put the options you want displayed in the drop down into an array, like so

$options = array(
  'red'   => 'Red',
  'green' => 'Green',
  'blue'  => 'Blue',
);

// The params here are:
// 'color'    => name of the drop down
// '$options' => options for the drop down
// 'red'      => the selected value of the drop down
echo form_dropdown('color', $options, 'red');

What I would do is create a function in my model, say $model->dropdown_options() and use that to get the rows from the database and put them into an array.

See Jamie Rumbelow's 'MY_Model' class, he has a method that does exactly what you're describing.

https://github.com/jamierumbelow/codeigniter-base-model/blob/master/core/MY_Model.php