Codeigniter query builder WHERE clause method to check if column value exists in a whitelist

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->db->where('id', '20 || 15 || 22 || 46 || 86');

I'm trying to do this with dynamic data (you never know how many clients Ids you'll need to pull).

Rohan Kumar · Accepted Answer · 2020-03-05 17:32:58Z

104

$this->db->where_in('id', ['20','15','22','42','86']);

Reference: where_in

edited Mar 5, 2020 at 17:32

Rohan Kumar

40.7k11 gold badges81 silver badges111 bronze badges

answered Dec 5, 2012 at 6:36

joHN

1,8054 gold badges16 silver badges31 bronze badges

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

Comments

Stanley · Accepted Answer · 2021-02-26 14:35:51Z

19

Use where_in()

$ids = array('20', '15', '22', '46', '86');
$this->db->where_in('id', $ids );

edited Feb 26, 2021 at 14:35

answered Dec 5, 2012 at 6:34

Stanley

5,1374 gold badges37 silver badges44 bronze badges

Comments

Osiris · Accepted Answer · 2012-12-05 06:34:52Z

12

From the Active Record docs:

$this->db->where_in();

Generates a WHERE field IN ('item', 'item') SQL query joined with AND if appropriate

$names = array('Frank', 'Todd', 'James');
$this->db->where_in('username', $names);
// Produces: WHERE username IN ('Frank', 'Todd', 'James')

answered Dec 5, 2012 at 6:34

Osiris

4,2132 gold badges24 silver badges53 bronze badges

Comments

Thiyagu · Accepted Answer · 2017-06-07 11:45:19Z

5

Generates a WHERE field IN (‘item’, ‘item’) SQL query joined with AND if appropriate,

$this->db->where_in()
ex :  $this->db->where_in('id', array('1','2','3'));

Generates a WHERE field IN (‘item’, ‘item’) SQL query joined with OR if appropriate

$this->db->or_where_in()
ex :  $this->db->where_in('id', array('1','2','3'));

answered Jun 7, 2017 at 11:45

Thiyagu

7863 gold badges11 silver badges30 bronze badges

Collectives™ on Stack Overflow

Codeigniter query builder WHERE clause method to check if column value exists in a whitelist

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related