CODEWITHSUNDEEP
phpsqlcodeigniterquery-builderwhere-in
mrijneveld
mrijneveld

Reputation: 30

CodeIgniter SELECT query WHERE column equals a value and another column has a value found in a whitelist

I have content that i want to filter by a brandname and a permission id and then show it.

my problem is: When i send one value as $permission it works fine. But when a user has multiple permission_id's it doesn't work.

WHERE `permission_id` = 1, 2, 3;

I have a problem with my select query:

$this->db->select('*');
$this->db->from('content');
$this->db->where('brand_name', $brand);
$this->db->where('permission_id', $permission);

SQL:

SELECT *
FROM `content`
WHERE `brand_name` = $brand_name
    AND `permission_id` = $permission;

The print_r of $brand & $permission look like this:

Hyundai
1,10,11,2,3,4,5,6,7,8,9

Upvotes: 0

Views: 4920

Answers (1)

xlecoustillier
xlecoustillier

Reputation: 16351

To test a field against multiple values, your SQL should not look like :

WHERE permission_id = 1, 2, 3;

I don't know what your permission_id field looks like, but I guess your condition should rather be:

WHERE permission_id IN (1, 2, 3);

Try with where_in:

$this->db->where_in('permission_id', $permission);

where $permission is an array containing the permissions (not a comma separated string).

With $permission being a string, use explode:

$this->db->where_in('permission_id', explode(',', $permission));

Upvotes: 3

Related Questions