Codeigniter How to in Array use where OR, AND clause [duplicate]

Question

I am looking for query in Codeigniter works like where OR, AND both works.

This is working Perfect!

$srcArr2['emp_id']=8;
$srcArr2['status']='2';
$this->db->where($srcArr2);
$query = $this->db->get('tickets');
$res = $query->result_array(); // as array
print_r ($res);

query is:

Need to add OR in where with $srcArr1['ass_id']=12; I try but not working.

$srcArr1['ass_id']=12;
$srcArr2['emp_id']=8;
$srcArr2['status']='2';
$this->db->where($srcArr2);
$this->db->where_in($srcArr1);
$query = $this->db->get('tickets');
$res = $query->result_array(); // as array
print_r ($res);

Thank You, in Advance for help

Rahul · Accepted Answer · 2019-05-22 09:39:50Z

1

You can use or_where_in to achieve the same,

$this->db->or_where_in($srcArr1);

Official doc.

answered May 22, 2019 at 9:39

Rahul

18.6k7 gold badges43 silver badges64 bronze badges

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

Comments

Pavan Gosavi · Accepted Answer · 2019-05-22 10:11:15Z

1

$this->db->where($srcArr2);
$this->db->or_where($srcArr1);

https://www.codeigniter.com/user_guide/database/query_builder.html#looking-for-specific-data enter link description here

answered May 22, 2019 at 10:11

Pavan Gosavi

312 bronze badges

Collectives™ on Stack Overflow

Codeigniter How to in Array use where OR, AND clause [duplicate]

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related