How to give where condition using for loop in Codeigniter

Question

I have an array:

Array
(
    [0] => 9055954
    [1] => 2736738
    [2] => 1234
    [3] => 2844725
)

I need to a where condition to select the ids form database table add_family whose id is not equal to any one of the value in array, I'm using codeigniter, how can I check it using for loop for where condition.

could you please give us more details, ex. your code where is a problem — Tikky
– Tikky, Commented Dec 22, 2016 at 8:19

d.coder · Accepted Answer · 2016-12-22 09:05:48Z

0

You don't really need to run a for loop to do this. You can simply check it by running a simple query which will select all records from table after excluding ids as specified in array:

$ignore_ids = [9055954, 2736738, 1234, 2844725];

$this->db->where_not_in('add_family', $ignore_ids);

answered Dec 22, 2016 at 9:05

d.coder

2,03818 silver badges24 bronze badges

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

Collectives™ on Stack Overflow

How to give where condition using for loop in Codeigniter

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