如何从数组变量中获取查询中的数组值[关闭]

Question

I have a model like this

function show_city_n_area_from_id($data){ // $data is an array of ids
    $this->db->select('column1');
    $this->db->from('table');
    $this->db->where('id', $data);
    $query = $this->db->get();
    $query_result = $query_array();
    return $query_result;
}

I am trying to extract all the values from 'column1' in the form of an array from '$data' which is an array of several ids.

Thanks in advance.

I get error:

Unknown column 'Array' in 'where clause' SELECT column1 FROM table WHERE id = Array

Answer 1

As per your comments $data is an array of ids so you need to use where_in like:

$this->db->where_in('id', $data);

Modified code:

function show_city_n_area_from_id($data){ 
   $this->db->select('column1'); 
   $this->db->from('table'); 
   $this->db->where_in('id', $data); 
   $query = $this->db->get(); 
   $query_result = $query_array(); 
   return $query_result; 
}

You can also explore the CI User Guide

UPDATE 1:

As per your comments you have ids inside the object so you can convert it into an array as:

$dbIDS = array();
foreach($data['ids'] as $value){
    $dbIDS[] = $value->vbc_item_id;
}

Now you can use $dbIDS in where_in