get_select_option function with where clause

Question

I am newbie to php I need help I want to add where clause to this 'get_select_option'

my get_select_option code is here

function get_select_option($table,$id,$name,$selected=0){
  $query = $this->db->get($table);
  $select = '<option value="">SELECT</option>';
  if($query->num_rows()>0){
   foreach($query->result_array() as $row){
   $selected_option = ($selected==$row[$id]) ? ' selected="selected" ':' ';
    $select.='<option value="'.$row[$id].'" '. $selected_option.'>'.trim(strtoupper($row[$name])).'</option>';
   }
  }
  return $select;
 }

http://stackoverflow.com/a/8541303/689579? – Sean Jun 03 '15 at 04:48 — Sean, Jun 03 '15 at 04:48

score 1 · Answer 1 · answered Jun 03 '15 at 04:48

1

In Codeigniter you can set the where clause by using $this->db->where();. The code will be -

$this->db->where('fieldname', 'valuetomatch');
$query = $this->db->get($table);

answered Jun 03 '15 at 04:48

Sougata Bose

31,517
8
49
87

score 0 · Answer 2 · answered Jun 03 '15 at 04:50

Use this line $this->db->where('column_name','your_value'); in the below function above your $query = $this->db->get($table); statement

function get_select_option($table,$id,$name,$selected=0){
            $this->db->where('column_name','your_value');
            $query = $this->db->get($table);
            $select = '<option value="">SELECT</option>';
            if($query->num_rows()>0){
                foreach($query->result_array() as $row){
                $selected_option = ($selected==$row[$id]) ? ' selected="selected" ':' ';
                    $select.='<option value="'.$row[$id].'" '. $selected_option.'>'.trim(strtoupper($row[$name])).'</option>';
                }
            }
            return $select;
        }

welcome...dont forget to accept if this solved your problem :) — Abhinav, Jun 03 '15 at 15:21

get_select_option function with where clause

2 Answers2