Pass array to where in Codeigniter Active Record

php codeigniter activerecord
Daniel White picture Daniel White · Dec 5, 2012 · Viewed 114.2k times · Source

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 Id's you'll need to pull). Any ideas?

Answer

joHN picture joHN · Dec 5, 2012 
$this->db->where_in('id', ['20','15','22','42','86']);

Reference: where_in

Related questions

How to add an ORDER BY clause using CodeIgniter's Active Record methods?

I have a very small script to get all records from a database table, the code is below. $query = $this->db->get($this->table_name); return $query->result(); Using this syntax, how would I add a …

Read More
Getting data posted in between two dates

How can I retrieve data from the database by querying records between two dates using CodeIgniter's activerecord?

Read More
How to select rows where column value IS NOT NULL using CodeIgniter's ActiveRecord?

I'm using CodeIgniter's Active Record class to query the MySQL database. I need to select the rows in a table where a field is not set to NULL: $this->db->where('archived !=', 'NULL'); $q = $this->db-&…

Read More