Codeigniter - Return an array from where_in query

Question

I'm trying to receive an array from a query "where_in" in Codeigniter:

$this->db->select('file_name');
$this->db->from('images_table');
$this->db->where_in('id', $id_array_img);

$result = $this->db->result_array();

print_r($result);

But doesn't work; why?

look at the active record documentation

Dan
– Dan

2014-05-25 12:24:37 +00:00
Commented May 25, 2014 at 12:24 — Dan
– Dan, Commented May 25, 2014 at 12:24

Parag Tyagi · Accepted Answer · 2014-05-25 11:38:20Z

1

Your have forgot to do the:

$this->db->get();

Your model should be like:

<?php
class Your_model extends CI_Model
{
    public $db;
    public function __construct()
    {
       parent::__construct();
       $this->db = $this->load->database('default',true);     
    }

    public function function_name()
    {
        $this->db->select('file_name');
        $this->db->from('images_table');
        $this->db->where_in('id', $id_array_img);            
        $query = $this->db->get();                   // add this

        $result = "";
        if($query->num_rows() > 0)
            $result = $query->result_array();
        else
            $result = "No result";

        print_r($result);
    }
}

Explanation:

Without $this->db->get();, you are just generating the query, but not firing it.

answered May 25, 2014 at 11:38

Parag Tyagi

9,0003 gold badges45 silver badges50 bronze badges

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

Collectives™ on Stack Overflow

Codeigniter - Return an array from where_in 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