I am new in CodeIgniter and working on a application in which i have a form. In this form I have a dropdown. I have some values in a column of database. I want these values in the dropdown, I have no idea how to do it.
My view is:
<tr> <td>Moderator :</td> <td><label for="select"></label> <select name="mod" tabindex="1" > <!--values i want from database--> </select> </td> </tr> This example is for a country table in our application, the table contains, id, symbol, name
Controller:
$data['countries']=$this->countries_model->get_countries(); $this->load->view('countries',$data); Model:
function get_countries() { $query = $this->db->get('countries'); if ($query->num_rows >= 1) { foreach($query->result_array() as $row) { $data[$row['countryId']]=$row['countryName']; } return $data; } } It returns an array like:
$id=>$name 0=>Canada 1=>United States View:
echo form_dropdown('countries',$countries); //ci syntax Or:
<select name="country"> <?php foreach($countries as $country) { echo '<option value="'.$country['id'].'">'.$country['name'].'</option>'; } ?> </select> 
<?php class Member_model extends CI_Model{ var $table = 'tbl_member'; public function __construct(){ parent::__construct(); $this->load->database(); } public function get_all_members(){ $this->db->from('tbl_member'); $query=$this->db->get(); return $query->result(); } public function get_by_id($id){ $this->db->from($this->table); $this->db->where('member_id',$id); $query = $this->db->get(); return $query->row(); } public function member_add($data){ $this->db->insert($this->table, $data); return $this->db->insert_id(); } public function member_update($where, $data){ $this->db->update($this->table, $data, $where); return $this->db->affected_rows(); } public function delete_by_id($id){ $this->db->where('member_id', $id); $this->db->delete($this->table); } } 
