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);
}
}
