CODEWITHSUNDEEP
phparrayscodeigniter
Kelvin
Kelvin

Reputation: 1114

how to get all data in array for where clause in codeigniter

this is my vardump which return array :

array(5) {
  [0]=>
  string(1) "1"
  [1]=>
  string(1) "5"
  [2]=>
  string(1) "9"
  [3]=>
  string(2) "13"
  [4]=>
  string(2) "17"
}

that array is $cuisines_category

i need to get that 1,5,... for where clause, i have tried this to get all the value : 

foreach($cuisines_category as $key => $value){
        $cuisines_category_all = $this->Control_panel_m->m_get_cuisines_name_by_id($value);
    }

but its only returing 1 value. I need to return all of them

guys can you help me how to get it?

thank you (:

p.s the long of array can be change

Upvotes: 0

Views: 100

Answers (1)

charlietfl
charlietfl

Reputation: 171669

You overwrite the same variable $cuisines_category_all in each iteration of the loop so it will only contain the value from last iteration

Perhaps you want it to be an array in which case do

foreach($cuisines_category as $key => $value){          
      $cuisines_category_all[] = $this->Control_panel_m->m_get_cuisines_name_by_id($value);
}

Upvotes: 1

Related Questions