multiple where condition codeigniter

Question

How can I convert this query to active record?

"UPDATE table_user   SET email = '$email', last_ip = '$last_ip'   where username = '$username' and status = '$status'"; 

I tried to convert the query above to:

$data = array('email' => $email, 'last_ip' => $ip); $this->db->where('username',$username); $this->db->update('table_user',$data); 

How about using the where clausa status?

# must i write db->where two times like this? $this->db->where('username',$username); $this->db->where('status',$status); 

I also tried this:

$this->db->where('username',$username,'status',$status); 

Answer 1

you can use an array and pass the array.

Associative array method: $array = array('name' => $name, 'title' => $title, 'status' => $status);  $this->db->where($array);   // Produces: WHERE name = 'Joe' AND title = 'boss' AND status = 'active' 

Or if you want to do something other than = comparison

$array = array('name !=' => $name, 'id <' => $id, 'date >' => $date);  $this->db->where($array); 

Answer 2

Yes, multiple calls to where() is a perfectly valid way to achieve this.

$this->db->where('username',$username); $this->db->where('status',$status); 

http://www.codeigniter.com/user_guide/database/query_builder.html