Combining codeigniter active records function with regular sql statement

Question

Is it possible to use codeigniter active records functions as an add on to the end of a regular sql statement? Something like this :

$sql = "SELECT * FROM test WHERE id = 'red'";
$this->db->WHERE_IN('code', $array);
$query = $this->db->get($sql);
return $query->result();

I really need the where_in function so i can apply an array of values, in which the number of values is constantly changing

Why do I want to do it this way instead of just doing it all in active records function? Because when I used just active records functions, I kept getting errors, and I don't want to spend more time smashing my head against the table in frustration.

Nope, as far as i know its not possible. implode() your array in a string and use a regular query. — Nil'z
– Nil'z, Commented Oct 23, 2013 at 15:22
You might be best to ask why you're getting the errors, as AR can be very useful to run your queries — olimortimer
– olimortimer, Commented Oct 23, 2013 at 15:31

Sjerdo · Accepted Answer · 2013-10-23 15:33:38Z

1

Try like this:

$imploded_array  = implode(",", $array);
$sql = "SELECT * FROM test WHERE id = 'red' AND code IN ({$imploded_array})";
//$this->db->WHERE_IN('code', $array);
$query = $this->db->get($sql);
return $query->result();

edited Oct 23, 2013 at 15:33

Sjerdo

1871 silver badge4 bronze badges

answered Oct 23, 2013 at 15:25

Nil'z

7,4831 gold badge20 silver badges28 bronze badges

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

1 Comment

EnigmaMaster Over a year ago

That worked, except when it hits ({$imploded_array}) its giving me (value,value), I need it to be ('value','value') or else i just get errors

Collectives™ on Stack Overflow

Combining codeigniter active records function with regular sql statement

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related