Using array as a condition in where clause codeigniter

Question

I have the problems using the array input as a value in WHERE clause.

But don't want to use more than once in WHERE clause code.

In my case, this is what I want :

$cond = array('job_id' => $job_id_var, 'job_name' => $job_name_var);
//WHERE clause
$this->where($cond); //only using once WHERE clause code like this, array as input
//which means
WHERE job_id = '$job_id_var' AND job_name = '$job_name_var'

is it possible to do that in codeigniter?

It is possible in codeIgniter. $this->db->where($cond);

MH2K9
– MH2K9

2014-11-11 03:04:13 +00:00
Commented Nov 11, 2014 at 3:04 — MH2K9
– MH2K9, Commented Nov 11, 2014 at 3:04

Kevin · Accepted Answer · 2014-11-11 03:03:44Z

2

Yes, the ->where() method can support that.

Since you do not want to cascade it:

$this->db->where('job_id', $job_id_var);
$this->db->where('job_name', $job_name_var);

->where() can handle array input as well:

$cond = array('job_id'=>$job_id_var, 'job_name'=>$job_name_var);

$this->db->where($cond); // here, only used once.

$query = $this->db->get('hello_table');
$result = $query->result_array();

return $result;

answered Nov 11, 2014 at 3:03

Kevin

41.9k12 gold badges57 silver badges72 bronze badges

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

Collectives™ on Stack Overflow

Using array as a condition in where clause codeigniter

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related