How to compare array value with column in codeigniter database query

Question

I am using codeigniter with php. I want to get values from database table by comparing a column. The problem is the value coming from html code to compare with column is checkbox value and array. I want something like it, HTML

<input type="checkbox" name="car[]" value="Audi">Audi<br>
<input type="checkbox" name="car[]" value="BMW">BMW<br>
<input type="checkbox" name="car[]" value="Ford">Ford<br>

and code in codeigniter model is $this->db->where('car_name ==', $car[]); $this->db->get('cars');

Yes, It's working with $this->db->where_in('car_name', $car);.Thank you. — AnkitJ
– AnkitJ, Commented Jul 31, 2015 at 10:03

Sougata Bose · Accepted Answer · 2015-07-31 09:55:04Z

3

Use where_in -

$this->db->where_in('car_name', $car);

answered Jul 31, 2015 at 9:55

Sougata Bose

31.8k8 gold badges52 silver badges89 bronze badges

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

Comments

Deenadhayalan Manoharan · Accepted Answer · 2015-07-31 10:04:24Z

1

Try this...

Generates a WHERE field IN ('item', 'item') SQL query

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

Ref:https://ellislab.com/codeigniter/user-guide/database/active_record.html

answered Jul 31, 2015 at 10:04

Deenadhayalan Manoharan

5,45214 gold badges33 silver badges50 bronze badges

Collectives™ on Stack Overflow

How to compare array value with column in codeigniter database query

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related