Pass array to where in Codeigniter Active Record

Question

I have a table in my database with adminId and clientId  There might be 20 records with the adminId of the logged in user and I m trying to pull a list of clients   I am wondering if there is a way i can say something like    this- gt db- gt where  id    20    15    22    46    86      I m trying to do this with dynamic data  you never know how many clients Id s you ll need to pull   Any ideas

User · Answer

Generates a WHERE field IN     item        item     SQL query joined with AND if appropriate    this- gt db- gt where in   ex     this- gt db- gt where in  id   array  1   2   3       Generates a WHERE field IN     item        item     SQL query joined with OR if appropriate   this- gt db- gt or where in   ex     this- gt db- gt where in  id   array  1   2   3

User · Answer

this- gt db- gt where in  id     20   15   22   42   86       Reference  where in

User · Answer

From the Active Record docs    this- gt db- gt where in      Generates a WHERE field IN   item    item   SQL query joined with AND if appropriate   names   array  Frank    Todd    James     this- gt db- gt where in  username    names      Produces  WHERE username IN   Frank    Todd    James

User · Answer

Use where in    ids   array  20    15    22    46    86     this- gt db- gt where in  id    ids

[php] Pass array to where in Codeigniter Active Record

Examples related to php

Examples related to codeigniter

Examples related to activerecord