Pass array in the CodeIgniter query

Question

I want to pass an array in codeigniter query. Below is my code.

Controller

 foreach($array as $values) {
    $array_values = $values['download_subcategory_name'];
    }
$this->data['get_downloads_content'] = $this->my_model->get_downloads_content($array_values );

Model

public function get_downloads_content($array_values ){
        $this->db->select('*');
        $this->db->from('my_table');
        $this->db->where_in('download_subcategory_name', $array_values );
        $this->db->order_by('download_id', 'ASC');
        $query = $this->db->get();
        return $query->result();
    }

My problem is query showing results for only last value of array instead of all array values. Please help.

Narendrasingh Sisodia · Accepted Answer · 2015-05-02 10:47:09Z

1

Just need little changes within foreach

$array_values = array();
foreach($array as $values) {
    $array_values[] = $values['download_subcategory_name'];
                 ^^^
}

OR

$array_values = array();
foreach($array as $key => $values) {
    $array_values[$key] = $values['download_subcategory_name'];
                 ^^^^^^
}

Within your code it's storing only the last value from the foreach loop thats why it only gets the single value stored within it.

answered May 2, 2015 at 10:47

Narendrasingh Sisodia

21.4k6 gold badges51 silver badges54 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Pass array in the CodeIgniter query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related