How to use a comma-separated string in CodeIgniter's where_in() method

Question

I have some id stored in database table with column name "defaultdest" like "1,2,3,4,5,6". I have fetched it in controller and now I need to make query in my another table that is named "destinations". where I need to fetch the destinations according to Ids is "1,2,3,4,5,6".

here is the query result from another table

public function index()
{
    $data = $this->data;
    $idlists = explode(",", get_option('defaultdest'));
    $data['destlist'] = $this->ui_model->destfetch($idlists);
    $this->load->view('themes/ui/home/'.get_option('uihometype').'', $data);
}

This is my database query in model

function destfetch($idlists)
{
    $this->db->set_dbprefix('');
    $this->db->select('*');
    $this->db->where_in('id', $idlists);
    $this->db->from("destinations");
    $query = $this->db->get();

    //print_r($this->db->last_query());
    return $result = $query->result_array();   
}

Note: idlists values are (returned by get_option method)

$idlists = "1,2,3,4,5,6";

This is not working, getting blank results.

Have you checked printing you query that you have commented in your code print_r($this->db->last_query());, what are you getting in query can you show us and add in question.. — turivishal
– turivishal, Commented Jul 2, 2020 at 4:37

KUMAR · Accepted Answer · 2020-11-09 20:30:20Z

2

Where_in works with array not a string. So your $idlists shouldn't be a string with '1,2,3,4,5' but an array of ids.

You can do this by just doing:

$idlists = "1,2,3,4,5,6";            //String
$this->db->where_in('id', explode(',', $idlists));

Note:- explode() use for breaks a string into an array.

edited Nov 9, 2020 at 20:30

KUMAR

2,0952 gold badges14 silver badges27 bronze badges

answered Jul 2, 2020 at 8:26

marcogmonteiro

2,1571 gold badge17 silver badges26 bronze badges

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

Collectives™ on Stack Overflow

How to use a comma-separated string in CodeIgniter's where_in() method

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